iReport 3.5.2 band issue

[niennamiriel]

hi everyone,

I had a question about bands on ireport. As you know there is a detail band and when we put a field in it, it shows up vertically. I have to make something with hours and I want to see hours horizontally up to 24 and I will write the details under them.

To wrap up,  I want to set detail band horizontally. How could I do that?

I had a report like..

01:00  34

02:00  40

03:00  45

04:00  56

05:00  23

.
.
.
.

00:00  54

I want to see like..

01:00 02:00 03:00 04:00 05:00 06:00 . . . . . .. . . . .  00:00

34      40      45      56      23      54 ............... . . . . . . 54

 

if someone helped me out about this topic, I would really appreciate it, Regards..

Sedef,

Post Edited by niennamiriel at 08/10/2009 12:22

[baggypants]

Probably by using the crosstab component.

Post Edited by baggypants at 08/10/2009 13:54

[niennamiriel]

baggypants
Wrote:

Probably by using the crosstab component. Post Edited by baggypants at 08/10/2009 13:54

thank you :) I did it, 

   I want to make smaller crosstab cells do you have any idea about this I really need it, when I did bigger cells it looks awfull
like

01   02   03   04   05   06   07   08   09   ...... 22

43   43  23   13    54   54  65   76    87..........76    

---------------------------------------------------------------

23   00

43   65

-------------------------------------------------------------

I want all of them in  a row
like

01   02   03   04   05   06   07   08   09   ...... 22   23   00

43   43  23   13    54   54  65   76    87..........76   43   65

Post Edited by niennamiriel at 08/11/2009 12:15

[dprogrammer]

Hi Sedef,

If you want to make your report cells to be smaller, just shrink the field widths and also move the vertical lines.

Another option would be to write your query as a pivot query. Search for key word 'pivot query' and you should find many examples. Once query is designed you can just drop the fields on the report, without creating and formating cross tabs, and you should achieve your format.

 

[niennamiriel]

okay thanks in advance, I did it..