Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: crystal report implementation Post Reply Post New Topic
Author Message
cognos79
Newbie
Newbie


Joined: 28 Aug 2008
Online Status: Offline
Posts: 4
Quote cognos79 Replybullet Topic: crystal report implementation
    Posted: 03 Sep 2008 at 11:34am

I need help with the crystal report design and implementation. I want to show accident related information on the report. The report will look like below: All the information is grouped on accident id in the database. One accident will have only one site and can have one or more than one comments and injured persons.

 

From sql query point of view the query will return 4 records. I am thinking I should create one subreport to show comments info and one to show injured person information.

So in total there would be 3 reports needed to output one report.

Is way to implement this without using subreports ??? or subreports is the only way.

 

Accident ID           Site                       Location

A1                          Downtown            Arch street

 

 

CommentId                 Descr

1                                                  negligence on driver

2                                                  poor visibility

 

 

 

Injured_person_name           Injured_person city

Mike                                       philadelphia

Steve                                      newyork

 

 

 

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 03 Sep 2008 at 1:45pm
I think you could do it with just one subreport. For the first section on comments, include that in the main report and group on Accident ID. PUt the accidnet info in the group header. Then for the second section do a subreport but put it in the group footer. That will make sure it comes out after the comment records are printed.
 
I have lots of report formatting tips and tricks in the Advanced Formatting chapter of my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
cognos79
Newbie
Newbie


Joined: 28 Aug 2008
Online Status: Offline
Posts: 4
Quote cognos79 Replybullet Posted: 04 Sep 2008 at 7:13am

Brian, thanks for your reply. Just for a sample I told I have two box'd sections. But I have quite a few box sections similar to those in the report. So I guess I have to add one subreport for each boxed item???

IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.018 seconds.