SQL Server 2008 Reporting Services cascading prompts.

re: SQL Server 2008 Reporting Services cascading prompts.

Andrew.Fryer — Wed, 02 Nov 2011 10:45:43 GMT

Rahul. You might need to contact support to get to the bottom of that, having patched your installation. 2008 SSRS is faster then 2005 so other things to check are that your queries for the parameters are fast and that the indexes etc. you may have had in place in 2005 are all still OK

Andrew

re: SQL Server 2008 Reporting Services cascading prompts.

Rahul — Thu, 27 Oct 2011 16:39:05 GMT

My cascading dropdowns worked fine in 2005 but in 2008, it is a mess. I have the same country, state, city thing and if you change any, it freezes sometimes (not everytime) and the report is unusable.

re: SQL Server 2008 Reporting Services cascading prompts.

harpreet — Thu, 16 Sep 2010 19:52:45 GMT

And now bigger messes in ssrs 2008 with cascading parameters. If the query for parameter default values return no records, user gets an error message. The parameter does not recognise "Allow blank values" and treats blanks as nulls.

re: SQL Server 2008 Reporting Services cascading prompts.

Josh — Thu, 12 Nov 2009 19:23:56 GMT

Actually this is not always beneficial. For example, I have 4 parameters and here are their dependencies:

1: none

2: 1

3: 1 and 2

4: 1 and 3.

So when I update the first parameter it updates the other 3. When I update the 2nd one it only updates the 3rd one and not the 4th one. Even though the 4th one should change because it is dependent on the 3rd one. This is causing major issues with the report not behaving how it should. Now I have also changed the parameter to "Always refresh" and I still get this issue.

Geek Lectures - Things geeks should know about » Blog Archive » SQL Server 2008 Reporting Services cascading prompts.

Wed, 19 Dec 2007 13:23:34 GMT

PingBack from http://geeklectures.info/2007/12/19/sql-server-2008-reporting-services-cascading-prompts/