Setting Fixed Height For All section
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=19156
Printed Date: 03 May 2024 at 4:13pm
Topic: Setting Fixed Height For All section
Posted By: VaniShree
Subject: Setting Fixed Height For All section
Date Posted: 20 Feb 2013 at 6:48pm
|
Hello All, i have a Cheque Printing report where i have to set the fixed height for detail and header section in order to fit the Pre-Printed Stationary.. i have tried (RecordNumber mod 10) = 0 , but its not working What i need is if my records have more than 10 lines from 11 line it should print in next page and if my records is <10 then it should add blank line in the respective section .. is there any way i can do this .kindly help ------------- Vanishree |
Replies:
Posted By: hilfy
Date Posted: 21 Feb 2013 at 5:36am
|
I assume that your details are about items that are on the cheque, correct? Does the program print a cheque for a single payee, or can it print multiple checks for multiple payees? What is your report grouped on? I have a couple of possible solutions, but which one will work is based on the answer to these questions. -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: VaniShree
Date Posted: 21 Feb 2013 at 8:20pm
|
Hello Dell, Thanks for your reply . As u assumed it is correct that the item on the details section is about the item on cheque only and grouped by transaction no which is internally generated for each cheque no and my program print multiple checks for multiple payees. For Eg:-User may select and print from transaction 1-10 at the same time . Regards Vanishree ------------- Vanishree |
Posted By: hilfy
Date Posted: 22 Feb 2013 at 3:59am
|
Try this: 1. Create a Formula that will count the number of details in a transaction. It will look something like this (I'll call this {@Detail Count}): Count({Details.KeyField}, {Transaction.Transaction_ID}) 2. Create a Running Total that will count the number of detail records as they're processing (I'll call this {#Detail Running}): Field to Summarize: {Details.KeyField} Summary: Count Evaluate: Every record Reset: On change of group - transaction ID group. Steps 3 - 5 take place in the Section Expert: 3. Add 9 details sections after the section where the detail data is located. 4. For each of the added details, set the suppression formula. DO NOT check the Suppress checkbox! The formulas will look something like this: Detailsb: ({@Detail Count} >= 2 and {@Detail Count} < 12) or ({@Detail Count} >= 12 and {@Detail Count} < 22) or ({@Detail Count} >= 22 and {@Detail Count} < 32) or...Up to the max number of detail records. Detailsc: ({@Detail Count} >= 3 and {@Detail Count} < 13) or ({@Detail Count} >= 13 and {@Detail Count} < 23) or ({@Detail Count} >= 23 and {@Detail Count} < 33) or...Up to the max number of detail records. 5. Set the "New Page After" formula for the Detailsa section to something like this: {#Detail Running} mod 10 = 0 and {@Detail Count} > 10 If you want the cheque to print on the first page, regardless of how many pages there are, do the following: 1. Move the cheque info from the Transaction group footer section (where I assume it's currently located) to a page footer section and make the transaction group footer section very small so that it doesn't affect your page size when it's processed. DO NOT suppress it because we need it! 2. In the Section Expert, turn on "Reset Page Number After" for the Transaction group footer section. This will reset the internal page numbering to 1 for the start of each group. 3. For the page footer section that contains the cheque info, set the suppression formula to: PageNumber > 1 -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: VaniShree
Date Posted: 25 Feb 2013 at 7:27pm
|
Hello Dell, I have tried what u have mentioned .. but it only print the last record of my selected range For Eg: if i select From Ch1 to Ch3 it print ch3 last record  ------------- Vanishree |
Posted By: hilfy
Date Posted: 26 Feb 2013 at 3:29am
|
Do you have a suppress formula on the details section that contains your data? There shouldn't be a formula there. Instead, you need to just have the selective suppress formulas on the blank detail sections that will print only if needed. -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: VaniShree
Date Posted: 27 Feb 2013 at 8:19pm
|
No i don't have any suppress formula in my details section . now am getting the details but my ultimate purpose is not solved.. blank section adding if my records are less than 10 -Vani ------------- Vanishree |
Posted By: hilfy
Date Posted: 28 Feb 2013 at 6:44am
|
If I were to PM my email address to you, could you send me a copy of the report with data in it (turn on Save Data with Report)? I suspect there's just a little something that needs to be tweaked. -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: VaniShree
Date Posted: 28 Feb 2013 at 5:53pm
|
Sure will do that and thank u so much.
------------- Vanishree |