SQL Server Reporting Services 2005 Postback Issue
I have a Reporting Services 2005 report which uses cascading parameter multi-select drop-down boxes. The report runs perfect after making initial selections. However, each subsequent parameter selection causes the page to refresh to a blank page until the View Report button is clicked. What I would like to happen (which should be the norm) is for the user to be able to make all necessary selections without the page auto-refreshing after each selection. The user would then click the View Report button to regenerate the report. We are currently using reports which contain up to 5 cascading parameters. This becomes very time-consuming when the page refreshes after each selection.
Has anyone come across a solution or code alternative to this problem??
Any help would be most appreciated.
Thank you.
Here's One Option I Think Will Help ...
This is a frequently reported problem that results from the presence of code in the default expression, such as defaulting a date, etc. Using VB, other syntax, or even just "=1" is enough to force reevaluation in RS. Even in simple espressions (such as "=2007"), the presence of the equals (" = ") sign appears to trigger reevaluation by RS - unfortunately every time any other param is changed. This causes the "postback" you describe - and an underwhelming waste of time for the information consumer.
A fairly simple workaround can be effected via conversions of the VB expression(s) involved into datasets that return values based on an SQL statement.
For a very clear, detailed discussion of the issue and the workaround option I'm suggesting, see the following:
http://maxqtech.com/CS/blogs/david_l...2/08/3520.aspx
A quick read of this short, well-written blog entry will be well worth your time, if you want to provide a user-friendly interface that doesn't force a refresh of each parameter with any change to params, etc.
Let us know if this does it for you!
Bill
Thanks for the Feedback ...
Thanks for letting us know I was able to help ... Keep us posted on progress!
Bill
Looks Like the Page is No Longer in Place ...
I'll see if I can locate it ... if not, I'll post a transcript / summary ... I have a copy ...
Bill
Two References with Discussion ...
Still pursuing the missing link (a la Darwin, I suppose ...), but here are two discussions with guidance ...
http://forums.microsoft.com/MSDN/Sho...84284&SiteID=1
http://www.codeprof.com/dev-archive/...82-844199.shtm
Please e-mail me at [email protected] , if you still need the original article.
HTH,
Bill
Send Me Your Contact Info ...
Send me an e-mail address, and I'll get it you an abstract ...
Bill
Just Sent You a Copy via E-mail ...
Sorry re: any delay.
HTH,
Bill
Having issues with parameters and reporting services
Seems I'm not the only one that gets the "Report parameter values must be specified before the report can be displayed. Choose parameter values in the parameters area and click the Apply button." error. It was working fine until today when I added new reports to a Sharepoint site. Any ideas on how to fix this?
for all those looking for the missing link...
Here is an archived copy of that missing article, from your friends at the WayBackWeb :D
http://web.archive.org/web/200708240...2/08/3520.aspx
group by more then one value
in my table I have colum call FeeType
the possible values :
Fee 1st Installment
Fee 2st Installment
Hall Fee 1st Installment
Hall Fee 2nd Installment
other Fee
special fee
if I want to group by
(Fee 1st Installment
Fee 2st Installment) in one group, (Hall Fee 1st Installment
Hall Fee 2nd Installment) in second group, and others on the third group . what can I do?
________
Rolling A Joint