Complex Report: Any Suggestions???

[Heathde]

We are producing a fairly complex report from an Access database. To this point we have used Access queries to obtain the data and perform all the calculations. Then using a .ttx file we are populating the .rpt file to produce the report.

The problem is that we want to get away from dependency on Access queries to do all the work and instead use an application (VB for example). We want to launch the application from an ASP page, have the application create all the recordsets (several will be required), perform all the calculations, and then feed the final values to Crystal Reports.

Question: can Crystal Reports take variables fed directly from an application? Or is there another approach that must be used?

Thanks to anyone with practical solutions here.

 

[dcm]

Heathde: The answer is an unequivocal YES. CR can be used with any language which supports COM e.g. VB, Delphi, C++ etc. to enable you to call a report from code and to pass throughto the report parameter variables set from your code. Check that you have the Developer edition if you are using v8 of CR (if not upgrade!) and you'll gain access to the CRPE API which will give you access to many of the features of your Crystal Reports.

If you need any more detail just ask David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner