If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter does not show up values

Started by DRL, 29 Jul 2010 08:56:31 AM

Previous topic - Next topic

DRL

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

MFGF

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.
Meep!