Cross-Tab on the DataBand problem
Posted: 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
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