ktrinad Posted August 31, 2006 Share Posted August 31, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now