Sql Server 2008 -- Report Model used in Report Builder
Hi,
I am working on Sql server 2008- BIDS. As per the requirement, I used report model in report builder.But this report has cascading parameter(dependency parameter)also it has dynamic fields.. Based on this crateria fileds are display and report
is generated. In Report model I used view. For parameter, I can set one parameter with report by using Filter-Prompt option. But the problem is, i can not set the cascading parameter. As example after selecting first parameter it should
be allow to select the second parameter(based on first selection) and after the second parameter , it allow to select third parameter and so on......
To resolve this problem i already tried with named query with parameter(@prompt), but i didnt help.It gives the error -- please declare the scaler variable.
anybody have an idea how i can add casecading parameters ? but it must be based on reporting model.
Thanks,
December 28th, 2010 11:32pm
Hi,
Based on your error message, the root cause might be relevant to your incorrect method of creating cascading parameter. So I would recommend you
follow this link to get a reference about how to add cascading parameters to a Report, please see:
How to: Add Cascading Parameters to a Report (Reporting Services)
Thanks,
Ai-Hua QiuAi-hua Qiu[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2011 8:45pm