Monday, March 12, 2012

Parameters not getting refreshed?

Hi All,

I am getting some wierd problem in my reports. I have deployed several reports on the server and when I am giving some parameters for the report, it does not take it and runs the report on complete database. What can be the reason.?

Few days ago, everything was working fine.

I was using a separate datasource for each report. But then I created a shared datasource. Can that be the reason?

Please help me out !!!

TIA

I have had this happen to me before as well, generally I have found it is because within the dataset for the report, the parameters have been dropped. to check, go to the Data tab for the report in VS, edit the selected dataset by clicking the "..." button

Then go to the parameters tab, make sure your parameters are displayed in there.

|||Another alternative to determining whether or not your parameters are functioning properly is to click out of the design mode and view the MDX query. There will be a "Query Parameters" button in the toolbar directly to the left of the "Prepare Query" and "Execute Query" buttons.

No comments:

Post a Comment