Cross Tab Report

jayanthi · Post by **jayanthi** » Wed Sep 30, 2009 3:50 am

Hai,

I have attached a sample report; in that Date,No of Ops, Lateness,Amount are Rows; APNB(One Way),APNB(Return) are columns;
Its are displayed in the order rows first then columns as like below
Date | No of Ops | Lateness | Amount | APNB(One Way) | APNB(Return)

Is it possible to display the report in the order as like
Date | APNB(One Way) | APNB(Return) | No of Ops | Lateness | Amount

I just only want to change the order and i dont want to interchange rows to column and vice versa.

Also is it possible to display total for No of Ops ,Lateness ,Amount

Thank you
Jay

Post by **Andrew** » Wed Sep 30, 2009 6:27 am

Hello,

If I understand you correct, you will not create a report such like yours using the CrossTab component. You need to use the Table component. Now we are working on it and very soon it will be available. But now you may build the report using the DataBand and the HeaderBand.
Please, see our report templates from Demo.

Thank you.

jayanthi · Post by **jayanthi** » Wed Sep 30, 2009 6:47 am

Hai,

Is it possible to create pivot based report using Header and Data band.

Thanx
Jay

Post by **Edward** » Wed Sep 30, 2009 3:23 pm

Hi Jay,

Please let us know the order in which you would like to have your rows ordered.

If you need just to group your table then a CrossTab component is not necessary and you can use a GroupHeader band to group the data and to calculate appropriate sums of each group.

For example:

{Sum(GroupHeaderBand1,MyDataSource.MyDataColumn)}

To know more about grouping please see 'Reports with Groups' section in 'Demo.exe' sample application and the following flashing tutorial:

http://www.stimulsoft.com/livedemos/Rep ... roups.html

Also please see the following tutorial:

http://www.stimulsoft.com/livedemos/Rep ... s-Tab.html

More tutorials you can find here:

http://stimulsoft.com/ReportsNetVideos.aspx

Thank you.

jayanthi · Post by **jayanthi** » Sat Oct 03, 2009 12:06 am

Hai Team,

First of all am really happy and thank you very much for all of your support.

Actually i created a cross tab report like the one in rptDailyClaim. In that Date,NoofOps,Lateness,Amount are Rows;
APNB(One Way), APNB(Return) are Dynamic column values.

Is it possible to print the report as like rptDailyClaim1.

Thank u
Jay

Post by **Edward** » Mon Oct 05, 2009 5:08 pm

Hi Jay,

Could you please send the data for the report and report template (mrt file) to support[at]stimulsoft.com which you managed to build,
we could help you with an advice how to improve it for the next step you described.

Thank you.