p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Report design Quandry...


Message #1 by "Bill Dodd" <bill.dodd@s...> on Thu, 25 Apr 2002 15:47:11 -0500
Hiya all.   I have a wierd report I'm trying to duplicate in Crystal and
wanted to know if anyone knows how to do this:

The report detail (*can*) be two parts...
For instance...

qty    item   description   price



then, possibly:

*Note, this order contains parts
partqty  partitem  partdescription partprice



..  The data is conceptually in two different tables.   adding the second
table isn't a big deal, but when I add a second section to the detail it
deos this:
qty	item	description	price
partqty	partitem	partdescription	partprice
qty	item	description price
partqty	partitem	partdescription	partprice...


I'd like it to iterate through the first set of details and THEN go to the
second.  Can this be done?




Bill Dodd
Developer
Standard Furniture Mfg
(xxx)xxx-xxxx  extension 658
(xxx)xxx-xxxx  extension 658



Message #2 by "Bill Dodd" <bill.dodd@s...> on Fri, 26 Apr 2002 14:37:48 -0500
I figured it out.  Big duh.   By turning on and defining a Group in the
details and setting the group header as a formula field that changed based
on a flag.

Thanks anyway!


Bill Dodd
Developer
Standard Furniture Mfg
(xxx)xxx-xxxx  extension 658
(xxx)xxx-xxxx  extension 658



-----Original Message-----
From: Bill Dodd [mailto:bill.dodd@s...]
Sent: Thursday, April 25, 2002 3:47 PM
To: crystal_reports
Subject: [crystal_reports] Report design Quandry...



Hiya all.   I have a wierd report I'm trying to duplicate in Crystal and
wanted to know if anyone knows how to do this:

The report detail (*can*) be two parts...
For instance...

qty    item   description   price



then, possibly:

*Note, this order contains parts
partqty  partitem  partdescription partprice



..  The data is conceptually in two different tables.   adding the second
table isn't a big deal, but when I add a second section to the detail it
deos this:
qty	item	description	price
partqty	partitem	partdescription	partprice
qty	item	description price
partqty	partitem	partdescription	partprice...


I'd like it to iterate through the first set of details and THEN go to the
second.  Can this be done?




Bill Dodd
Developer
Standard Furniture Mfg
(xxx)xxx-xxxx  extension 658
(xxx)xxx-xxxx  extension 658







  Return to Index