Crystal and SQL Server Stored Proc's and VB6
I have the same problem as James below. The two
differences that I have is that I am only passing one
parameter (a number) and I am using the crystal control on
my VB form.
Any help would be greatly appreciated.
TIA
Nate
Quote:
>-----Original Message-----
>This is a really late reply. But what you require can be
done. If you
>haven't figured out how to do it, just reply to this
message, and I will
>explain a few techniques to achieve your requirement.
>> Hi
>> Could someone please tell me how you do the following
in VB6
>> 1. Open an existing Crystal Report
>> 2. Connect the report via the SQL 2000 Stored Proc
that is used to
>> populate the report to the database using ADO
>> 2.a Populate the Stored Procedure parameters and the
report parameters (
>> passed to the procedure at runtime from a VB Forms
controls )
>> 3. Display the report
>> 4. programmatically export it as a PDF file ( either
before or after it
>> is displayed )
>> The
>> report path
>> database login
>> database password
>> filename ( for the pdf export)
>> will all be passed as parameters to the main procedure
>> The oldb provider will be hard coded ( for the time
being ) as SQLOLEDB
>> I will have set a reference to the ActiveX Designer Run
Time Library
>> and added the Crystal Report Viewer to the VB form and
added a reference
>to
>> the ActiveX 2.7 ADO Library
>> The following will be added to the general declarations
section of the
>form
>> Dim crApplication As CRAXDRT.Application
>> Dim crReport As CRAXDRT.Report
>> The following will be added to the form load event
>> Private Sub Form_Load()
>> Set crApplication = New CRAXDRT.Application
>> Set crReport = crApplication.OpenReport( "report
path")
>> NOW I AS STUCK
>> I have tried many different solutions all of which
failed
>> Any and all help welcome
>> Thanks in Advance
>> James
>.
