condition based data ristriction

[anuradhaa]

Hi,

I have two tables as

sales and agents

In sales and agents has common field agent id

in agents table i have a column called country.

I need to display data in my reports based on country='USA'

Can i do it in front end ( I know we can use set analysis, but then i have to do that in each and every report)

[sunny_talwar]

I am glad we were able to help and you got what you were looking for.