Cascading parameter doesn't work right in BIDS, but works fine in
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
-- 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
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.