Visual basics project help report

pts.
Tags:
Visual Basic
I have successfully created a report in sql plus, now i need to create the same report with the same sql select statements for my data selection thru Visual Basics. I have the load command and screen created now i need to complete it any help. below is a sample of my select statements from SQL. SELECT DISTINCT 'V1.20MTCTECHF' VER,' ', LPAD(B.SSN_ID,13,'1800') EMPLOYEEID,' ', LPAD(B.SSN_ID,11,'0') EMPLOYEEIDD,' ', TO_CHAR(B.ORIG_HIRE_DT, 'YYYYMMDD') HIREDATE, ' ',B.LAST_NAME LASTNAME, B.FIRST_NAME FIRSTNAME, ' ', SUBSTR(B.MID_NAME,1,1) MIDNAME,' ', TO_CHAR(B.BIRTH_DT, 'YYYYMMDD') BIRTHDATE, B.SEX_CD SEXCD, B.MARITAL_CD MARITALCD, B.LN_1_ADR ADR1, B.LN_2_ADR ADR2, B.CITY_NAME CITY, B.MAIL_STATE_DC STATE, B.POSTAL_CD POSTAL, SUBSTR(B.COUNTRY_CD,1,2) COUNTRY, ' MM' MM, TO_CHAR(D.EFFECT_DT, 'YYYYMMDD') COVERAGESTART, '0700977 0700977' NUM,' ', DECODE(D.BEN_PLAN_CD,'UHCALL','0007','UHCBASIC','0011') STRUCTURE ,' ', DECODE(D.BEN_PLAN_CD,'UHCALL','0007','UHCBASIC','0011') STRUCTURE2 ,' ', 'PDG' MM2, TO_CHAR(D.EFFECT_DT, 'YYYYMMDD') COVERAGESTART2,' ', '0700977 0700977' NUM2,' ', DECODE(D.BEN_PLAN_CD,'UHCALL','0007','UHCBASIC','0011') STRUCTURE3,' ', DECODE(D.BEN_PLAN_CD,'UHCALL','0007','UHCBASIC','0011') STRUCTURE4, '|'||CHR(10) EM,

Answer Wiki

Thanks. We'll let you know when a new response is added.

you can create a report from this sql using crystal reports and then call that from vb.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following