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

0

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.

nareshbangaram24's picture
Joined: Feb 20 2018 - 11:25am
Last seen: 1 year 8 months ago

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

nareshbangaram24 - 1 year 8 months ago

4 Answers:

0

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
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 8 hours ago
0

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
Joined: Oct 8 2009 - 5:59am
Last seen: 3 days 8 hours ago
0

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
Joined: Feb 20 2018 - 11:25am
Last seen: 1 year 8 months ago
0

It was resolved. :)

nareshbangaram24's picture
Joined: Feb 20 2018 - 11:25am
Last seen: 1 year 8 months ago
Feedback
randomness