Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

Crystal Report Subreport Sizing

I have a main report with subreports. The subreports are stacked side by side. (see screen shot). I would like to be able to have the borders in each report match up (I.E. the bottom of the report with fewer records is in line with the report with more records). I have indicated with arrows the borders I would like to line up. I have provided a screen shot of my attempt and the results.

Just to recap, I would like to be able to dynamically size the smaller report border to match the larger report border. Or at least set it to a height so they always line up.

Any thoughts? thanks in advance.


example-subreport.png
border-example.png
0
skobyjay81
Asked:
skobyjay81
  • 8
  • 4
1 Solution
 
mlmccCommented:
Where are the subreports?

mlmcc
0
 
skobyjay81Author Commented:
The squares are the subreports in the first screen shot(Each square is the border of each subreport). I have blotted out the report information.
0
 
mlmccCommented:
In the report?
Which section.

The only easy way to do this is to have blank sections above and below the subreport section and draw a box froom the top section around the subreport to the lower section

GH1A    ----------------------
GH1B    |   SUBREPORT    |
GH1C    ----------------------

mlmcc
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
skobyjay81Author Commented:
The subreports are located in the Group Header in the main report.
0
 
skobyjay81Author Commented:
can you provide an example report with how you suggest resolving the issue?
0
 
mlmccCommented:
Check this one

mlmcc
SubReportBoxes.rpt
0
 
skobyjay81Author Commented:
That is close, but doesn't make the subreports grow to be the same size, it has added a border around both of the reports.. I need to have a total of 4 sub reports stacked 2x2. Notice how in the first pick I have 2 reports stacked 2x2 with borders around them. I still need this look but need the reports to line up when stacked 2x2. I have attached the results after applying your suggestion.

One thing to note is that in my example layout image. There are 2 results groups in each of my subreports. thus results in 4 subreports. Report 1 and 2 are the same report but are groups 1 and 2 for the left side and reports 2 and 4 are the same report but are groups 1 and 2 for the right side.
example-layout.png
0
 
skobyjay81Author Commented:
I added the lines between the groups to show you how the reports are lining up now. The divider shows you where group 1 for reports 1 and 2 end and 3 and 4 begin.
0
 
mlmccCommented:
Does this show how?

mlmcc

 SubReportBoxesRev1.rpt
0
 
skobyjay81Author Commented:
I'll have a look.
0
 
skobyjay81Author Commented:
I think this works great. Thank you!
0
 
skobyjay81Author Commented:
Great answer
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now