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 |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2009-02-26 : 11:38:13
|
| I am getting this error: "Failed to evaluate the FilterValue" when I try to preview a report. Here is my scenario and what I am trying to achieve:Goal: Generate a report with patient names and their email address when an office is selected.Scripts: I have one dataset set as Stored Procedure which generates a list of all my open offices. There are about 215 offices. I have another dataset that is set as Text which is the query that generates the names and email address based on the parameter of the first dataset.Result: When I run this in Data mode, I get a Define Query Parameter pop up and I enter an office in the Parameter Value. It returns for me valid results. However, this does not work when I go to Preview mode, I get that error.Is it possible for the parameter to be a dropdown list of all my offices? |
|
|
andros30
Yak Posting Veteran
80 Posts |
Posted - 2009-02-27 : 10:01:42
|
| This is resolved. |
 |
|
|
|
|
|
Help with FilterValue