Can any one expalain the procedure for How to create a
Mastr Detail Report in Cognos 8.3 ver?
Answer Posted / pavan kumar
Def-: Two Data Containers can be merged by using common
query item is known as master Detail Report.
Procedure-:
1.)Take a List Report After that Add the following query
items to the List order_number,order_date,Staff_name and
Revenue.
2.)From toolbox drag the list drop beside the revenue.
3.)Add the following query items to the second list
order_number,product_name,Description and Quantity.
4.)From list2 select order_number from toolbar click on
cut.select the Quantity from datamenu select aggregate
click on total.
5.)From Data Menu select Master Detail Relationship click
on new link.From Query1 Select Order_Number,From Query2
Select Order_Number.
Click Ok.
Create a Group on Staffname Query item,
Create a Header on Staffname Query item.
Delete the Staffname HeaderCell,format the Header which is
created.
From run menu click on run.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can we insert all types of charts in a list report? what r the realtime prompts?
What is called a slice?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
How do you improve the performance of the Cognos Analytics report
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
How to a create header dynamically in a crosstab report in cognos 8.1?
how to perform single sign in cognos by using url?
what is the main advantage of impromptu over cognos reportnet?
-----------With out using DrillThrough how to do Reports?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
how u will design the report if the objects are available
What is the complex report you faced in real time?
What are the advantages of shortcuts?
What is drill down and slicing and dicing whats the difference between them?