Another Hierarchial Grouping Question

[checkai]

Here's my report groups.

BU
Team
Partner
ClientID/parentClientID


once to the client level, the child's are indented. Is there a simple way to simply Italicize the rows that are childs?

Thanks,

DLC

 

[synapsevampire]

Right click the ClientID group field and select the italic button?

Or fonts can be programmtically changed using a Style Formula, right click the field and select Font->X 2 next to Style and place something like:

if {Bob.Customer ID} <> 1 then
crItalic

-k

 

[checkai]

That would italicize all clients that were childs. The report can actually have children on it without the parent. I only want those that have the parent child relationship on the report.

dlc

 

[synapsevampire]

A child doesn't exist without a parent unless it's an orphaned row, which I doubt is what you really mean.

You might consider posting example data and expected output.

-k

 

[checkai]

i figured out a way to do this...here's what i did...this italicizes all records under the parent client...they all show on the same drill down level...

if Previous ({Star_SPWipAging.clientID}) = {Star_SPWipAging.parentclientid} or
(Previous ({Star_SPWipAging.parentclientid}) = {Star_SPWipAging.parentclientid} and
{Star_SPWipAging.parentclientid} <> 0)then
crBoldItalic
else
crBold