Jump to content
Changes to the Jaspersoft community edition download ×

Report Wizard report not displaying SQL data


ktrinad

Recommended Posts

By: Dan Obernesser - danobie

Report Wizard report not displaying SQL data

2003-10-01 09:30

I have built a report using the report wizard, based on a rather simple SQL query.

select PROD_CD,CARD_TYPE_CD,

sum(BEGINNING_MONTH_CT) Beginning_of_Period,

sum(NEW_MEMBER_CT) New_Member,

sum(VOLUNTARY_ATTRITION_CT) Voluntary_Attrition,

sum(INVOLUNTARY_ATTRITION_CT) Involuntary_Attrition,

sum(TRANSFER_ADJUSTMENT_CT) Adjustments,

sum(END_PERIOD_CT) End_of_Period

from GLB_CARD_MEMBER

where ORG_ID = '800004'

and ACCT_MONTH_NO = 6

and ACCT_YEAR_NO = 2000

group by PROD_CD,CARD_TYPE_CD

order by CARD_TYPE_CD, PROD_CD desc

 

The report compiles and runs great, however, no data is being displayed for any of the fields in the report. The report is creating all of the rows that are returned by the query(several pages in the report produced), but the rows only contain the text fields in the report, not the data associated with each text field.

Anyone run into this issue before?

Any kind of help would be much appreciated.

Thanks,

Obie.

 

 

 

 

By: Giulio Toffoli - gt78

RE: Report Wizard report not displaying SQL data

2003-10-01 09:46

Try to increase the fields height.

 

Giulio

 

 

 

 

By: Dan Obernesser - danobie

RE: Report Wizard report not displaying SQL data

2003-10-01 10:22

Thanks for your quick response Giulio!

There is a setting in the field properties box, under the "Text Field" tab, called "Stretch With Overflow". By checking that box, the issue was resolved.

 

Thanks again,

Dan.

 

 

 

 

 

By: Giulio Toffoli - gt78

RE: Report Wizard report not displaying SQL data

2003-10-02 02:21

Of course ;-)

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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