Creating reports and dashboards | Stimulsoft community forum

Hello !

I must display sale history of properties.
I have a table Property and a table SalesHistory.
A property can be sold more than one time.

I tried to put a container in the Databand of properties and in this container I put another databand for the sales.
Here's the where of the query for the sales databand: where SalesHistory.NoInscr = '{Property.NoInscr}'

The problem is only the sales of the first property is displayed.

Maybe there's a better way to do this?

Thank you!

It is difficult to say something without a report template.

Please send the report template to support[at]stimulsoft.com for analysis.

Thank you.

Maybe you can use a Relation between the Main Databand(Properties) and the Childdataband Saleshistory.

Also set in the Saleshistory Databand the main Databand = Properties. And for sure the Relation which you are using.

So all your Properties with related Saleshistory will be printed.

Check it out.

Stephan