VFP9-ACTIVEX-CR2008

[jpowe60]

Not sure if this is the correct place for this but
i'm running vfp9/sp2. I have downloaded Crsystal Reports2008 evaluation copy. What I am trying to do is to use the activex control, olecontrol, using the crystalReports12.ActivexReportViewer.1 to view a crystal report. I use a form that passes the crystal report file name, c:\temp\client_agency_referral.rpt. When the control executes, i get the following.."OLE IDispatch exception code 0 from CrystalReports12.ActivexReportViewer.1: No file to view.." however, the report file is there...i run separately outside of vfp. After I cancled the error messagebox and clieck exit on the form,, it appears that I get a blank crystal reprot form in my form..Now I have executed this before using vfp8 and crystal reports 8.5 no problem...

can anyone tell me where /what i am doing wrong...
any suggestions greatly appreciated...thanks

 

[craigber]

How are you getting the data to Crystal?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com/blog

 

[jpowe60]

I am using a vfp select-sql stmts to create cursor then copy that result to a table on my c:\temp...

then running the form to view the report in cr2008

 

[craigber]

Does the report work from the Crystal Reports designer?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com/blog

 

[jpowe60]

yes...this is what i did...one separate steps i created cursor, copied the data to a table...went into cr2008 created the report...ran the report...
i can run the rport separately by going into cr2008..bring up the report name, press the f5 key and the data is displayed...
once i did those steps, i went a created my form, ran the form with the report name as a filter ...then i get the ide error when it does the view

 

[Mike Lewis]

What exactly do you mean when you say you "ran the form with the report name as a filter"?

You should setting the report viewer's ReportSource property to an object reference to the report object. In other words, something like this:

loCR = CREATEOBJECT("CrystalRuntime.Application")
loRep = ;
  loCR.OpenReport("c:\temp\client_agency_referral.rpt")
THISFORM.oMyReportViewer.ReportSource = loRep
THISFORM.oMyReportViewer.ViewReport

where oMyReportViewer is your ActiveX control.

I've never ran the above code in CR2008, but it runs in earlier versions.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[jpowe60]

sorry for the delay...those statements do work for CR versions 11,10,9, etc...however for cr2008 tjose stmt do not exist as per SAP/business Objects...they state that to do what i want that i have to migrate to .net ...


again thanks for the info

 

[Mike Lewis]

they state that to do what i want that i have to migrate to .net ...

That's a pity. Sounds like a good reason to stay with the earlier version.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business