Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subreport relative positioning Post Reply Post New Topic
Author Message
Aravind
Newbie
Newbie


Joined: 18 Feb 2013
Online Status: Offline
Posts: 1
Quote Aravind Replybullet Topic: Subreport relative positioning
     Posted: 19 Feb 2013 at 11:46am
We are in the process of process migrating all Actuate reports to Crystal Reports.
We have a one page project status report, wherein there are two sections.

Left hand section has the following static sections
Project Key Information
Traffic Lights
Project Description and Commentary
The left hand section has been developed using one sub-report (one details section)

Right hand section has the following dynamic sections:
Risks and Issues
Tasks
Financials
Each section above has been developed using one sub-report (all in the same details section)

The requirement is not more than 3 risks, 3 issues and 10 tasks should be displayed. Hence, we have given a fixed space for all the right hand sub-reports. However, there is a gap when a particular sub-report is empty.
The question is how do we relatively position the second sub-report (tasks) based on the first sub-report (risks and issues). i.e. if there are no risks and issues, the Tasks section should be moved up, followed by the financials section.

Options tried:
1. We cannot go for separate details section because the left hand section is static and does not align with the right hand section
2. Placing one sub-report below the other overwrites the upper sub-report
3. X axis and width can be based on formula but not Y axis and height.

Any pointers would be greatly appreciated.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Feb 2013 at 10:58am
Put each subreport in its own section, and do the following:
 
1.  Within each subreport, go to the Section Expert and set the Suppress formula (DO NOT check the Suppress checkbox!) for each section that is not already suppressed.  You want it to suppress if some key field that always has data when the subreport has data is null.  The formula will look something like this:
 
IsNull({MyTable.MyKeyField})
 
2.  In the main report, go to the Section Expert and turn on "Suppress Blank Section" for each section that contains a subreport.
 
-Dell
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