Cascading Parameters in Dev environment Convulsing

I'm usring RS SP2 and have a cascading parameter. Both parameters are drop
down list. When you change the first drop down, the dev environment goes
into convulsions and starts flashing. I've done some research and found this
issue in a few places on the net but have not found a solution. All
indications ar ethat it will work fine once deployed. Anyone know of the
solution to this issue or a work around?I don't have this happen with all cascading parameter reports, just some of
them. I don't have a pattern for when it happens and when it doesn't. For
those reports where this happens I test by deploying to a test server rather
than testing from the dev environment. As you say, they work when deployed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephen Farmer" <Stephen.Farmer@.LucrumInc.Com> wrote in message
news:eADozujWFHA.2448@.TK2MSFTNGP12.phx.gbl...
> I'm usring RS SP2 and have a cascading parameter. Both parameters are drop
> down list. When you change the first drop down, the dev environment goes
> into convulsions and starts flashing. I've done some research and found
> this issue in a few places on the net but have not found a solution. All
> indications ar ethat it will work fine once deployed. Anyone know of the
> solution to this issue or a work around?
>
>

Cascading Multivalue Parameters fail to populate in subscription view

SSRS - SP2

We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.

We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.

Any known issues with cascading multivalue parameters in the Report Manager subscription view?

I'm having the exact same problem. Did you get a fix or an answer?

Cascading Multivalue Parameters fail to populate in subscription view

SSRS - SP2

We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription.

We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters.

Any known issues with cascading multivalue parameters in the Report Manager subscription view?

I'm having the exact same problem. Did you get a fix or an answer?

Capture existing table

I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
it. When I did, my database(DEV_DATA) remained intact, but when I go in
thru Enterprise Manager, it is not located in the system tree, and is
therefore inaccessible. Can anyone suggest how I could get this database
included.Have you tried attaching the database?

On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
<wfoneill@.bellsouth.net> wrote:

>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>thru Enterprise Manager, it is not located in the system tree, and is
>therefore inaccessible. Can anyone suggest how I could get this database
>included.|||Hi Steve:

Thank you for replying. Using EM, how would I attach, since I don't see my
database in the tree at all. All the other databases are there from the
installation, eg. Master, Tempdb, Northwind, etc.

"Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> Have you tried attaching the database?
> On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> <wfoneill@.bellsouth.net> wrote:
>>I trashed SQL Server2000 when I added the WINXP SP2, and had to reinstall
>>it. When I did, my database(DEV_DATA) remained intact, but when I go in
>>thru Enterprise Manager, it is not located in the system tree, and is
>>therefore inaccessible. Can anyone suggest how I could get this database
>>included.
>|||"William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
> Hi Steve:
> Thank you for replying. Using EM, how would I attach, since I don't see
my
> database in the tree at all. All the other databases are there from the
> installation, eg. Master, Tempdb, Northwind, etc.

Best bet, don't use EM. Use query analyzer and use sp_attach_db

Otherwise, in EM on the machine in question, right click on databases and
select ALL TASKS and attach Database.

> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
> > Have you tried attaching the database?
> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
> > <wfoneill@.bellsouth.net> wrote:
> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
reinstall
> >>it. When I did, my database(DEV_DATA) remained intact, but when I go in
> >>thru Enterprise Manager, it is not located in the system tree, and is
> >>therefore inaccessible. Can anyone suggest how I could get this
database
> >>included.
> >>|||Thank you, Greg. Will give it a try!.

"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:f3c%c.13044$2s.12051@.twister.nyroc.rr.com...
> "William F. O'Neill" <wfoneill@.bellsouth.net> wrote in message
> news:zCb%c.74507$N11.62157@.bignews5.bellsouth.net. ..
>> Hi Steve:
>>
>> Thank you for replying. Using EM, how would I attach, since I don't see
> my
>> database in the tree at all. All the other databases are there from the
>> installation, eg. Master, Tempdb, Northwind, etc.
>>
> Best bet, don't use EM. Use query analyzer and use sp_attach_db
> Otherwise, in EM on the machine in question, right click on databases and
> select ALL TASKS and attach Database.
>
>>
>> "Steve Jorgensen" <nospam@.nospam.nospam> wrote in message
>> news:no3qj0hlgn4pmp743j6pmm18ne733ao1j6@.4ax.com...
>> > Have you tried attaching the database?
>>> > On Mon, 6 Sep 2004 21:17:03 -0400, "William F. O'Neill"
>> > <wfoneill@.bellsouth.net> wrote:
>>> >>I trashed SQL Server2000 when I added the WINXP SP2, and had to
> reinstall
>> >>it. When I did, my database(DEV_DATA) remained intact, but when I go
>> >>in
>> >>thru Enterprise Manager, it is not located in the system tree, and is
>> >>therefore inaccessible. Can anyone suggest how I could get this
> database
>> >>included.
>> >>
>>>
>>

Can't view Locks / Process ID

Hi,
We have SQL 7 running on Windows 2000 Server. For some reason we are
unable to view Locks / Process ID from workstations running Windows XP
SP2 with Enterprise Manager. Nothing shows up in the window on the
right. All it's says at the top of the window is "There are no items to
show in this view" If we use Enterprise Manager on the server, we can
view the Locks / Process ID. We can view both, Process Info and Locks /
Object from the workstations and server, just not the Locks / Process
ID. We used to, but I don't know what changed. I'm thinking it might
have to do with upgrading to XP SP2, or a Windows update, but I'm not
sure.
Has anyone out there experienced this? Or does anyone know the
solution?
Thanks,
MarkHave you tried reinstalling the Client tools on Affected boxes. Also if you
could start the profiler trace in the background and check if its running
any queries.
HTH
Vishal|||Vishal Gandhi wrote:
> Have you tried reinstalling the Client tools on Affected boxes. Also if you
> could start the profiler trace in the background and check if its running
> any queries.
> HTH
> Vishal
I have tried reinstalling the client tools. I even installed them on a
new PC. Same results. I don't know much about SQL, I did start the
profiler and it was capturing data. I'm not sure what you mean by
running it in the background and see if it is running any queries.
Thanks,
Mark|||Vishal Gandhi wrote:
> Have you tried reinstalling the Client tools on Affected boxes. Also if you
> could start the profiler trace in the background and check if its running
> any queries.
> HTH
> Vishal
I have tried reinstalling the client tools. I even installed them on a
new PC. Same results. I don't know much about SQL, I did start the
profiler and it was capturing data. I'm not sure what you mean by
running it in the background and see if it is running any queries.
Thanks,
Mark

Can't uninstall Analysis Services 2000

I have both SQL 2000 and SQL 2005 on my computer. I am running Windows XP Pro, SP2. SQL 2000 was installed first, then, 3 months later, SQL 2005 was installed, too.

My client needs me to work with SQL 2000 Analysis Services (my client is on a SQL 2K platform). I have the full SQL 2005 Developer Edition on my machine, along with the SQL 2005 Analysis Services, SSIS, Visual Studio, SSMS, etc. I also have SQL 2000 Developer Edition, but I don't see SQL 2000 Analysis Services on the machine nor running under services. In addition, there is no Analysis Services on my machine.

Therefore, I wanted to install SQL 2000 Analysis services onto my machine. However, when I do, I get the message:
"To install a new version of Analysis Services, you must first remove your existing version."

However, I cannot uninstall Analysis Services. It does not show up under Add/Remove New Programs in Control Panel. There is no MSSQLServerOLAPService service running. I do have a two Analysis Service services running with other names: BUCKNOFF2005 (which is, obviously, my 2005 Analysis Services) and MSSQLSERVER, which also displays in my SQL 2000 SQL Server Service Manager, so there might be some artifacts from an old install of SQL 2000 Analysis on my machine.

SQL 2005 Analysis Services runs fine, by the way.

So I am stuck. I can neither install nor uninstall. Bottom line, how can I uninstall SQL 2000 Analysis Services (without reformatting my hard drive or starting over again on another computer)? If I can do that, then I can reinstall it. Right now, as a temporary solution, I borrowed a laptop from my client and installed Analysis Services 2000 for the 2 days that I will be working with it -- but I need to get this fixed on my own laptop which I take from client to client.

AS 2000 should have separate entry in Add/Remove programs "Microsoft SQL Server 2000 Analysis Services".

If you dont have the entry, you dont have AS2000 installed on your machine.

Now about installing AS2000 on top AS2005.

You can try uninstalling SQL Server 2005 from your machine, installing AS2000 and then installing SQL 2005 back into the same configuration.

It is bit of the hassle, but looks like your are trying to fit pretty custom configuration into your laptop and you might need to work a bit harder to get there.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Hi,

Microsoft should warn people about this kind of things!!! It is completly ilogic and in terms of development it's a ***.

Best Regards

Jo?o Marto