Cascading parameter doesn't work right in BIDS, but works fine in Report Manager Website
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 WorksThe 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
January 14th, 2010 8:35pm

Hi, Can you provide information on the expression that you have used for 3rd & 4th parameters. Thanks.-Nitin Pawar
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2011 10:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics