give me scenario on cascading prompts&master-detail relation
Answer Posted / pavan kumar
CascadingPrompt-: A Prompt which displays the values from
another prompt is known as cascading prompt.
Master-Detail RelationShip: Two data containers can be
merged using common query item.
Procedure: Add the following query items to the list
ordernumber,ordername,Staffname and revenue.
2.)From tool bar drag the list drop beside the revenue,Add
the following query items to the second list
ordernumber,productname,description and quantity.
3.)From Second list select ordernumber from tool bar click
on cut.
4.)Create a total on quantity.
5.)From Data Menu Select Master-Detail RelationShip click
on new link from Query1 select ordernumber Query2 select
ordernumber.
6.)Create a group on staffname query item, Create a header
on staffname query item.
7.)Delete the staffname header cell,format the header which
is created.
8.)From run menu click on run the report.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
how to connect datamarts
What is the difference between drill through, drill across?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is Metrics designer?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Define cognos report net?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What junk dimension contains?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Diff b/w Crossproduct and Outerjoin?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is called a slice?
in u r data u having duplicates how to fetch the latest data in our report?
What are all the types of report?