Cross Tab Report Group By Each Price Table

[Dinesh]

Hi Team,

There are many different price tables in the back end, when I multi select the two tables in "Price table name" drop down, it's combining two tables into one. Please see the below screenshot for your ref.

Wrong Result

Group of two tables.png (13.41 KiB) Viewed 1973 times

But I want exact result like the below screenshot.

Wrong Result

Group of two tables.png (13.41 KiB) Viewed 1973 times

And I've attached my sample .mrt file here.

Please check this and resolve the query as I have to complete a customer's request. Also advise me on how to achieve this.

Thanks and regards,
Dinesh

[Lech Kulikowski]

Hello,

Please send test data for your report.

Thank you.

[Dinesh]

Hello,

Sorry, I cannot send any test data. If you refer to the .mrt file attached in my post you can see the different Price bands that was called. Please create a data set yourself and let me know what's the output you are getting. If not please let me know if we made any mistakes in the .mrt file

Thanks

[Lech Kulikowski]

Hello,

Corr-Tab is not applied by groups bands. You should use master-detail instead of grouping for that task.
https://demo.stimulsoft.com/#Net/CrossTabOnDataBand

Thank you.