Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Connectivity Query Post Reply Post New Topic
Author Message
madhu820
Newbie
Newbie


Joined: 11 Jun 2007
Location: India
Online Status: Offline
Posts: 4
Quote madhu820 Replybullet Topic: Connectivity Query
    Posted: 25 Jun 2007 at 7:02am
Hi all,
 
I am new to crystal reports. Recently I have been working on .Net 2003. Now I have to generate some of the reports,charts using Crystal reports. Previously I have used Manco Charts and other stuff to generate reports But now I have to switch to crstal reports.
 
For security reasons, My application requires that crystal reports should not be connected directly to the database. Instead is there any possibilty that crystal reports can create some adaptors, which can run the protocol which I am presently using to connect to database.
 
Otherwise can crystal reports generate graphs if we provide the data(which I already pooled from the database and stored in some variables)directly.
 
 
Thanks in advance
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Jun 2007 at 10:48am
You can create and populate a DataSet object with VS.NET 2003 and use that as the datasource for your CR app. Be sure to save the DataSet's schema to a .XSD file and use that as the source for the report design. Whenever you modify the datasource structure, even in the most minute way, you have to generate a new .XSD and update CR with it. Otherwise you'll get Login errors.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
madhu820
Newbie
Newbie


Joined: 11 Jun 2007
Location: India
Online Status: Offline
Posts: 4
Quote madhu820 Replybullet Posted: 25 Jun 2007 at 9:17pm
Hi Sir,
 
I have tried. But I am not getting it. can you provide me an example so that I can use it. Thanks in advance.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Jun 2007 at 11:11pm
Let me find my book....Here is the quick and dirty.

1) write the code to populate your dataset.
2) Add the ".WriteXMLSchema()" call so it saves the .XSD file
3) Comment out that line b/c you don't need it anymore unless you modify the sql query again in the future
4) Build a new report and use the XSD file as the data source.
5) Assign the dataset to the report by call ingReportDocument.SetDataSource(dataset)
6) assign your report to to the report viewer




Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.