Hi,

We have a scenario:

In page header, we have a text field PST name which should only appear when country is Canada and PST amount appears in detail section along with other fields.

But for country equal to "USA", PST name and PST amount should not appear on header and detail section of report, but other fields appear

If any body has done this before, please let me know

Hi.
Just R-Click the Text Field -> Select the Properties
You will find few properties besides checkbox like supress ,,,,,,
beside suppress there will be a Formula-box ,if u click that box u will get a new window there u can write all ur Coding, Criteria's and so on... there r two coding Syntax(or techniques) first is crytal syntax ... second is basic syntax. if u select basic syntax u can write any vb-code.
hope u can get it now.
takecare
bye


Mohammed Raza Ullah Khan

Hi,
AS the given way, will n't work because we have to change the page header values depending on the detail section.

If any body knows, let me know

Hello,

As of my knowlegde.

you can use Formula fields (custom) and in that check with If coidition, if the
contry = usa make the column visible false in the detailed section. just use
the property page of that field in the detailed section, and condition for
visibility.

And don the same in the page header, and make only visible true when the condition
is matched.

I used and came across this scanerio in one of my report. and i have done the
same what you had. BUt only thing is I used CR8.5

Hope this helps.

With Regards,
Raghavendra Mudugal