CrossTab Report - How to create this type of report

[Omorak_Taybeh]

Hi,

I want to create this type of a report using cross tab. i am a fresh on ireport

the below is a picture of my report view which I want to create.

 

This is monthly summary report. 

Please help me as i am a fresher and this is the first time i use it .  Thank you.

[Tarun Gupta]

hey,,,

Firstly drop crosstab element in summary band,,

And then select row group ,,first one location field and second customer field that fetch from database,,,

and then coloum group ,,put date field and at last select measure your amount field and thats expression sum and then add a row group that field name "measures" and set class of the field string and total position none and bucket expression fetch from query,,

its looking like this and after this some padding ,,,,and finally report looking like this image ,,,Create Carefully its working that u like the format of report,,and delete another band without title,,,,because if u want something write in ur report so use title,,

[Omorak_Taybeh]

thank you Tarun, I will follow your steps one by one.

but one question please! can't i add the measures fields as a static? i mean ( revenue, quantity and margin) to be a static, since the query will give the sum and count as numbers. how i can add the name of column in crosstab?

i hope you understand what i mean.

thank you again

[Omorak_Taybeh]

!