Values Not Appearing Properly

[ericp]

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!!

[Lech Kulikowski]

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.

[ericp]

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!

[Lech Kulikowski]

Hello,

Thank you for the information.