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.
| Author |
Topic |
|
SallyWorc
Starting Member
5 Posts |
 Posted - 2012-04-19 : 03:29:05
|
| I'm getting the following error message when I try to run a report:An error has occured during local report processingAn error has occured during report processingFailed to evaluate the FilterValue of the DataSet 'DataSet2'The filter uses a parameter which gets values from its own dataset and the query runs fine. I am not given the option to select a parameter when running the report.Any suggestions or ideas??? |
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2012-04-27 : 10:28:53
|
| Can you post your dataset queries? That may make it easier to help. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 15:52:37
|
| have you set any default values for parameter? is it allowable value within filter?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
SallyWorc
Starting Member
5 Posts |
Posted - 2012-04-30 : 03:01:55
|
| I think it was trying to pass values to a multi value parameter that weren't in the available values list. I've modified the sql to stop that from happening and it seems to be working now |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 10:23:00
|
| great------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Failed to Evaluate Filter Value