Author |
Message |
MFTT
Newbie
Joined: 16 Oct 2013
Online Status: Offline
Posts: 3
|
Topic: Keeping Data On one Output Page 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....
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
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
|
|
IP Logged |
|
MFTT
Newbie
Joined: 16 Oct 2013
Online Status: Offline
Posts: 3
|
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.
Edited by MFTT - 17 Oct 2013 at 9:58am
|
IP Logged |
|
MFTT
Newbie
Joined: 16 Oct 2013
Online Status: Offline
Posts: 3
|
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?
|
IP Logged |
|
hilfy
Admin Group
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
|
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
Edited by hilfy - 18 Oct 2013 at 5:41am
|
|
IP Logged |
|
|