Interested to Buy Any Domain ? << Click Here >> for more details...
my table having data like this
year month revenue
2011 jan 100
2011 feb 200
2011 mar 150 like this
i want My report
2011 jan 100
2011 feb 100+200=300
2011 mar 300+150=450
like this for this where we specify the condition how will
specify? pls ans me pls...
- 1 Answers
- 4284 Views
- I also Faced
- E-Mail Answers
Answer / ramachandra
Hi,
You may get solution by using data item,here i can the procedure how to do it..
Step 1; drag required year, month,revenue to the report page
Step 2: pause on query explorer select query1 then drag data item into data items(it displays expression box) write condtion like "running-total ([revenue])" then test it press ok.Rename it as Total.
Step 3: then drag total(dataitem) to report page.
Step:then run the report .
-Ramu
| Is This Answer Correct ? | 12 Yes | 1 No |
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
What is Performance Tunning Test?
Can we test the report other than manual testing?
What are the different types of important services used in cognos?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
I want to run one page with filter and another page without filter, what is process?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
what is the use of layout component reference
if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............
cognos is holap or molap or rolap
What is meant by junk dimension?
Teradata 
