Page 1 of 1

Cross Tab Report Group By Each Price Table

Posted: Wed Feb 16, 2022 5:01 am
by 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
Wrong Result
Group of two tables.png (13.41 KiB) Viewed 1975 times
But I want exact result like the below screenshot.
Wrong Result
Wrong Result
Group of two tables.png (13.41 KiB) Viewed 1975 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

Re: Cross Tab Report Group By Each Price Table

Posted: Wed Feb 16, 2022 8:21 am
by Lech Kulikowski
Hello,

Please send test data for your report.

Thank you.

Re: Cross Tab Report Group By Each Price Table

Posted: Thu Feb 17, 2022 2:37 am
by 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

Re: Cross Tab Report Group By Each Price Table

Posted: Thu Feb 17, 2022 10:12 am
by 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.