I am receiving a Report Execution Error when adding a filter with comparison operator "Does Not Begin With". In this case I used ItemCode does not begin with G, however, I have tried on different expressions and have issues each time. I am not very familiar with how SQL works, but the statement seems to be looking for the entire value to not be like G? Below is the SQL Debugger results.
What I'd like to know is:
1. Are there limitations to which expressions the Does Not Begin With operator can be used with?
2. Is there a workaround to filtering out results that begin with a specified character? (before generating the report)
3. Is there documentation that details any limitations that comparison operators have in filtering/parameters?
I am having the same issue. Did you ever find out a resolution?
Hi - Check out this link.
Thank you Doug. I had two tables with graphical join and when I removed one table, it worked. I found a workaround to get the data from the other table in the report.
Hi Doug: I'm don't see a solution in this link. Am I missing something.
Well there is actually no solution.
Because of the Providex back end you can't use "Does Not Begin With"
You will have to try another way to get what you want.
What are you wanting to do?
I want to exclude all item codes that start with "M" or in other words include all item codes that do not start with "M".
The "Does Not Begin With" would be perfect for this.
Do the "M" items have a unique Product Line?
Unfortunately not. I am thinking that I may have to remove once the data is in excel, maybe via formulas. Thoughts or any other ideas?
Thanks for your help
Are you using a Pivot Table in Excel that uses the Raw Data?