Mapping fields in crystal 2013 while changing datasource.

[Former Member]

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?"

[Former Member]

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.

[Former Member]

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

[Former Member]

Vidhi, I know its been a while that you posted this thread, but did you find any solution for this issue? I am facing exactly the same issue with MDX Driver. Any suggestions?

Thanks!