INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

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!

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

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I've gotten solutions within a day - it saved a lot of time and actually got me one ATTABOY from my boss..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 1 Formulas Forum

Help with a Suppression Formula

Read More Threads Like This One

notoriusbug (TechnicalUser)

1 Aug 12 20:05

I'm using Crystal Reports 2008. I have 4 tables, 3 views - Task, Person, Document, and Multimedia.
The main report is a task report with a select expert for the Person ID I want to run the report on.

I have 2 subreports - Documents linked to the Task, and Multimedia linked to the Task

A multimedia record can be one of three types - a, v, or p (audio, video, or photograph). In the multimedia subreport, I have the records grouped by multimedia date and type, and they are listed in a multicolumn format (2 columns) from left to right. In my group header, I have headers for each of the two columns.

Here's what I can't figure out how to do...if a group has only one record, I want to suppress the headers for the second column (since the only record will be under the first column).

I've tried using a count and a do loop but no success. Any ideas? If I've left out information needed to solve this, let me know and I will post it...thank you

PDF

Madawc (Programmer)

3 Aug 12 5:27

A summary total for a group can be tested for in the group header. Other sorts of total can not. That may be your problem.

The use of Crystal's automated totals is outlined at FAQ767-6524: Basics of totals.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

notoriusbug (TechnicalUser)

3 Aug 12 8:18

Figured out what was wrong - I was doing a count on the wrong item - was counting Multimedia ID instead of my group formula. Works now. Thanks

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!

Back To Forum

Back To Business Objects: Crystal Reports 1 Formulas