vb scripts and crystal reports 1

[williey]

Hi.
I trying to use vb scripts to automate reports run in CR v8.0. Is there any good examples that is recommended?
Never used vb before except BASIC in the old days..

 

[vidru]

Do you mean VBScript as in HTML, or VB code, as in programming in Visual Basic (5, 6, .Net, etc.)?

.Net samples:

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_vbnet.pdf.asp

VB 6.0 samples:

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf.asp

ASP samples:

http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps8.exe.asp

-dave

 

[williey]

Dave.
I have created reports and would like to automate the report run at specific time of the day. VB scripts should allow me to do execute the report runs, right?

 

[vidru]

With VB, or some other programming language, you could certainly build your own report scheduler.

Or, you could have a look at some other third party tools that already have this capability:

http://www.kenhamady.com/bookmarks.html

BusinessObjectsCrystalDecisionsAOLTimeWarnerViacomExxon sells a product - Crystal Enterprise - that does this sort of thing (and many others) as well, if you've got buckets full of money lying around.

-dave

 

[synapsevampire]

Willey: You haven't stated the specifics that Dave asked for, do you mean that you're intending to use VBScript within a WEB page to display reports, or use Visual Basic, or?

I think that a 3rd party product might make sense for you.

<grinning at Dave>

Nice: &quot;BusinessObjectsCrystalDecisionsAOLTimeWarnerViacomExxon&quot;

Defintely worth a star, too bad it doesn't readily fit on a biz card:

CrystalDecisionsBusinessObjectsAOLTimeWarnerViacomExxon consultant

-k

 

[williey]

No I am not planning to using VB scripts within a Web page.
Rather I like to use VB or VB scripts to run the reports. I thinking I can schedule the scripts with MS scheduler.

This way I would not have to code for the scheduler.. just something that can execute the CR reports I had created.

 

[synapsevampire]

VBScript is a MS language for WEB development, not a subset of Visual Basic, hence the confusion.

As for scheduling the reports, Crystal does not support any sort of command line start up, so you'll have to invoke reports using the RDC or OCX (RDC is suggested).

It will probably be less expensive/time consuming to nab a 3rd party scheduling tool.

-k

 

[williey]

Buying a scheduling s/w is not an option. I did lookup Crystal Desk.

I just send to be able to execute the reports using VB scripts and the VB scripts in turn will be executed by Scheduler found in Win 2000. Any idea how to make use of the RDC to kick off the reports?

 

[vidru]

Start by downloading the above samples for the RDC (use the link under VB 6) and familiarize yourself with the object model.

Oh, and you have to have at least CR 8.0 Developer Edition to do any of this.

-dave