Create Report in VB

[yuben]

I would like to create a report from within VB. i have defined a report variable as CRAXDDT.Report and assigned a report to it. I use the report designer within VB.

I would like to assign a report by name to the report variable. I have tried this:
set MyReport = createobject("ReportName&quot
but this does not work.

Are there any suggestions on how I could use the report name (as a string) to create a report from within VB. Reason - I have >10 reports that I need to print/preview etc and more are added regularly. if I can store the report names in a database then the coding for printing/exporting is simplified a great deal.
Your help is appreciated.

 

[TimLarkin]

try this

dim appMyApp as New CRAXDDT.Application
dim rptMyReport as CRAXDDT.Report

Set rptMyReport = appMyApp.OpenReport(App.Path & "/Report1.rpt")