Hi,
I like to clarify doubt, As I read few articles here it says filter condition should appear in the show sql to speed up the report.
When using record selection to intergate parameters in the report and that will show in the show SQL where clause. But when the parameter is quered for ALL or a value or multiple values for examples:
In the record selection:
{table.CustName} = {?CustomerName}
//When show SQL is used you can see the sql query for the Parameter
select * from table
where {table.CustName} = 'MyName'
If I use this formula for checking "all"
If {?parameter} = '*' then true
else
{table.CustName} = {?CustomerName}
//In this case the Show sql will be
select * from table
// Here I could use the alternate since this a string parameter and also works for '*'
{table.CustName} like {?CustomerName}
Show Sql would be
select * from table
where {table.CustName} like '*'
What would be the alternate If the parameter is a number (customer Id)
How can I do this to run the report for single id or mutliple id or all id's?
I tried to be as clear as possible with my question. Hope you understand
Any help is appericated
Thanks,
Sameer
I like to clarify doubt, As I read few articles here it says filter condition should appear in the show sql to speed up the report.
When using record selection to intergate parameters in the report and that will show in the show SQL where clause. But when the parameter is quered for ALL or a value or multiple values for examples:
In the record selection:
{table.CustName} = {?CustomerName}
//When show SQL is used you can see the sql query for the Parameter
select * from table
where {table.CustName} = 'MyName'
If I use this formula for checking "all"
If {?parameter} = '*' then true
else
{table.CustName} = {?CustomerName}
//In this case the Show sql will be
select * from table
// Here I could use the alternate since this a string parameter and also works for '*'
{table.CustName} like {?CustomerName}
Show Sql would be
select * from table
where {table.CustName} like '*'
What would be the alternate If the parameter is a number (customer Id)
How can I do this to run the report for single id or mutliple id or all id's?
I tried to be as clear as possible with my question. Hope you understand
Any help is appericated
Thanks,
Sameer