Keeping Data On one Output Page
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20129
Printed Date: 03 May 2024 at 6:43am
Topic: Keeping Data On one Output Page
Posted By: MFTT
Subject: Keeping Data On one Output Page
Date Posted: 17 Oct 2013 at 7:43am
Having a frustrating issues with report output.
Database has one table that holds "additional" addresses.
Owner
Emergency Contact
Local Contact
Property Owner
I want to print all four addresses on one report. However, when I run the print job, each address generates its own page, so a one page report for an account comes out four pages with each page having one of the addresses on it.
I've stripped *everything* off for a test report so it's only these four sections of information. For some reason, since it's pulling from one table, each address forces a new page.
I've gone through the Section Expert and removed all New Page check marks other than from the default ones in Report Header and Footer. All Sections have the Keep Together box checked.
I'm at a loss here....
|
Replies:
Posted By: hilfy
Date Posted: 17 Oct 2013 at 9:30am
Try this:
Uncheck "Keep Together" on the section AND on the groups. (I assume you're grouping on the address type...)
Also, make sure that all of your sections are only as tall as the fields that are in them - don't leave extra blank space. If you've made some fields "taller" to fit what might be multiple lines of data, make them one line tall and turn on "Can Grow" which will automatically make the field and its section grow taller as needed. If you need to put a field below the Can Grow field, put it in a new section below the Can Grow field.
Which version of Crystal are you using?
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: MFTT
Date Posted: 17 Oct 2013 at 9:56am
Using CR 9.
Unchecked "Keep Together" in Section and Groups.
Checked "Can Grow" in all fields.
(Should I uncheck "Keep Together" in all the fields?)
End result is similar, other than Page 2 and Page 3 are combined on one page now. But in each section, only one address is printed.
Structure is:
Report Header
Page Header
Group Header
Details
Group Footer
Report Footer
Page Footer
The client wanted the four addresses in a grid, so I put them all in one Group.
While testing, I made a new group for each address, but that gave even stranger results and I didn't pursue cleaning that one up as it seemed further from desired output.
|
Posted By: MFTT
Date Posted: 17 Oct 2013 at 11:50am
I've moved to using a Subreport, which does display all the data.
However, now it's printing four copies of each account.
Suggestions?
|
Posted By: hilfy
Date Posted: 18 Oct 2013 at 5:41am
If you save the report (.rpt file) with data, I'll PM you my email address so that you can zip it up and send it to me. I'll take a look at it and see what I can come up with. If you'll also have a copy of the report as it was before you added the subreport, I'll take a look at that too and see whether it's possible to get it to work that way.
What version of Crystal are you using?
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|