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?
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.
As a second option, you should be able to just drop a Layout Calculation on the page and pull in the prompted value.
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
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.