Creating reports and dashboards | Stimulsoft community forum

Hello, I have been trying to create a "Project Changes" report, the goal of this report is to display the new values to a project if there was changes from the previous version.

Some background is that I am pulling the information from a JSON that has the following format:

[CurrentProjectRevision]
---[Values]
-----[CurrentProjectRevision.Funding]
-----[CurrentProjectRevision.Location]
[PreviousProjectRevision]
---[Values]
-----[PreviousProjectRevision.Funding]
-----[PreviousProjectRevision.Location]

I have been successful in creating relationships to get a lot of my base information to appear in just the [CurrentProjectRevision] and [PreviousProjectRevision] databands in Stimulsoft. The issue i'm running into now is that for the [Location] object that I created a relationship for, it is not always showing up (everything is working as expected, it's just the relationship that I created by having my Location values in my [ProjectRevision] databand.

I have attached the mrt file that I have been working on, along with the JSON file (I'm okay for it to just display the first value of the [Location]
I'm not sure if it is because my [Location] sub-array, has multiple objects within it, but I have been trying to solve this for a few days now. If you can please help, that would be great. Thank you!!

Hello,

You try to show one value from LocationDetails on the master band, but there are records where several different values.
Could you explain it?

Thank you.

Hey @Lech,

I was able to solve my question by just creating a panel inside my databand that linked to the LocationDetails. My report is working as expected now.

THanks!

Hello,

Thank you for the information.