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

Display only the last running-count row data in MD report

Started by bioCam, 12 Aug 2010 08:40:50 AM

Previous topic - Next topic

bioCam

Hi all,  hope you can help me with this ...my report has 2 blocks; 1st has TABLEs for Master information, the 2nd is a REPEATER with TABLEs for Detail information.

Master: Cust_Code, Cust_Name, Address, Telephone etc...
1101, Jane Doe, 1101 Bow Ave, 111-1101
5520, John Boy, 5520 Arrow Lane, 555-5520
9909, Mary Jane, 9909 Zak Street, 999-9909

Detail:
Cust_Code, Store,      Complaint_Date, Complaint_Type, Comments,             Store_Running_Count
1101,      Downstreet, 2010-01-01,     Type1,          'Comments from 1101-1', 1
1101,      Downstreet, 2010-01-11,     Type2,          'Comments from 1101-2', 2
1101,      Downstreet, 2010-01-21,     Type3,          'Comments from 1101-3', 3
1101,      Catalley,   2010-02-01,     Type2,          'comments from 1101', 1
5520,      Darter,     2010-03-01,     Type3,          'comments from 5520', 1
2323,      Darter,     2010-03-01,     Type3,          'comments from 2323', 1


Report:
Customer Name: Jane Doe    Address/Phone: 1101 Bow Ave (111-1101)
--------------------------------------------------------------------------------------------
Store: Downstreet
Complaint: Type1, Type2, Type3
Comments: Comments from 1101-3
--------------------------------------------------------------------------------------------
Store: Catalley
Complaint: Type2
Comments: comments from 1101
--------------------------------------------------------------------------------------------

I create the Running-Count as I thought I can use this to control the last row to be displayed.  But now, I am a little lost what to do; not sure how I can use this now - to get RS to display only the last Comments. I am able to display all the Complaints in a row so that's not a problem.  Any help is appreciated.  Thank you.