Devin.McQuaid
New member
- Local time
- Yesterday, 18:38
- Joined
- Feb 5, 2013
- Messages
- 1
I am using crystal reports 2008 to access both an SQLServer and MSaccess database. The MSAccess is a mobile version of SQLServer database. In my report I have a conditional suppress of a text field that works fine when running against the SQLServer but gives me "Invalid argument provided" when I run it against MS access. the formula is pretty simple:
{FREQ.Type} = 'H' or {FREQ.Type} = 'R'
I am at a loss as to why this doesn't work. I have tried numerous iterations, adding parentheses, putting it in an if statement etc. but I can't make Access happy.
Any help is greatly appreciated.
{FREQ.Type} = 'H' or {FREQ.Type} = 'R'
I am at a loss as to why this doesn't work. I have tried numerous iterations, adding parentheses, putting it in an if statement etc. but I can't make Access happy.
Any help is greatly appreciated.