Controlling Integer/user params

salvador_sibaja

Hello,

I have a LiveReport with an user input param. I want to control that if this param is empty report returns all the registers and if the param is fullfit returns only the rows that have this user.

For string attributes I use this SQL:

d.Text = %1 or ''=%1

When I have Integer or User(is an integer too with the ID of the user) params I don't know how control it.

Database is SQL Server.

Regards

Greg_Griffiths

If you have the LiveReports Ext module, you can use Template SQL to achieve this.