ASAP----How to bold first 10 rows of report only

[MrHelpMe]

I need a formula or way of bolding the first 10 rows of data in my report while the remaining records/rows remain unaffected. Is there any way of doing this? I couldn't find what i was looking for in the crystal online support
web site. I'm pretty sure I have to use a conditional formula, but I do not know how to structure the formula. Any help will be apprectiated.

 

[kenhamady]

What version of CR?
Are the rows records or groups? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[MrHelpMe]

Hi Ken,

I am using crystal reports Professional version 6, 32 bit version. I have grouped the report by dealer code and then all other fields are moved upto the group level. Therefore the report looks as follows, however there are more rows,

DEALER Daily Net MTD MTD
Sales Buys Sales
9832 Berkshire Investments 10,000 10,000 10,000

 

[kenhamady]

You can't conditionally bold until V8.

The Workaround would be to create two identical sections (split the section into A and B) and make one bold and the other not.

Then suppress each section with an opposite conditon.

Groupnumber <= 10

or

Groupnumber > 10 Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Dond12]

Here's a variation which uses a running counter variable and two detail sections. It works perfectly:

First, create a formula called @kounter as follows:

whileprintingrecords ;
shared numberVar kounter := kounter + 1 ;

Next, create a formula called @reset as follows:

whileprintingrecords ;
shared numberVar kounter := 0 ;

Now, create your group header and put the @reset variable in it.
Suppress @reset so that it won't show.

Now, create two detail sections, A and B.

Put preciselyt same fields in each detail section, including the formula @kounter.
Suppress @kounter in both details sections.

In section A, make the fields BOLD.

Finally, format section A to suppress when this condition is true:

@kounter > 6

and format section B to suppress when this condition is true:

@kounter <= 6

When you run the report, the first 6 items will be bold because they will be the items in details section A; the rest of the items will not be bold, because they will be the items in details section B.