Hi Dave,
Thank you for your reponse. I researched using case statements with Oracle SQL and found that case statements are not supported. The closest I could come would be the "decode" function and, in this case, it would be a very gnarly decode statement indeed. I expect I will end up using...
Hello,
I created a Crystal 9 report with multiple command objects going against an Oracle 8.1.7 DB. The tables and columns are the same in each of the command objects, the difference is the date selection criteria for the 3 buckets I need, Prior YTD, Prior Year, and Current YTD. The data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.