Hope somebody can help.

 

I have 2 groups:

 

Group1 - Customer

Group2 - invoice number

 

both groups have a Summarized total quantity field

(group1 total = total units purchased in September)

(group2 total = total units purchased on a single invoice)

 

 

I have supressed group2 using this formula:

 

IF Sum ({TABLE1.QUANTITY}, {TABLE.INVNUM})<4 THEN TRUE

 

which will then only shows invoices with a total of more than 4 units.

 

 

What I want to do, is highlight the group1,  based on whether group2 has any data.

 

 

for example: (my report currently looks like this)

 

 

As you can see, CUSTOMER C has purchased 9 units this month, but has not had more than 4 on a single invoice.

 

I want to highlight this (and all other customers who fall into this criteria) in red.

 

so it will look like this:

 

 

 

Any Ideas?

 

Ive tried adding this into the section expert(colour) for group 1:

 

IF Sum ({TABLE1.QUANTITY}, {TABLE1.INVNUM}) THEN crred

 

 

but it does not work :(

 

 

Thanks in Advance :)

 

 

ok, back my very first thought....

make a subreport that will set a shared variable with a flag or a count of orders that have the minumum value.  place the subreport before the group header (i would make another g1 section(for example) and move on top of existing group header (g1 in this case)).  make the subreport 'invisible' (this can be tricky so more later), then you can change the color of the font in the group header (since you know that there won't be any details displayed.

 

This is not optimal as all of your data is going to be read 2 times, with many many hits to the database.  If there aren' t many rows in the report, it probably won't be noticed, but that is the caveat.

 

How to hide a subreport and still get it to run?  Suppress all the output on the subreport(after all we are after the shared variables value), then in the section, go to section expert and select 'suppress blank section'

 

HTH

 

ps my favorite solution is to create a stored procedure, then if you wanted you could include a flag in the records that would tell you whether the group had any entries that met your requirements...this reduces your hits to the database to just 1, gets rid of the need of the shared variable and the subreport...but not everyone is able to implement this style of solution.

 

Dont know how it worked, but it did...

 

I created a formula called

@linecheck

IF {TABLE1.QTY}>=4 THEN 1 ELSE 0

 

Then summarized this formula by CUSTOMER group.

 

in section expert(colour) I put:

 

IF Sum ({@LineCheck}, {TRNSTK.CUSTOMER})=0 THEN crred ELSE crsilver

And it worked..... :\ dont know how, but it did.

 

Since it would be a shared variable, you will need to reset it (probably before you call the subreport or in the header of the subreport)  Then it would probably be incremented in the detail section of the report (depends on the report layout/values in the data)

 

I respond just for future reference, since you found another way that appears to work (taking DBlank's comments into account).