By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

No Data from Crystal Report

P: n/a
Hi all,

I am trying to do my first Crystal Report with the bundled version of
VB.Net version 2003. I am familiar with creating reports in Crystal
version 9...so I though it would be a piece of cake. I cannot get any
data to display with the report. I am using

* a form that host's the CrystalReportViewer,
* a ReportDocument that points to the report,
* a SqlDataAdapter
* and a SqlConnection.

I have generated a dataset throught the SqlDataAdapter which created
the xsd. file. I have set the CrystalReportViewer.ReportSource to the
created report. The database is set for ADO.NET datasets and points
to the dataset

When I run the report column fields shows but no data. In the Field
Explorer, I choose Browse Field Data and it displays no data for any
of the fields.

Do I need code in the form that hosts the CrystalReportViewer?
I have tried the following 2 lines in the form load event

crPreveiwLabels.SetDataSource(dsPreviewLabels)
CrystalReportViewer1.ReportSource = crPreveiwLabels

What am I missing to generate a simple, straight forward report with
no parameters read from an ADO.NET dataset.

Any samples would be appreciated.
thanks
Dave McKie
10/28/2004
da*********@yahoo.com
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Dave,

The Crystal Report site
(http://support.businessobjects.com/f...ds_updates.asp) has about 2
dozen sample applications that for VB.Net 2003 that show you all the code
necessary.

go to this link, scroll down to the bottom of the page to the section Sample
Reports and Applications. There you will find the gold mine you are looking
for. Let me know if you need more help.

Scott

"Dave McKie" wrote:
Hi all,

I am trying to do my first Crystal Report with the bundled version of
VB.Net version 2003. I am familiar with creating reports in Crystal
version 9...so I though it would be a piece of cake. I cannot get any
data to display with the report. I am using

* a form that host's the CrystalReportViewer,
* a ReportDocument that points to the report,
* a SqlDataAdapter
* and a SqlConnection.

I have generated a dataset throught the SqlDataAdapter which created
the xsd. file. I have set the CrystalReportViewer.ReportSource to the
created report. The database is set for ADO.NET datasets and points
to the dataset

When I run the report column fields shows but no data. In the Field
Explorer, I choose Browse Field Data and it displays no data for any
of the fields.

Do I need code in the form that hosts the CrystalReportViewer?
I have tried the following 2 lines in the form load event

crPreveiwLabels.SetDataSource(dsPreviewLabels)
CrystalReportViewer1.ReportSource = crPreveiwLabels

What am I missing to generate a simple, straight forward report with
no parameters read from an ADO.NET dataset.

Any samples would be appreciated.
thanks
Dave McKie
10/28/2004
da*********@yahoo.com

Nov 21 '05 #2

P: n/a

"Dave McKie" <da*********@yahoo.com> schrieb im Newsbeitrag
news:b6**************************@posting.google.c om...
Hi all,

I am trying to do my first Crystal Report with the bundled version of
VB.Net version 2003. I am familiar with creating reports in Crystal
version 9...so I though it would be a piece of cake. I cannot get any
data to display with the report. I am using

* a form that host's the CrystalReportViewer,
* a ReportDocument that points to the report,
* a SqlDataAdapter
* and a SqlConnection.


Here are some links:
http://support.businessobjects.com/c...ps_net.pdf.asp
http://support.crystaldecisions.com/..._vbnet.pdf.asp
http://support.businessobjects.com/c...deployment.pdf
http://support.businessobjects.com/c...oyment.pdf.asp
http://support.businessobjects.com/c...etdatasets.pdf
http://support.businessobjects.com/c...net_adonet.pdf
http://www.c-sharpcorner.com/Code/20...troduction.asp
http://www.businessobjects.com/globa...rtup_guide.zip
http://support.businessobjects.com/c...les_en.zip.asp
http://support.businessobjects.com/c...nal_en.zip.asp
http://www.123aspx.com/redir.aspx?res=30160
http://support.crystaldecisions.com/...viewer.pdf.asp
http://www.dotnetjunkies.com/Tutoria...A588D33D3.dcik
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1031/crystlmn/html/crtskdeployingw
indowsapplications.htm
http://www.codeproject.com/csharp/creasy.asp
http://www.codeproject.com/csharp/ReportFramework.asp
http://www.codeproject.com/Purgatory...parameters.asp
http://www.planetsourcecode.com/vb/s...2065&lngWId=10

Greeting

Thomas
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.