×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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.

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

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.

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

(OP)
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

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

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.

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

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.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close