Multiple records in dataset but only one page in report

[burlicconi]

Hi, 

I'm new with Jasper, but i was fine until I had to do the following thing:

In my dataset I have multiple records, say 23. I want to print them  line by line, every 23 lines in one page. Currently, my report has 23 pages and every page contain one record, which I don't want- I do want 23 lines in one page.

Does anybody know how to do this?

I searched for answer, but couln't find anything of use and I believe that I'm not the only one facin gsimialr issue- do I missing something obviously?

Thanks in advance!

[rajesh.sirsikar]

Hi 

Can you upload a screenshot of your report layout. That would help me to resolve teh iossue

Thanks

Rajesh S

[burlicconi]

Hi, I think it's pointless to upload a screenshot, instead I'll provide you with soem detailed example:

 

My record set has, for instance, 23 rows.

row_1: field_1A field_1B, field_1C

row_1: field_2A field_2B, field_2C

row_1: field_3A field_3B, field_3C

......

row_23: field_23A field_23B, field_23C

 

In my Jasper file, I have this:

field_1A, field_2A, field_3A.... field_23A

 

and my report has 23 pages, field_1A on 1st, field_2A on second.... field_23A on 23th, and i don't want hat, I just want one page with all fields_XA one by one in a single page...

 

Thank uou for answer!

[rajesh.sirsikar]

Hi,

I am not sure about the problem you are facing. I Cretaed a dataset (CSV Format) as per your input and a report. I am not facing any issue.

  

So Let me know whether the dataset I created is in teh right format. If yes, it will be better if you put a screenshot for better understanding.

[burlicconi]

Dataset you made is correct, but reprot you made is not as I described- you should not have

 

$F{Column1}, $F{Column2}, $F{Column3}

 

but:

 

$F{Field_1A}, $F{Field_2B} ...$F{Field_28C}

 

Difference is that I want to pick only one fild from every record and put them in a report (so, one page with 23 lines, not 23 pages with only one line) In your example, you have report in one page because you made small Detail band- expand it to maximal size and you'll get 23 pages, every one with 3 lines in it.

 

Thank you for your effrorts!

 

 

[rajesh.sirsikar]

Hi,

One way of achieving what you want is to Click Ignore Pagination button. For detailed explanation Check my blog

http://www.rajeshsirsikar.com/jaspersoft-studio-ignore-pagination/

This will ignore 23 pages and will put all your data into one page.

Thanks,

Rajesh S

[burlicconi]

Your answer and link are helpful, they are good reference for some kind of reports, but not I was looking for.

 

Here are images of what I need- I did what I want with tables, but I think it must be efficient way to do this:

 

This is my dataset:

http://screencast.com/t/irzMm5eMZGx

 

This is my report:

http://screencast.com/t/Te2j6BSm

Notice how much tables I have- this is very ugly and not intuitive, must be better way

 

This is content of one table (others are very similar):

http://screencast.com/t/4czW2RCa

 

This is result of my report:

http://screencast.com/t/oufz4k7cCWf

 

Of course, dataset, reprot, content and result are not 100% shown, but this is enough to get right impression.

 

I need PDF which will have 20+ records in one page(details band is maximized). If I use ignorePagination, I got all 20+ pages in one large page (which size is sum of 20+ pages) This large page is without page break, which is not good, because I have to PRINT PDF file on printer.

 

How I did it- in my base dataset I put some dummy SQL, only to return one record.

Then I made several table's datasets and every table use one of them. Then in every table I get data I need. But, as I said, this is ugly looking and you don't have right picture of what you're doing when you look in report design.

 

Also, I noticed that when I use table for showing, say 3 records, content of 2nd record is put BELOW content of 1st record, even if they are in the same row in table (just as there is two rows, one below another). Then 3rd record is below 2nd etc...

Why is this?

 

Thank you for your answer, I appreciate it!