Report Generation with Single row when SQL Query is returning Multiple Records.

Posted on February 27, 2018 at 3:23am

Hi Team,

A Sql Query is returning the below results in the report :

COMPANYNAME     BUCKET
 -----------                     ------------
        Steel                   90+ day
        Steel                   90+ day
        Infra                   90+ day
        Coated               90+ day
        Coated               90+ day
        Steel                  90+ day
        Steel                 90+ day
        Steel                 90+ day
        Steel                 90+ day
        Cement             90+ day
        Steel                 90+ day

I am able to generate the above results successfully. 

But i want report as below table format :

COMPANYNAME    90+day Count
 ===========    ============
                Steel                7
                Infra                1
                Coated             2
                Cement            1

Could you please syggest me step by step.

Thank you.

JasperReports® Library
JasperReports® Server
Jaspersoft® ETL
nareshbangaram24's picture
nareshbangaram24
228
Joined: Feb 20 2018 - 11:25am
Last seen: 5 years 3 weeks ago

Could anybody please suggest me step by step. Thanks in advance 

nareshbangaram24 - 5 years 4 weeks ago
add comment

4 Answers:

Posted on February 28, 2018 at 4:18pm

Good to hear it was resolved. Just for others who are interested - place crosstab in Summary band and not Detail band.

Friendly User's picture
Friendly User
45825
Joined: Oct 8 2009 - 5:59am
Last seen: 2 weeks 2 days ago
Posted on February 27, 2018 at 6:43pm

Hello Naresh,

sounds like you need a crosstab with count calculation on the bucket. You can create a crosstab using a crosstab element. Set your company name as row group and your bucket as column group and your bucket as measure. Set the calculation to count.

Friendly User's picture
Friendly User
45825
Joined: Oct 8 2009 - 5:59am
Last seen: 2 weeks 2 days ago
Posted on February 27, 2018 at 7:02pm

Hi,

 I have tried with Crosstab. I am able to generate the table as what I needed below. 

  Company   Bucket
  Steel   7
Infra 1
Coated 2
Cement 1

 

But the problem is, this table is generating one time per each page. Means its genrating multiple times. I dont want multiple times. I need only one page which contains the above table. 

Please suggest me, where i am doing wrong ?

Thank you.

nareshbangaram24's picture
nareshbangaram24
228
Joined: Feb 20 2018 - 11:25am
Last seen: 5 years 3 weeks ago
Posted on February 27, 2018 at 10:20pm

It was resolved. :)

nareshbangaram24's picture
nareshbangaram24
228
Joined: Feb 20 2018 - 11:25am
Last seen: 5 years 3 weeks ago
Feedback