Jump to content
JasperReports Library 7.0 is now available ×

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

Go to solution Solved by Friendly User,

Recommended Posts

Hi Team,

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

 -----------                     ------------
        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.

Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic


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

 Company Bucket
 Steel 7


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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...