I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -
As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter.
The reason you get the empty results if you have selected any salesperson is that there was no record matching for that date and salesperson. However, if you want the report to show the results regardless of SalesPerson being seletced or not
you should add a second line on the filter and use OR operator as you can see in my screenshot.
This way if you leave the parameter empty you still get the results.
You can check allow null flag for SalesPersonID parameter on build schema and in second line on Filter tab simply use condition IsNull instead of Equal
When I do that, it clears ALL data from the aging report
This is regardless of which salesmen is entered into the filter, and regardless of if there even is that filter active. The problem is resolved by removing that filter. Is there any additional setup I need to do this?
The reason you get the empty results if you have selected any salesperson is that there was no record matching for that date and salesperson. However, if you want the report to show the results regardless of SalesPerson being seletced or not
you should add a second line on the filter and use OR operator as you can see in my screenshot.
This way if you leave the parameter empty you still get the results.
You can check allow null flag for SalesPersonID parameter on build schema and in second line on Filter tab simply use condition IsNull instead of Equal
@hkabiri Hi Sam, when I try to add that second line, the @SalesPersonID auto-populates to ‘DELETED’. Also, there are invoices that match the date and salesperson criteria. Are there maybe additional tables I need to setup?
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.