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

Parameter in RS

Started by johny.cbi, 09 Aug 2010 10:32:40 AM

Previous topic - Next topic

johny.cbi


I've problem with Paratmeter in report studio. The column works fine with Hard coded value

when I select a particular field in value prompt, the report breaks

can any one explain ? Thanks for your ideas



dlafrance

Can you give us the error message please ?

johny.cbi

No error message here : when I run the report after selecting the prompt, reports shows blank white/ page

tupac_rd

is it because use value is different and display value is different and you might be using the wrong thing in the filter... just a wild guess...

johny.cbi

use value is different and display is different. Here I'm using static choices and if I hardocode the filter it shows the correct value. If I use drop down and select the field from drop down the report breaks.
I used the correct values from the Data Base

Lynn

Sounds like something is wrong with the query that populates the drop down. Perhaps the values don't exactly match the database column you are filtering on (e.g., char vs. varchar where 'ABC' <> 'ABC    ').

I don't think the report breaks, I think it is just filtering for a value and finds no matches. Try putting a no data handler on your list to display a message 'no data' or something like that. Then you can confirm if that is the case or not. Also look at the generated SQL for both approaches to compare and see what is different about the hard coded value vs. the parameter selection.