Adding an image to a Crystal Report

Question

Hi,

I'm new to Crystal reports, but I have to get a report done by the end of today! I've read up on the basics, and it seems similar to Access Reports.

I understand that I can simply drag and drop fields onto the designer, from both table fields (pull) and datasets (push).

I have an image column (stored as a byte array) in SQL Server 2000. If I select the relevant records into a Dataset, including the image, will I be able to simply drag and drop the image onto the designer from the dataset?

I don't have access to my PC at the moment, otherwise I could try this and find the answer. I'm hoping somebody out there can give me some pointers and save me a lot of time trying figure it out!

I'm using VS.net 2003 and the default Crystal Reports that comes with that.

Any advice, pointers, URLs and sample code would be very much appreciated!

Thanks!

Answer 1

I've been searching on the net for the best way to fill my report from a dataset. There are examples that use Strongly Typed Datasets and examples that use normal datasets (see below).

How do I specify the exact query I want to execute in order to fill a Types dataset?

Will the below code for normal datasets conenct the dataset to a specific report, or just create a fresh report based ont he dataset object?

http://msdn.microsoft.com/library/en-us/crystlmn/html/crtsksettingupanado.netreportinaviewer.asp

using System.Data.OleDb;
public CrystalReport1 oRpt = new CrystalReport1();

// set up connection information
OleDbConnection oleConn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Microsoft Visual Studio .NET 2003\\Crystal Reports\\Samples\\Database\\xtreme.mdb");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter ("SELECT * FROM Customer", oleConn);
DataSet dataSet = new DataSet ();

// Connect to, fetch data and disconnect from database
dataAdapter.Fill (dataSet, "Customer");

// Use Report Engine object model to pass populated dataset to report
oRpt.SetDataSource (dataSet);

// bind report object with data to the Windows Forms Viewer
crystalReportViewer1.ReportSource = oRpt;

 

Answer 2

Anyone? Please??

Answer 3

Hello,

Here is a link to the top tech articles from Business Objects technical support.

http://support.businessobjects.com/fix/toptech.asp

Check out this specific tech article:

http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf.asp

There are more samples available from our devzone at:

http://www.businessobjects.com/products/dev_zone/net/default.asp?ref=devzone_main

Keith - Business Objects