Data returned from an SQL Strd Prcdr to a Crystal Rpt in an ASP page

[theodore79]

Hello.

I am new to creating crystal reports, regardless of the version, using ASP pages. I have an asp page that accepts parameters inputted or selected from a form and submits them to a stored procedure which queries my SQL table(s). I am able to dump the results of this stored procedure, field names and data, to a text file without any problem.

How do I publish those results to a crystal report? Is this a complicated process?

Your help would be greatly appreciated.

Thanks!

 

[synapsevampire]

Try:

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

Search for the ADOrecordset example.

You may be unfamiliar with Crystal, regardless of the version, but how one implements is contingent upon this, as with almost any software project, so please at least post your software version.

-k

 

[theodore79]

I have Crystal Reports 9. I downloaded the zip file you directed me to and am looking at it's contents. If I have any questions, I will display them in this thread.

Thanks!

 

[theodore79]

This has helped me tremendously! I am currently researching what a ttx file is and how to generate one 'on the fly' from the results of the dataset returned by my stored procedure.

Any tips? Things to look out for?

Thank You!