If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

master detailed - urgent

Started by sg24, 22 Mar 2011 01:31:25 AM

Previous topic - Next topic

sg24

Hi All,

I have a report with 6 queries and two prompts one for sand the report looks like this way.
EMp name:
Basic emp info :

Name : AAA                                                                   EMP ID: A33338

Reporting Manager : Navfg                                           Date of joining:20/12/08

Businees Unit : ghy                                                     Title : hguy

Aspirations of Assoicate:

mkjijm
TMP Period :
Start date : 12 jan 2011                                       end date : dec 31 2999

engagament plan:
(list with few col)
career plan:
(list with few col)
dev plan:
(list with few col)
Training solu:
l(ist with few col)   

Now i have more than one engagament and other plans means the history records coming in. and in my report it , in the TMP period section it shows start date and end date : like this way: 12 mar 2001 , 14 nov 2009 etc. more than one record coming in.  for both start date and end date.
i decided to create a master detail report by creating one more report page which looks the similar way as it is in my first page , but how do i link the queries as i have different queries.
?
Please suggest how this could be done.

Thanks,
Sg