Prev: Subscription w/ PDF attachment to Blackberry
Next: Changing size of parameter fields?
From: greenmtnsun on 14 Jan 2010 17:34
FYI: SSRS 2008 on SQL 2008, VS 2008, BIDS 2008.

I have a RDL that is very basic with a cascading parameter. At this stage,
it is only parameters because the actual intense data gathering wasn't
programmed because of the cascading problem.

This problem seems to be different than the other 3rd parameter problem that
was recently fixed in a cumulative update for SQL 2008. I ran this on a
server that has SQL Server 2008 cumulative update 1 and it did not work.
Reading through the bug fix seemed to indicate this is a different bug.

The first Parameter just gets the data that is available to it and displays
the drop down.
-- It Works
The second Parameter just gets data based in part on the choice from the
first parameter.
-- It Works.
The third Parameter just gets data based in part on the choice from the
first and second parameter.
-- It starts to work, but then breaks.
-- First it displays the choices of data.
-- Then you select the data just fine -- for a millisecond.
-- Then IMMEDIETLY after you select the data, it unselects it and
shows "Select a value".
-- When you post this report to the web, it works great! The bug
seems to be in VS BIDS.
The fourth Parameter just gets data based in part on the choice from the
first, second and third parameter.
-- It works when the report is executed on the web.
-- When the report is run in VS (BIDS) it never makes it to the
parameter.

The report works great on my SSRS website which has SP1 (no cumulative
updates) for SQL 2008.

Why I even bothered to post it to my server is beyond me because the two
have never acted differently in this regard, but the hunch turned out to show
the problem in VS BIDS.

Any ideas? I'd be glad to send someone a RDL, but I don't get free tech
support from MS.

Thanks,
Keith
From: Bruce L-C [MVP] on 15 Jan 2010 11:24
I've seen this sort of thing before in RS 2005. A little different. In my
case the parameters would start flashing. Like you, they worked from the web
but not from the IDE.

If I had to guess I would say it is the parameter that is dependent on two
parameters that is causing the issue.

You have a work around and although a pain I don't think you should run into
this very often.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"greenmtnsun" <greenmtnsun(a)discussions.microsoft.com> wrote in message
news:FB1C601F-3CF5-4E9A-ACC2-1DE25BF88A73(a)microsoft.com...
> FYI: SSRS 2008 on SQL 2008, VS 2008, BIDS 2008.
>
> I have a RDL that is very basic with a cascading parameter. At this
> stage,
> it is only parameters because the actual intense data gathering wasn't
> programmed because of the cascading problem.
>
> This problem seems to be different than the other 3rd parameter problem
> that
> was recently fixed in a cumulative update for SQL 2008. I ran this on a
> server that has SQL Server 2008 cumulative update 1 and it did not work.
> Reading through the bug fix seemed to indicate this is a different bug.
>
> The first Parameter just gets the data that is available to it and
> displays
> the drop down.
> -- It Works
> The second Parameter just gets data based in part on the choice from the
> first parameter.
> -- It Works.
> The third Parameter just gets data based in part on the choice from the
> first and second parameter.
> -- It starts to work, but then breaks.
> -- First it displays the choices of data.
> -- Then you select the data just fine -- for a millisecond.
> -- Then IMMEDIETLY after you select the data, it unselects it and
> shows "Select a value".
> -- When you post this report to the web, it works great! The bug
> seems to be in VS BIDS.
> The fourth Parameter just gets data based in part on the choice from the
> first, second and third parameter.
> -- It works when the report is executed on the web.
> -- When the report is run in VS (BIDS) it never makes it to the
> parameter.
>
> The report works great on my SSRS website which has SP1 (no cumulative
> updates) for SQL 2008.
>
> Why I even bothered to post it to my server is beyond me because the two
> have never acted differently in this regard, but the hunch turned out to
> show
> the problem in VS BIDS.
>
> Any ideas? I'd be glad to send someone a RDL, but I don't get free tech
> support from MS.
>
> Thanks,
> Keith

 | 
Pages: 1
Prev: Subscription w/ PDF attachment to Blackberry
Next: Changing size of parameter fields?