Hi,
I have written a IAL and quick information source has been created using IAL. Data from IAL looks like below .
Above 5 fields are parameters of the report and as you can see in above screen shot SITE, BUYER_CODE and PROJECT_ID can be null.
If user only enters COMPANY and TEMPLATE_ID as parameters (leaving site, buyer_code and project_id blank), I want to query records WHERE company = ‘XX’ and template_id = ‘YY’. But if user enters value for other 3, then that parameter should also be included in the WHERE clause (e.g if value for site is entered, query records WHERE company = ‘XX’ and template_id = ‘YY’ AND site = ‘ZZ’).
How can this be done? Currently if I enter company and template_id only as parameters, it is not returning any data to the report.
Help is much appreciated.