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

[nareshbangaram24]

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]

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

[Friendly User]

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.

[nareshbangaram24]

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]

It was resolved. :)

[Friendly User]

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