I have used the search and couldn’t get answers. I have 5 prompts in the conditions for my report.
Division Equal to prompt (‘Enter Division’)
Deptid Equal to prompt (‘Enter Dept Id’)
Account Equal to prompt (‘Enter Account’)
Fiscal Year Equal to prompt (‘Enter Fiscal Year’)
Accounting Period Equal to prompt (‘Enter Accounting Period’)
My requirement is the users might give a combination of values lets say
Division - 110
Dept - 220
Account - 330
Fiscal Year - 2006
Accounting Period - 10
or they want all the data without any restrictions. I tried using % sign and it gives an error. ‘No Data to fetch’. I have confirmed in SQl that there is data to fetch.