Can any one expalain the procedure for How to create a
Mastr Detail Report in Cognos 8.3 ver?
Answer / 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 |
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
Explain the different types of views used in cognos.
what is report studiio and how to start it?
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
What is called a slice?
what is differences between the group span and levelspan
What is a Transformer?
How can you link a query to a data container manually in Report Studio?
What are the steps to import the two data sources in framework manager?
What is difference between page break and section report?
What are the components of the report studio?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)