Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello All Is there any way I can

Status
Not open for further replies.

CMR

Programmer
Apr 30, 2002
76
AU
Hello All

Is there any way I can divide a Crystal report vertically as well as horizontally? I Have a bunch of values which must be listed down the left of the page and various other bits of informtaion which must appear to the right (totals, etc).

The values are set up in the report to be listed in the "details" section (there can be any number). The totals etc must appear to the right of the values and there is a fixed number of fields which must appear:

Details list (any no.) Totals etc. (fixed no.)
---------------------- ---------------------------
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX
XXXXXXX XXXXXXXXXX
XXXXXXX XXXXXXXXXX


The fields on the right should always appear in the same position on the page, whereas the fields on the left would behave as any other list (i.e. run onto the next page etc.)
I cant use a subreport for the right hand fields as this will expand the section it's in and push any other sections downwards - meaning the two lists wouldn't be horizontally level.

Any ideas?

Thanks in advance

CMR
 
You may be able to accomplish this by using a sub-report and then use the "underlay following section" in the section formatting.
if you have groupings you can "insert a section below" your last grouping. Insert your sub in the new section. Then format then new group section to Underlay Following..

Without underlay
Code:
Group 1a  Group Name          
Group 1b                       Subreport Info
                               Subreport Info
                               Subreport Info
                               
          Details
          Details
          Details
          Details

With underlay
Code:
Group 1a  Group Name
Group 1b  Details              Subrepot Info 
          Details              Subrepot Info  
          Details              Subrepot Info  
          Details              
          Details



Mike
If you're not part of the solution, you're part of the precipitate.
 
Thanks for your help old bean

I figured out a way of doing it using sub-reports but it isn't quite what you suggested.

I used a subreport for the list and just had the totals as part of the main report (obvious, really...). Both subreport and totals were placed in the header of the report so the totals remain in a fixed position and the details in the subreport can run on and on (to n number of pages):

Details list (any no.) Totals etc. (fixed no.)
---------------------- ---------------------------
Subreport: main report:
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX XXXXXX
XXXXXXX XXXXXXXXXX
XXXXXXX XXXXXXXXXX
XXXXXXX XXXXXXXXXX

Anyway, thanks very much for taking the time to help. I appreciate it.

CMR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top