Hi, From a aspxpage I was able to Pass values (valid values) for the parameters to SSRS report 2005 which uses OLAP cube as datasourceand got back the expectd result. but whenI pass value other than a valid value i am getting ERROR message. do wealways have to pass valid values only? any help is greatly appreciated. Thanks, Srik

What do you mean by a valid value? What is the error message? I always pass a string so I'm not sure how the value could be "invalid", unless of course the type of parameter that your sproc is expecting is different from the type you have passed.

My real problem is below From a aspxpage I was able to Pass values (valid values) for the parameters to SSRS report 2005 which uses OLAP cube as datasourceand got back the expectd result. but whenI pass value other than a valid value i am getting ERROR message. . For example I have data for the dates march 15th as "from date"and March 20th as "end date" and if i pass the same values i am getting the report output. But If I pass March 1st and March 30th I am getting the following error. "An error has occurred during report processing." AnyHelp?. Thanks, Srik

What is your SQL query? Are you using BETWEEN?

Are you using MDX?What's your query? If I understand correctly, you're running into an issue where someone might select a date and it's trying to pull data from the cube from a date that doesn't exist? Maybe?

Hi, i have a new problem. i am creating a datamodel foradhoc reports. i have a database which stores data belonging to multiple clients. the client shoud see only his data.i have to apply the client ID as implicit filter while showing data in areport. i am using reportviewer control for showing data on the web application. is this a correct option? i can pass the value for client id only if i add the clientid parameter to prompt in the designer. let me know if this is not correct. then there is every chance of user changing the value as it will be visible on the reportviewer along with other parameters. so i want to resetthe appropriatevalue for this parameter before passing it to the report. there are no events in reportviewer which allows me to change the parameter values before submitting. can anybody tella way to do this? Thanks in advance. Srik

HI, can anyone tell how to create a hyper link on a report that is developed in the report builder? this is very important for my module. Thanks, Srik

HI, can anyone tell how to create a hyper link on a report that is developed in the report builder? this is very important for my module. Thanks, Srik I have this problem too... help please!SetarehShop.ir