Error in Header field due to JSON input

1 Answer 11 Views
DataSource JSON Rendering Report Designer (standalone)
Carlos
Top achievements
Rank 1
Iron
Iron
Iron
Carlos asked on 01 May 2025, 05:43 PM

I'm using    JsonConvert.SerializeObject(ds)  to convert to JSON string     dataset composed of three tables   the resulting JSONcomes back with something the result shown below.  These fields are part of header section in the report and they are giving me errors.  Someone suggested to remove the square brackets in order to make it work and it did the trick.  Is there a way I can access these fields in the header section without making changes to the resulting JSON?  

1 Answer, 1 is accepted

Sort by
0
Petar
Telerik team
answered on 05 May 2025, 01:05 PM

Hello Carlos,

Thank you for providing the screenshots of the observed behavior.

If I understand correctly, the JSON in question is used as a data source for the report item. Is that correct?

If that is the case, you can access the data from the Patient property in the report header by using a data item like a list. A list is essentially a container that can include other items, such as text boxes, and has its own data source. There, you could bind (through the Bindings property) the DataSource property to the = Fields.Patient expression, as follows:

For your convenience, I am attaching the sample project using the above approach. Please feel free to take a look at it and let me know if it works for you.

Looking forward to your response!

Regards,
Petar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
DataSource JSON Rendering Report Designer (standalone)
Asked by
Carlos
Top achievements
Rank 1
Iron
Iron
Iron
Answers by
Petar
Telerik team
Share this question
or