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

Adding Manual Number to Prompt Page

Started by gatorfe, 15 Jun 2010 04:51:54 PM

Previous topic - Next topic

gatorfe

I have a report that shows an employee id and the amount of hours worked.  The report spec ask that when the user runs a report they be able to enter a monthly target number in the prompt page of the report for the number hours they should work.  That value they entered would be used in a new formula in the report that subtracts the target they entered to what they actually did.  I was playing around with a text box prompt as that allows the user to enter a value in the prompt page but not sure what the setup is to be able to use it on the report side. Any insight would be appreciated!

Thermos

yes you can use the value from a parameter in the report.  for example in the query explorer if you add a detail filter in the expression window that opens you will see tabs in the bottom left hand corner.  the last one is parameters.