Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with a Suppression Formula

Status
Not open for further replies.

notoriusbug

Technical User
May 10, 2010
5
CA
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
 
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.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top