Asked By
Arslan
20 points
N/A
Posted on - 07/12/2011
I am a software developer and engineer. My client wants me to generate a report based on the design of his hard-copy letter pad.Â
In the letter pad design, there are 14 rows available that are used to show the sold and purchased item’s details. Below these lines is an area that shows the various totals – discount, tax, grand total, etc.Â
Â
The totals must be printed in the pre-defined area. So, if a sale consists of 2 line items, 14 blank lines must be inserted before the totals are printed. On the other hand, if the sale contains 6 line items, 10 blank lines must be inserted before the totals.
Â
So, my question is : how do I tell Crystal Reports to leave those blank lines?
Â
Kindly help me with the solution.
Answered By
Fahar
10 points
N/A
#91596
Blank lines required in crystal Report 8.5
This problem can be solved quite easily. Please post an image of the letter pad so that I can understand the problem in detail. Also let me know what software you are using for report generation and development.
Answered By
Arslan
20 points
N/A
#91597
Blank lines required in crystal Report 8.5
Here you are. Note, that the company letter head has been blanked out for security reasons. I am using Crystal Reports 8.5 with VB and SQL for report generation and development.
Answered By
Fahar
10 points
N/A
#91598
Blank lines required in crystal Report 8.5
Your problem occurs when your line items are less than the number of lines printed on the letter pad. The totals must be in the specified area at the end of the page. All you have to do is:
In the details area of the report, add 13 headers area (one less than the number of lines); in each group’s property, set the formula field as
Suppress if record number > 2. This formula will be in the 2nd line and the first group header you have entered and so on. Apply this setting to all group headers.
To make sure that it works, print the report using from 1 to 14 details entries; the totals should always appear in the right location.
Answered By
Arslan
20 points
N/A
#91599
Blank lines required in crystal Report 8.5
I'm having difficulty following your instructions. Can you please give me step by step instructions?
An image would also help.
Answered By
Fahar
10 points
N/A
#91600
Blank lines required in crystal Report 8.5
Here's an image of the report design view. Perform all the tasks I have described in the last comment. You must Generate group headers on the basis of Sales/Purchase voucher no.
Answered By
Arslan
20 points
N/A
#91601
Blank lines required in crystal Report 8.5
Thank you so much. My problem seems to be resolving. I have added all the groups and set the formulas too.
But there is one pending issue: The report fields are not on the exact lines and exact places.
Can you help?
Answered By
Fahar
10 points
N/A
#91602
Blank lines required in crystal Report 8.5
Make sure that the line height of the details area and the added group headers is identical to the height of those in the letter pad.
You may need to modify these: use a trial-and-error method to fine tune your settings to match the letter pad exactly.
Answered By
Arslan
20 points
N/A
#91603
Blank lines required in crystal Report 8.5
Thank you so much for help. My problem is resolved.
Thanks, again.
