-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: ajilantony
Message 2 in Discussion
Hope this helps
Creating XSD DataSource for Reports<o:p></o:p>
<o:p></o:p>
Compile the SQL Query associated with a report into
a Database Stored Procedure. Note that the Stored procedure should have the
same name as referred by the Report fields. Alternatively, this can be
achieved by giving the Stored Procedure name to the Table element of the XSD.
Also, the Table name in the resulting dataset has to be given the same
name.<o:p></o:p>
Create an XSD using the newly created Stored
Procedure
<o:p></o:p>
Associating the XSD files with the existing
reports<o:p></o:p>
<o:p></o:p>
Log Off the current server associated with the
report (Database > Log On or Off Server)<o:p></o:p>
Create a new connection (ADO.Net (XML)) and specify
the path of corresponding XSD file. (Database > Log On or Off
Server)<o:p></o:p>
Set Datasource Location � Update the newly created
connection (Database > Set Datasource
Location)<o:p></o:p>
If the Datasource fields have names, which are
different from the existing report fields, Map the fields
accordingly.<o:p></o:p>
In cases where a datasource fields contains RTF
text, format the field to make �Text Interpretation� as
�RTF�.<o:p></o:p>
<o:p></o:p>
Associating the Data with the reports
<o:p></o:p>
Import
�CrystalDecisions.CrystalReports.Engine�
Create an instance of
ReportDocument<o:p></o:p>
Load the rpt file using the
ReportDocument.Load(rptFileName) method.<o:p></o:p>
Execute the corresponding Stored Procedure for the
report and set the DataTable/DataView as the DataSource for the
ReportDocument.
Eg:
Dim dsData as New DataSet
Dim crDocument as New ReportDocument
...... (Retrieve the dataset)
crDocument.Load(<rpt file path>)
crDocument.SetDataSource(dsData.Tables(0))
.....
cheers,
Ajil Antony
Invoke
ReportDocument.Export() method to export the report in the specified
format.<o:p></o:p>
----- Original Message -----
From:
kitty
To: BDOTNET
Sent: Thursday, December 11, 2003 6:49
PM
Subject: How can I connect a crystal
report file from VB.net?
New Message on BDOTNET
How can I
connect a crystal report file from VB.net?
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: kitty
Hi,
How can I connect a crystal report file from VB.net?
I want to filter the records in the view with the
selection
criteria from the Combo box.
If any has code please send me a sample one.
Regardskitty
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
