Sage 100

 View Only
  • 1.  Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 08:53
    Need some help with Crystal Reports. Customer has a fairly large Total section with lots of text on the Sales Order. Everything prints fine but Crystal is leaving a lot of ""Dead"" space on every page. It's allocating the space from the Total section. The form prints a few items on each page and leaves the rest of the page blank except for the last one with the total. I tried moving the Totals to other sections but then it does weird things like printing the Total on every page or not at all. I started from a new Standard form and it does the same. I just need the detail to print on the ""Dead"" space and the Total to print on the last page. TIA


  • 2.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 08:55
    Move everything from the 'page footer' to the 'group footer' and that should allow the pages to print with more data and no wasted space at the bottom of each page


  • 3.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 09:15
    Look for a graphical image that may go off the page to the right. I had that one time where a logo extended off the page to the right and caused some funny stuff. Cooper


  • 4.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 09:48
    @RobertWhite Thank you. I could swear i tried that and got some weird results. Do I need to change anything in the Section, like ""Print at Bottom"" or ""Underlay"" or anything like that? What about the suppress formula's Sage puts in there?


  • 5.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 09:49
    @CooperBlack Thanks. I started with a fresh form so that can't be it


  • 6.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 10:15
    My next step is to look at the Print at Bottom in the section area.


  • 7.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-08-2016 15:07
    If memory serves me, I copy over any Sage suppression logic to the new Group Footer sections and that's it. I believe the appropriate Group Footer already is set to print at bottom.


  • 8.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-09-2016 07:36
    When I have had a potentially large amount of text in the detail section that is not always present, I have had good luck creating a sub-report to display the data, removing all borders and shrinking the subreport as thin as I can make it. It grows when it needs to, and takes up minimal space when it doesn't. Sometimes I put it in its own detail section, if I can.


  • 9.  RE: Need some help with Crystal Reports. Customer has

    Posted 02-09-2016 08:30
    Thank you all. I will try the suggestions you made