Report Wizard report not displaying SQL data

[ktrinad]

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 ;-)