cancel
Showing results for 
Search instead for 
Did you mean: 

Currency fields in Salesforce are not available in Crystal Reports

Former Member
0 Kudos

Hello,

I am running on SAP Crystal Reports 2013 SP5 .

I am using the Salesforce reports as the Stored procedures in SAP Crystal Reports.

I am unable to find Currency fields in Crystal Reports which are in Salesforce while all the rest are available.

Does anybody know about this issue, is there something I can do to fix this?

Please getback,

Accepted Solutions (0)

Answers (1)

Answers (1)

vitaly_izmaylov
Employee
Employee
0 Kudos

Reproduced the problem.

The salesforce.com Currency field used to be a Number type in previous versions of CR. Now it replaced with a String field to display a currency sign.

Because of the data type mismatch the field removed from existing reports refreshed in CR 2013 SP05 Patch1.

Confirmed as another defect to be escalated.

Workaround is to re-add the field back to the report.

Former Member
0 Kudos

Thanks for the response, but I didn't get your workaround,

Where I have to re-add the field? in SF report or in Crystal report?

vitaly_izmaylov
Employee
Employee
0 Kudos

Ok, let me explain. I have a sample report of SFDC Stored Procedure with currency field

created in CR 2008. Here what it looks like:

Similar report created of the same Stored Procedure in CR 2013 will look like:

See the difference between data types?

If in CR 2013 you open the old report created in CR 2008 and do the Set Datasource Location it will prompt to Map the fields because of the data type mismatch. And may remove the currency field (List Price (Number)) from the report if you had Custom format for the field. If it happens then you just need to re-add the field (List Price (String)) back in the place where it was. This is just a temporary workaround solution until Developers will fix it.

Hope it is more clear now.