Print Page | Close Window

Subreports to fill in blank columns

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=10949
Printed Date: 19 Apr 2025 at 1:00pm


Topic: Subreports to fill in blank columns
Posted By: Latte
Subject: Subreports to fill in blank columns
Date 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!


Replies:
Posted By: hilfy
Date 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


-------------
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: Latte
Date 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!
 

Posted By: hilfy
Date 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


-------------
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: Latte
Date 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! :)


Print Page | Close Window