Blank lines required in crystal Report 8.5

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.

• Status: Open
• Question Views: 3602
• Answer Count: 8
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: Business Management

Best Answer by Fahar

Go To 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.

About Fahar

Questions
1

Answers
25

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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.

About Arslan

Questions
1

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

Best Answer

Best Answer

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.

About Fahar

Questions
1

Answers
25

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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.

About Arslan

Questions
1

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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.

About Fahar

Questions
1

Answers
25

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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?

About Arslan

Questions
1

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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.

About Fahar

Questions
1

Answers
25

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management

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.

About Arslan

Questions
1

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/12/2011
• Question Category: Business Management