sillypaul1983
May 10th, 2006, 10:49 AM
In a nutshell
I have a report, and a vb6 which calls it, thou the results are not the same, when called from vb6, other then just opening in cr and runing it.. The only thing which is different is that the dynamic location images, does not appear, everything else does ?
In a Sea Sure Shell
Vb does not pass anything to the report, because the report always looks at the same database (mdb) when it runs, infact i just fill the database as i want with vb, and then call the report..
Its just one record in a 6 colum type, all text fields, one date time field..
All of which show fine, apart from one, being a txt field which contains a location of a picture such as C:\Pics\blah.jpg
But this does not show on the report when called, just the other records..
I am using the new Image Location field in cr11, which i've used lots, so i know the reports right and works fine, because like i said, if i preview in cr itself, it works great..
So the problem must be when i call it, in my vb program, i have the following code
======Code=============
Dim oApp As CRAXDRT.Application
Dim oReport As CRAXDRT.Report
Set oApp = New CRAXDRT.Application
Set oReport = oApp.OpenReport("C:\offer.rpt", 1)
crvMyCRViewer.ReportSource = oReport
crvMyCRViewer.ViewReport
frmPrint.Show
======End Code==========
Which shows it on the screen, but with no pictures, i've checked the database, file path is fine
anyways come across this b4 ?????
Any help on this would be great
thanks for your time
I have a report, and a vb6 which calls it, thou the results are not the same, when called from vb6, other then just opening in cr and runing it.. The only thing which is different is that the dynamic location images, does not appear, everything else does ?
In a Sea Sure Shell
Vb does not pass anything to the report, because the report always looks at the same database (mdb) when it runs, infact i just fill the database as i want with vb, and then call the report..
Its just one record in a 6 colum type, all text fields, one date time field..
All of which show fine, apart from one, being a txt field which contains a location of a picture such as C:\Pics\blah.jpg
But this does not show on the report when called, just the other records..
I am using the new Image Location field in cr11, which i've used lots, so i know the reports right and works fine, because like i said, if i preview in cr itself, it works great..
So the problem must be when i call it, in my vb program, i have the following code
======Code=============
Dim oApp As CRAXDRT.Application
Dim oReport As CRAXDRT.Report
Set oApp = New CRAXDRT.Application
Set oReport = oApp.OpenReport("C:\offer.rpt", 1)
crvMyCRViewer.ReportSource = oReport
crvMyCRViewer.ViewReport
frmPrint.Show
======End Code==========
Which shows it on the screen, but with no pictures, i've checked the database, file path is fine
anyways come across this b4 ?????
Any help on this would be great
thanks for your time