June 19, 2009 at 2:00 am
Hi
I have a report(rdl in SSRS 2005, version 9.00.1399.00) with a couple of parameters. One specific report parameter, say x, is loaded from a datset(a simple sql query). The value of x is assigned to one column of the dataset and the label is assigned to another column. I try to print the label of x in a textbox. In the preview, it works fine. But after deployment, whenever i change any other parameter and click on "view report", the label of x is assigned as NULL, due to which the textbox shows up as "#Error".
It works fine when i click on the refresh button. But i will have to refresh each time i click on view report. So my question is whether there is any way to refresh the dataset or retain the values(and labels) in the report parameter when i click on "view report"?
I have tried setting the default value of x as well, but there is no option there to assign a value to the label.
Any kind of help would be appreciated as i am new to SSRS.
June 19, 2009 at 9:24 am
It seems like you may be having some parameter dependence issues. Does you x parameter depend on how another parameter is set? If so, you need to make certain it is listed below that parameter in the parameter list.
-Luke.
June 22, 2009 at 12:50 am
Thanks Luke! that worked perfectly! i moved "x" to the bottom of the report parameters list and deployed it. Now it shows the label always.
Although x does not depend on any other parameter since it loads independently from a dataset, i am confused of the logic behind this solution.
Anyways job done!
June 22, 2009 at 7:09 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply