Cross-Tab on the DataBand problem

amator · Post by **amator** » Sat Nov 17, 2007 10:01 am

Hello!

I have been trying to create a cross-tab report similar to the "Cross-Tab on the Databand report" that you have in the Demo.exe application.

The sample from Demo.exe works perfectly, but I ran into an issue when trying to do similar report with NWIND.mdb.

I have created 2 datasources (Categories - Products), created a parent-child relation between them,
then placed 2 databands in the designer area and set relation between those
databands, also set a master databand for the child one.

In the products databand I have created a Cross-Tab.

When I run this report, it does not filter out the child (products) databand by Categories, it just repeats the whole
Cross-tab for all categories under each category.

I must be doing something wrong?

I have attached the referenced report 'sampleCrossOnDataband.mrt'.
You will see that under 'Bevereges' category it shows all products from all categories, whereas it should only
show products under 'Bevereges'.

I have tried to achieve the same result with 'Group' band instead of master databand, but there was also a problem
as the group header only processed the first category.

Please find 'sampleCrossOnDatabandWithGroup.mrt' attached.

Thank you, appreciate any help.

PS I have sent files to support at stimulsoft.com

Brendan · Post by **Brendan** » Sat Nov 17, 2007 10:40 am

Hi

Did you set the DataRelation property of the CrossTab to Products?

Post by **Vital** » Sat Nov 17, 2007 12:46 pm

Hello,

You need set data relation in CrossTab. You can do this with help of property DataRelation.

Thank you.