Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crystal Report Complex Design Issue Post Reply Post New Topic
Author Message
VenkateshVaraka
Newbie
Newbie
Avatar

Joined: 04 Nov 2007
Location: India
Online Status: Offline
Posts: 5
Quote VenkateshVaraka Replybullet Topic: Crystal Report Complex Design Issue
    Posted: 04 Nov 2007 at 10:55am

Hi,

I have problem in designing the report (Crystal Report 9.0) with multiple groups wih a sub report in each group with a a group header and footer with a

detail section in each report.

My requirement is as follows.
1) Xxxx-sub report
will have one header conetnt and footer content and detail ection in the middle grouped on one parameter
2) Yyyyysub report
will have one header conetnt and footer content and detail ection in the middle grouped on one parameter
3) Zzzzzsub report
will have one header conetnt and footer content and detail ection in the middle grouped on one parameter
4)ABCdsub report
will have one header one footer in group headers grouper on two prameters, My requirement demands customised detail section i.e.
static conetent followed by detail section and a static conetnt(which should not repeat with child table records,should come only once with the a record and

s) and detail section.

example:

main table of the sub report 4 has records m1,m2,m3,m4... and child table has

m1c1m,m1c2,m1c3,m1c4,m2c1,m2c2,m2c3,m2c4,m3c1,m3c2,m3c3,m3c4,m4c1,m4c2,m4c3,m4c4...

The staic content should come only with m1,m2,m3,m4 not with m1c1,m1c2....
like this I need in two places in the same report which may have 500 recors printed in single report.


all the above section should be suppressable with a condition including the top 3 reports.

I am able to get the top 3 reports as per the requirement but my forth sub report is getting displayed after each sub-group 1,2,3 which is not happening with

1,2,3. Only 4th set is repeating with 1,2,3.

THis report is attached with 6 datasets.

I linked the main report main table with 1,2,3 (main Table) report filling table but when I am trying to link the 4th table main table  I am able to link but

I am not getting the result on the report.
All the dataset has the one common column. sub report 1,2,3 are filled with common datasets with condition suppressing where as 4th report is filled with

different results .

1) My question is why the 4 the report is report is repeating with 1,2,3 why 1,2,3 are coming as expected.
2) Is it possible to create

Please help me in designing the report as per the requiremnt and suggest me if I need any design modifictions.

Your suggestions and inputs are highy appreciated.
Thanks for sparing time in going through my problem and I will be grateful if give solution and share if you have similar experiences.

Thanks

Venkatesh Varakala.

 
 
 
Venkatesh Varakala-Systems Analyst
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.031 seconds.