I am looking to consolidate data from SAP B1 Systems(Multiple) and SAP R/3.
I checked with the Crystal Reports 2008 free trial version and found that crystal reports have the facility to connect with many kinds of systems used as datasources.
So my query would be what would be the most suitable Connection type for connecting Crystal Reports with SAP B1? and can we further combine data from two sources ?
To combine multiple datasources you can buils a SQL database for creating merged views then link Crystal to that, or usr Crystal Reports Server which is a good tool
I have one server on of B1 8.8 which has inbuilt crystal..but another B1 which is not 8.8 .
1.I wish to consolidate data from these two servers..what should be my starategy??
2.You mention about SQL database ,but why should I unnecessarily setup another instance of SQL for consolidation..??Can't I consolidate it at Crystal Reports Layer?
3.If I have license of BOBJ ,how the inbuilt Crystal Server would differ from BOBJ package of Crystal Reports Server 2008?Will there be separate instances??Also considering my R/3 will also connect with Crystal Server...what should be my startegy..?I am pretty much confused..
If you already have Crystal Reports Server then you can create a connection to each of your B1 databases and create a Business view that combines the data you want to report on.
That would be the best strategy.
For our customers who don't have CR Server, we build a data warehouse that exreacts the data from the different databases and write reports from the data warehouse.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.