[I want a dynamic report: Using the username as parameter to the "Where" condition in the SQL]

Hi, I tried without success. Can you give me a hand, please. Also, I read it a lot and still nothing

I am using jasperserver 4.7.

In IREPOR: I have the following SQl

Select * from users where users=$P{LoggedInUsername}

The class definition of the parameter is: com.jaspersoft.jasperserver.api.metadata.user.domain.Use

without default value and prompt FALSE

In Jasperserver I am only uploading the JXML , I am not doing any control input.

Thanks

 

Daniel

[I want a dynamic report: Using the username as parameter to the "Where" condition in the SQL]

When a username login, the username value is taken as parameter in order to complete the "Where" condition in the SQL. HOw can be done?

[Tutorials]

Thank you, I am checking it

[Tutorials]

Hello, I am looking for tutorials (free) regarding Jasperserver, jasperanalysis and ireports.

If somebody can give me a link in order to start would be great.

 

Thanks

 

Daniel