Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subreports to fill in blank columns Post Reply Post New Topic
Author Message
Latte
Newbie
Newbie


Joined: 24 Aug 2010
Online Status: Offline
Posts: 9
Quote Latte Replybullet Topic: Subreports to fill in blank columns
    Posted: 24 Aug 2010 at 6:48pm

Hello, I am fairly new to crystal reporting and have a question in relation to subreports.

The main report I have is for a purchase order form and I have created a subreport and inserted it in the details (below the details from the main report) with the aim of filling out the blanks lines in the column.
 
This is so that the columns, which is in a tabular form, will anchor to the bottom of the page even if there is one row with detail in it. The total amounts row should be at the bottom.
 
In the subreport I have a few sections of details to fill in the blanks and it seems to only show a blank line for one row so it is not anchoring down to the bottom as i had hope to achieve.
 
I hope I've made sense! Any help would be greatly appreciated, thanks!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Aug 2010 at 12:31pm
There is a better way to do this:  Put your totals in the page footer.
 
Will you be printing one po at a time or more than one?  Will all of your po's be a single page or could they be multiple pages?
 
With the answers to thos questions, I can tell you how to selectively suppress the footer so that it only appears on the page where you need it.
 
-Dell
IP IP Logged
Latte
Newbie
Newbie


Joined: 24 Aug 2010
Online Status: Offline
Posts: 9
Quote Latte Replybullet Posted: 25 Aug 2010 at 7:10pm
Thank you so much for your response/help!
 
The initial reason for adding a subreport in the details section was that I had a report footer that i need to have at the end of the page, regardless of the number of pages.
 
The PO's would mostly be single page but they will need to cater for multiple pages too as there could be various lines of orders/details.
 
I have since put the amounts total in the page footer and i also have a second page footer to include the need for other hard coded information.
 
This second page footer section also only needs to be on the last page (if there is more than 1 page to the PO).
 
This answers your question I hope? I am trying to put in some formulas to try to suppress the footer but am getting stuck.
 
Thank you heaps!
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Aug 2010 at 3:36am
If you're only going to do one PO at a time, you can put something like this in the suppression formula for a page footer that you only want to have displayed on the last page:
 
Not OnLastRecord
 
If you will need to be able to run multiple PO's in the same report and you want the section to only appear on the last page for each PO, you'll put something this in the suppression formula (assuming that you're grouping on a field called "PO_Number"):
 
Not OnLastRecord and {table.PO_Number} = next({table.PO_Number})
 
-Dell
IP IP Logged
Latte
Newbie
Newbie


Joined: 24 Aug 2010
Online Status: Offline
Posts: 9
Quote Latte Replybullet Posted: 26 Aug 2010 at 8:40pm
Thank you so very much! I put that in the Suppression formula for both page footers and it works! :)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.