473,396 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

No Data from Crystal Report

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
2 5670
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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: John | last post by:
Hi. Sir: Does anyboday know how to export subreport data using the export button in crystal report tool bar? We have a main report including a on-demand report. When we click the on-demand...
2
by: Ceri | last post by:
I have been trying to display dataset data in a Crystal Report in a Crystal Reports Viewer using VB.Net. Displaying the data from the default xtreme.mdb Access database was no problem, but when...
3
by: Diggler | last post by:
I was working on a report that is populated with three different tables in a strongly-typed dataset. The tables are populated from custom objects rather than directly from SQL Server. I loop...
1
by: abc my vclass | last post by:
How to design and build reports which data source from business logic layer ? Is there any documents or tutorials explain the steps to design and build reports if my projects' data source from...
0
by: Sridhar | last post by:
Hi, I have a Crystal Report which has two sub reports in it. When I try to view this Crystal Report in my local computer, it is showing data for sub reports also. But when I deploy it to the web...
3
by: Tyranno.Lex | last post by:
I am using Visual Studio .NET 2003 and have successfully deployed a commercial web application written in C# and ASP.NET. I am now wanting to add reporting using Crystal Reports and am having a...
1
by: mike11d11 | last post by:
For some reason I'm getting no data populating in my crystal report. I built my crystal report off my dataset in my project, and I fill the dataset when opening the main form, and count the...
0
by: dilchahatahai | last post by:
Hi I am having a problem with crystal report . I can create a crystal reports . (new crystal report ->new->standerd->create new connection->dataset->choose data set->choose table ->add report...
8
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.