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
- 4197 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What junk dimension contains?
What is the size of database for you project?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What are the methods by which it non-durable model could be changed into the durable model?
-----------With out using DrillThrough how to do Reports?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Define the cognos reporting tool?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is the use of powerhouse?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
------------------What is Inline Query?
what is the procedure for scheduling conditional rendering?
What are initial page components of Cognos connection?
What is defined as Cognos Impromptu?
