Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct records within subreport???

Status
Not open for further replies.

dwunz

Programmer
May 4, 2001
28
US
I have a collection of 3 reports...a primary and 2 subreports. In one of the subreports, I need to get distinct rows based on 2 of 3 fields (field 1 is a time stamp, and fields 2 and 3 are the fields that define distinctness)...field 2 is a substring (pos. 10 thru 29) of a 100 character field. Any idea how I can do this in CR8.5? I'm kinda new to CR, so be nice...
Thanks, don:)
 
I forgot to add...this subreport also uses 2 parameters from the main report to use a start and end time as part of the selection.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top