vbs and crystal reports

[elly00]

Hi

is it possible using vbs to run crystal report?
I don't know if it's better to pass data to print from vbs or pass the table to use to the report and read data from db

Could you help me on that?

thanks

 

[xwb]

There is an example of how to connect crystal reports using vbs in

https://www.techrepublic.com/forums/discussions/crystal-reports-ran-by-vbscript/

It is quite easy to read data from a DB - just look up ADODB or ODBC.

 

[elly00]

Hi

thanks for your help

Mau be i miss some dll because running the script I receive the error " ActiveX cannot create object CrystalRuntime.applicatin
I use crystal 11

Do you know If I cand download it from?
thanks

 

[strongm]

Try changing

[tt]Set objCRApp = CreateObject("CrystalRunTime.Application")[/tt]

to

[tt]Set objCRApp = CreateObject("CrystalRunTime.Application.11")[/tt]

 

[elly00]

mm no it doesn't work
Do you know if I could do the same thing without Crystal?
I need to print some lables from vbs...I don't know if I can use some other app calling it from vbs...

if I download crystal reports 2008 may be something is different?

Thanks

 

[xwb]

Brute force approach - look for Runtime.Application in the registry and stop when you find the one that has crystal in it.

 

[elly00]

Hi

I found it but....seems empty
see attach

 

[xwb]

So strongm's suggestion should have worked.

Are you sure it crashed where you think it did? Is there another CreateObject somewhere else in the code.

Can you put a few wscript.echo statements to see where it actually crashed.