grouping question and switching header image

[santosh1]

Currently in my report, company is shown by it's keyvalue (0 and 1 where 0 is Company A, 1 is Company B).
I would like to do grouping and display it as Company A and Company B rather than grouping it as 0 and 1.
Secondly, based on company type (Company A, Company B), I would like to change the logo image in header
section. How can I do this? Thanks.

 

[Turkbear]

Hi,
Create a formula to 'decode' the actual value of the field:
( assumes no NULL keyfields)

@cmpyname
if {keyfield} = 0 then 'Company A' else
'Company B'

Use this formula for your Group, instead of {keyfield]...

As to the Graphic, place both in the header and supress one or the other based on the value of {keyfield}

hth,

 

[santosh1]

I placed both the images on the header. How can I suppress the image on the formula editor now? Can you give me an example? Thanks.

 

[vidru]

Right click the image for Company A, click on Format Graphic, and enter a suppression formula:
{table.GroupID} = 1

... and do the same for the Company B image:
{table.GroupID} = 0

-dave

 

[synapsevampire]

Right click the header and select insert section below.

Place one graphic in header A, and one in Header B.

Right click each header and select format section->X 2 next to format section and use th formulas described by dave.

-k