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

Trying to pass a number from my Prompt Page to the Report Page

Started by KarenA, 16 May 2007 01:26:28 PM

Previous topic - Next topic

KarenA

I'm trying to create a report in Report Studio 8.1

On my prompt page I want to allow the user to enter in a dollar amount for a credit (I've added a text box prompt to do this).  I want to be able to use this amount in a calculation on my report page.  I can display my credit amount on the report, but I cannot perform any calculations or format it to currency. 

How do I set this up?

JoeBass

You should be able to create a Data Item, cast the parameter value inside and do math with it.  Then, format the result to currency with the data format property from the page layout.

MDXpressor

As a second option, you should be able to just drop a Layout Calculation on the page and pull in the prompted value.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

varshams

Even i am facing the same problem. In my case user enters year and i need to subtract 10 from that year.
So if user enters 2007 , i need to get data from 1998 onwards. I tried adding data item. but i really cant do anything with that.
Can you explain with examples?

thanks,
varsha

JoeBass

Here is a report that uses the go sales and retailers package.  It has a layout calculation like MDXpressor suggested and a data item added to a query.  If you only need the item for display purposes, the layout calc will suit your needs.