Hello Marek,
Please send us a sample report with data for analysis. Also please describe your task in details.
Thank you.
Sorting records in CrossTab
Sorting records in CrossTab
Hello,
unfortunatelly I can not send you my report because this is join to our big company database with big data. Bud my problem is very simple - I have a select to DB which I use for my cross table report. Result of this select is for example 60 pages of records and every record is a group of other records. So I have group according to for example column "NAME", but in cross table I need records sort according to calculate column "PROFIT" and then I need see only first 20 records with the highest PROFIT and then last 20 records with the lowest PROFIT.
How?
PS: Just now our company thinking about a new reporting solution for us and Stimulsoft Reports was main favorite. But now our director is very angry at functionality of CrossTable component in Stimulsoft Reports.
Thanks
Marek
unfortunatelly I can not send you my report because this is join to our big company database with big data. Bud my problem is very simple - I have a select to DB which I use for my cross table report. Result of this select is for example 60 pages of records and every record is a group of other records. So I have group according to for example column "NAME", but in cross table I need records sort according to calculate column "PROFIT" and then I need see only first 20 records with the highest PROFIT and then last 20 records with the lowest PROFIT.
How?
PS: Just now our company thinking about a new reporting solution for us and Stimulsoft Reports was main favorite. But now our director is very angry at functionality of CrossTable component in Stimulsoft Reports.
Thanks
Marek
Sorting records in CrossTab
Hello Marek,
It is difficult to advise something without a sample report. Alternatively, you can try to use the "Data from CrossTab". In this data source, please set the filter and sorting and use it as a data source for the second cross-tab.
Thank you.
It is difficult to advise something without a sample report. Alternatively, you can try to use the "Data from CrossTab". In this data source, please set the filter and sorting and use it as a data source for the second cross-tab.
Thank you.