HI,
I have a query in report studio which takes the filter to match against the selected parameter on prompt page. The filter condition is like
[QueryModel].[tablename].[columnname] in (?prompt?)
When I validate the filter I see the values. However when I run the query to view tabular data, the prompt filter does not display any values.
I have checked the sql against the database which is the source and it works fine. I have also tried to hard code the values of prompt in the filter but do not get any results.
When I test in Framework Manager, I get all the rows back.
This is stalling our production move..any help would be greatly appreciated.
Thanks,
DRL
Quote from: DRL on 29 Jul 2010 08:56:31 AMHowever when I run the query to view tabular data, the prompt filter does not display any values.
Do you mean you are using the 'view tabular data' option in Report Studio? If so, try running the report normally.
If you are still having problems, the next thing to check is whether you have a hard-coded prompt in the report based on an empty or non-existant prompt query.
Cheers!
MF.