Have Impromptu 7.1
I have used older Oracle Report Writers & also Crystal Advance 9.0 with an introductory course in Cognos report writing.
Need to create a Profit and Loss report for Gas trading
which is made of of 1)Physical Gas Deals, 2)Financial (Swaps) & 3)Transport Charges. The data recorded for each deal is slightly different as are the columns to be displayed on the report. So indepenant headings for each query.
Is there a way in Cognos to build a report that can have 3 separate queries executed (the prompt that links them together would be a date) and summarize the totals from each query. Ideally a drill down on the results from the three queries to display the details if desired. Otherwise the report should be able to just print the totals and summerize them for the day.
Something like:
Heading
Physical Gas: total
Financials: total
Transportation: total
P & L for date: grand total
with each total being a drill down for that day's detail
I have used older Oracle Report Writers & also Crystal Advance 9.0 with an introductory course in Cognos report writing.
Need to create a Profit and Loss report for Gas trading
which is made of of 1)Physical Gas Deals, 2)Financial (Swaps) & 3)Transport Charges. The data recorded for each deal is slightly different as are the columns to be displayed on the report. So indepenant headings for each query.
Is there a way in Cognos to build a report that can have 3 separate queries executed (the prompt that links them together would be a date) and summarize the totals from each query. Ideally a drill down on the results from the three queries to display the details if desired. Otherwise the report should be able to just print the totals and summerize them for the day.
Something like:
Heading
Physical Gas: total
Financials: total
Transportation: total
P & L for date: grand total
with each total being a drill down for that day's detail