HI,
You can create OLAP in Crystal report but once you deploy it to WEB, users cannot drill down. Might as well use Crystal Analysis.
If you still want to use Crystal Report for OLAP, let me know and i will tell you how to do it.
HI,
Null value is being ignored and you need to convert that field value with a blank before you make a join, if not, since you only have 3 columns to deal with, you can use this code (below)
SELECT MAST.*
FROM QueryTrx..SO_90_UDF_Sales_Order MAST, QueryMaster..SO_90_UDF_Sales_Order TRANS...
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.