Blank lines required in crystal Report 8.5

Asked By 20 points N/A Posted on -
qa-featured

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.
SHARE
Best Answer by Fahar
Answered By 10 points N/A #91596

Blank lines required in crystal Report 8.5

qa-featured

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 20 points N/A #91597

Blank lines required in crystal Report 8.5

qa-featured

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.

Crystal Reports with VB and SQL
Best Answer
Best Answer
Answered By 10 points N/A #91598

Blank lines required in crystal Report 8.5

qa-featured

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 20 points N/A #91599

Blank lines required in crystal Report 8.5

qa-featured

I'm having difficulty following your instructions. Can you please give me step by step instructions?

An image would also help.

Answered By 10 points N/A #91600

Blank lines required in crystal Report 8.5

qa-featured

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 20 points N/A #91601

Blank lines required in crystal Report 8.5

qa-featured

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 10 points N/A #91602

Blank lines required in crystal Report 8.5

qa-featured

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 20 points N/A #91603

Blank lines required in crystal Report 8.5

qa-featured

Thank you so much for help. My problem is resolved.

Thanks, again.

Login/Register to Answer

Related Questions