Exporting to a web server

[sterankin]

Hey all,sorry if this in the wrong forum.

I have just got crystal reports 9 dev edition.

I would like to export the reports through VB6 every hour or so, to a server computer.

First off, how possible is that to do, I take it I need to use a timer, I am able to export ok in code, but what is the best way to ensure it happens every x number of mins?

Also, on the server PC, I take it I need to run a web server of some kind? E.g. I could run Apache web server or MS personal web server? something like that?

Then from the desktop PC that has the VB program, I just export the report as html to a known path of the Server PC (assuming it has a mapped network drive or something).


So finally after all this is completed, the user from a third pc, can type into IE "http://webserveraddress/folder/report.html"

and the report will appear?

Thx for any clarification on this matter, I am new to this sort of thing.

Thx

[plenderj]

For the timing side of things yes a timer would be best. The resolution of the timer isn't 100%, so use a small interval and count the number of minutes or seconds yourself up to 60 minutes.

For exporting to a webserver, what I suggest you do is first ensure you can export to a .html file.
This might be just getting the data into an easy to use form, put HTML tags around certain bits, and save as a .html file

I suggest that you have the network administrator share the folder in which the report file should reside on the network, and just give your computer access.
So that way you can write to the folder just like you would to your own drive. The web server can then serve up that report file as it would other webpage files.

[sterankin]

Thanks

That makes sense.