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

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

Other recent topics Other recent topics