COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: paloalto_cognos on 06 Aug 2010 01:24:05 PM

Title: three query calculations in a footer
Post by: paloalto_cognos on 06 Aug 2010 01:24:05 PM
Hi ,

I have to drop three different query calculation in a footer or possibly something like in three rows below the list. Can any one please help me how to do it.

Thanks
Title: Re: three query calculations in a footer
Post by: mvjcognos on 11 Aug 2010 01:42:45 AM
1) 1st tell me this 3 query items belongs to main report query or separate query.
2) If it is main query then associate the main query with entire page.
3) Then take a 3 column and 1 row table in that directly place the 3 data items.
4) If it is not in main query then take a 3 column and 1 row table in the footer and place a repeater or singleton in the three columns, then that 3 items will create 3 queries in the query explorer and create ur respective data items in the repective queries and place the data items in the footer.......