Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Multiple subreports - eliminate duplicate strings Post Reply Post New Topic
Author Message
Crystal4galaxy
Newbie
Newbie


Joined: 21 Dec 2009
Online Status: Offline
Posts: 1
Quote Crystal4galaxy Replybullet Topic: Multiple subreports - eliminate duplicate strings
     Posted: 21 Dec 2009 at 11:11pm
Hello,
 
Very newbie here, hoping for some enlightenment!
 
This is a hotel based report for guest preferences.
 
The report contains 2 subreports.  Some of the strings in the subreports are identical to each other and are currently showing in subreport.  Is there a way to filter the subreports so that comments are not duplicated between reports?  Ie. the ones that I have put a cross through below.
 
Many thanks for any advice...
 
 
eg.
 
Main report: Guest Name
 
Sub rpt 1 - Current Preferences/Comments:
A - Guest likes red apples
B - Guest has a message waiting at the concierge desk
C - Guest is married with 3 children
 
 
Sub rpt 2 - Historical Preferences/Comments:
A - Guest likes red apples
C - Guest is married with 3 children
 
IP IP Logged
majki
Newbie
Newbie
Avatar

Joined: 22 Dec 2009
Location: Poland
Online Status: Offline
Posts: 13
Quote majki Replybullet Posted: 22 Dec 2009 at 4:16am
Hi, Maybe it's not straight the solution you need, but you can somehow do workaround, by using 'union (all)' statement in SQL query (union already use distinct, union all - not)
Instead of using two sub-reports, get both in one sql query. As I can see on example, number of columns and their type are the same, right?

Is it possible to do in your case?

Anyway, if anybody knows how to do this with two sub-reports, it would be good to see.

regards,
M.
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.