on 07-31-2014 3:08 PM
Does any one have any idea while migrating crystal reports from 2008 to 2013 based on BEx 3.5 "Is there any way we can edit the mapping of fields through database change source ,if we have opened the crystal 2008 report in crystal 2013 and have mapped once?"
Hi Vidhi,
Follow the steps
Step 1: Open the Crystal Reports 2008 report to Crystal Reports for Enterprise
Step 2: Change the connection to the new BICS Connection
Step 3: Map the fields to the new meta-data from Source tables to Target tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Thanx for replying. We have a different scenario here-
We have crystal 2008 which we are migrating to crystal 2013 [Note: these are based on BW 3.5].The Steps we are folllowing here:-
Step1: Opening the Crystal2008 Report in Crystal 2013.
Step2: Changing the datasource to new BEX query pointing to the same BWT environment.
Step3: Mapping all the fields to the new data field from Source tables to Target tables.
Step4: Refreshing the Crystal 2008 & Crystal 2013 Report using same parameter inputs.
Now the problem we are facing here is --
1) Output of both reports are different,which is the main issue for all the reports.Only the layout is similar in both.Data is found to be more in 2013.[which should not as we using same BW database]
2) For some reports 2013 throws some datatype errors for date field or string which is not same in crystal 2008.
3)The query generated in both 2008 & 2013 are differnt.In 2013 it automatically gives crossjoins with some other table.Below is the query from both:-
2008
SELECT * FROM [ZDFILLRT/ZSD_Q_UNADJ_ADJ_FILL_RATE] SAP VARIABLES [ZSOLDTOS] INCLUDING "0001006112", [ZDATEFRO] INCLUDING "01/2013", [ZDATETO] INCLUDING "12/2013"
2011
SELECT {[Measures].[ZDFILLRT_DED_QTY], [Measures].[ZDFILLRT_NUMB_DAYS], [Measures].[ZDFILLRT_INIT_DLV_QTY], NON EMPTY CROSSJOIN([0SOLD_TO | ZREPGRP].MEMBERS, CROSSJOIN([ZSO_DATE].[LEVEL01].MEMBERS, CROSSJOIN([0PO_NUMBER].[LEVEL01].MEMBERS, CROSSJOIN([0DOC_NUMBER].[LEVEL01].MEMBERS, CROSSJOIN([0S_ORD_ITEM].[LEVEL01].MEMBERS, CROSSJOIN([0MATERIAL].[LEVEL01].MEMBERS, )))) DIMENSION PROPERTIES [0MATERIAL].[50MATERIAL], [0SOLD_TO | ZREPGRP].[50SOLD_TO] ON ROWS FROM [ZDFILLRT/ZSD_Q_UNADJ_ADJ_FILL_RATE] SAP VARIABLES [ZSOLDTOS] INCLUDING "0001006112", [ZDATEFRO] INCLUDING "01/2013", [ZDATETO] INCLUDING "12/2013" |
Would appreciate ,if you can help on this.
Regards.
Vidhi
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.