Add ExternalId to serviceCheckout report

[acastilla]

Hi all,

We have our FSM integrated with C4C and the C4C Id for the ServiceCall is being stored in field externalId.

As per business requirement we need to include this C4C Id into our serviceCheckout report. We have tried to add the field by modifying the report with Jaspersoft but the field is not available.

Does any of you have any idea on how we can achieve this? In FSM's query api we are able to select the field and also to show it on the screen configuration, but Jaspersoft seems not to recognize it.

Thanks a lot for you help. BR,

Alfredo

[VishnAndr]

Hi Alfredo,

It's definitely possible. And here is what needs to happen:

1. In Main Report (report.jrxml) you need to open "DataSet and Query editor dialog"

2. There in the table at the bottom you need to add a new field with field name serviceCall.externalId with class type java.lang.String and close the dialog with Ok button.

3. The field will appear in Fields in Outline in Main Report.

4. Then you will be able to use it as any other field as $F{serviceCall.externalId}