Display detail band based on condition

[swathi13]

HI,

 

I want display data (detail) band based on condition:

suppose:

if user is registerd-client(he has right to view the data)

in this case i want to display data(Actual Result from resultset)

if user is non-registered  client(he dont have rights to view data)

in this case i want to display satic message(client doesn't have rights to view data) with column - headers?

 

plese help me, how can i achieve this?

Thanks in advance.

[Portlight]

The best solution for this will be to set a style, then apply that style to the output.

 

[swathi13]

Could you please give me a sample example?

[Thomas Zimmer]

You could use a data filter. But even better would be to design your query with the username, so that only data is queried (and transported over network) which is relevant for the report.

To display the message, use the "no data" band, and select the right setting in the document properties ("When no data" = No data band").

Unfortunately you will have (re-)design the whole layout, there is no possibility to use the headers or footer or other bands with the no data band.

Cheers, Thomas.

http://www.ThomasZimmer.net

[Thomas Zimmer]

How should that be resolved with a style??