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

Is it possible to display an expression in a report?

Started by seballen, 20 Mar 2012 10:19:47 PM

Previous topic - Next topic

seballen

Similar to showing a parameter on the page, I'd like to print out an expression. Any way to do this?

Thanks,
Sasha

blom0344

Expression?  Do you mean the definition of a calculated data-item?  Can you be more specific where you are after.

seballen

The report has certain diagnosis numbers hard-coded in a filter. I was wondering if I could display that filter on the report somewhere. I had just copied the codes in the filter into a text item at the top of the report, but every time I change the filter, I need to remember to update the text item.

Thanks,
Sasha

blom0344

This is fairly simple when the filter is applied from a promptquery and the paramdisplayvalue is used to print the filter values in a report expression. I doubt you can do it the way you want even by Java code (as the filter can not be identified by name) , but sure like to be proven wrong

seballen

I'd love it if someone could prove you wrong too  :)

I display the paramdisplayvalue and even considered defaulting  the diagnoses codes in a parameter so I could display them, but it seems like a lot of overhead to worry about. The diagnosis codes are unlikely to change by user request...

Lynn

You can try to create a prompt control for your diagnosis codes and then specify default values as the ones you want....then just hide the prompt control since users don't need to see it or control the values. Then you can use the paramvalue or paramdisplayvalue function.

I'm reasonably certain this would work, but I didn't try it.

S2000

I'd make a filter based on a paremeter.
Then on the prompt page create a hidden text prompt set to auto submit that contained the values I wanted to filter.
Then use the normal Paramdisplay to show the values of the parameter.

When you needed to change the filters you'd just change the defaults in the prompt rather than the text in the filter.

If there is no prompt page you can just put the prompt on the report page.