Problem with DataBand into another DataBand

bolyan · Post by **bolyan** » Mon Feb 11, 2008 10:30 am

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!

Post by **Edward** » Mon Feb 11, 2008 11:32 pm

It is difficult to say something without a report template.

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

Thank you.

Stephan1 · Post by **Stephan1** » Tue Feb 12, 2008 10:34 am

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