RE: [CFTALKTor] Reporting tools

[Steve Budan]

Sorry I haven't used CR since about version 6. But that said generally if you have a parent record, it should have a key or some field that you use to lookup any child records.   <cfquery etc>     select * from parent talbe   <cfquery>   <cfoutput>     <cfquery etc>         select * from childe tables             where parent.id = child.parent_id     <cfquery> </cfoutput> There are lots of ways of doing this. This is probably the simplest and most inefficient. You could also use SQL to retrieve the records -steve        -----Original Message----- From: Dimitri Abramov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Reporting tools That is what I use. But I can not figure out how to output parent-childe structure. I saw one article on crystal support website where they sad this is impossible. Any ideas how to do that?   Dimitri -----Original Message----- From: Steve Budan [mailto:[EMAIL PROTECTED]] Sent: March 27, 2002 10:57 AM To: '[EMAIL PROTECTED]' Subject: RE: [CFTALKTor] Reporting tools Crystal reports   http://www.crystaldecisions.com/reporting/   Steve Budan Cold Fusion Developer Baxter Corporation AUTROS POINT OF CARE System One Yorkdale Road, Suite 310 Toronto, ON M6A 3A1 (416) 784-1100 ext. 182 -----Original Message----- From: Dimitri Abramov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 10:43 AM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Reporting tools Does anybody know a good reporting app. which would allow to output up to 500 pages report, handle complicated database structure and parent - child relationships?   Any suggestions will be appreciated.   Sorry I am a little off topic.   Dimitri