report by multiple parameter with OR rela
1 post • Page 1 of 1
report by multiple parameter with OR rela
I am trying to create a report with three parameters (date, license number and application number). I want report by License Number or Application number in the date that I put in. I trying following in Record Selection:
1.
{Command.LICENSE_NO} = {?License Number} or
{Command.LICENSE_ID} = {?Application Number}
2.
if isnull({?License Number}) = false then
{Command.LICENSE_NO} = {?License Number};
if isnull({?Application Number})=false then
{Command.LICENSE_ID}={?Application Number};
** license_id is the application number(number). license number(string)
but both of them do not work. somehow I can not leave Application number empty.
Please Help!!!
1.
{Command.LICENSE_NO} = {?License Number} or
{Command.LICENSE_ID} = {?Application Number}
2.
if isnull({?License Number}) = false then
{Command.LICENSE_NO} = {?License Number};
if isnull({?Application Number})=false then
{Command.LICENSE_ID}={?Application Number};
** license_id is the application number(number). license number(string)
but both of them do not work. somehow I can not leave Application number empty.
Please Help!!!
- heliang(Legacy Member)
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest