Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report parameter error

Author  Topic 

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2008-10-27 : 07:47:40
Hi,

I have a set of parameters at the start of the report, once the their selected, the page is refreshed and what is selected in cleared.

Has anyone ever encountered this sort of error before?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 08:01:51
to avoid refreshing, try to provide any dependencies between them. Make sure you dont pass value of one parameter in dataset for another parameter. ALso dont use = while specifying default values in parameters tab for params.
Go to Top of Page

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2008-10-27 : 08:04:48
I have 3 datasets,

one for the report form/layout and 2 for parameters. I select first parameter value and the page refreshes and clears the selection. No idea why.

quote:
Originally posted by visakh16

to avoid refreshing, try to provide any dependencies between them. Make sure you dont pass value of one parameter in dataset for another parameter. ALso dont use = while specifying default values in parameters tab for params.

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-27 : 08:08:12
quote:
Originally posted by cipriani1984

I have 3 datasets,

one for the report form/layout and 2 for parameters. I select first parameter value and the page refreshes and clears the selection. No idea why.

quote:
Originally posted by visakh16

to avoid refreshing, try to provide any dependencies between them. Make sure you dont pass value of one parameter in dataset for another parameter. ALso dont use = while specifying default values in parameters tab for params.




check if
1. Dataset for parameter1 population contains parameter2 as one of parameter
2. you dont use = for specifying default value in parameter tab.
Go to Top of Page
   

- Advertisement -