Crystal Report Unbound Fields

[Rick Thiel]

Hello,

I am trying to build a Crystal report VisualStudio.NET for an ASP.NET
application. I would like to build a report that doesn't connect to
any particular database at design time because I am planning to pass a
dataset to the report at runtime. From what I have read, it sounds
like unbound fields might be the answer. However, I am having trouble
figuring out how to bind these unbound fields to my dataset at
runtime.

Any help would be greatly appreciated! thanks, --Rick

//Here is the code I have so far...
ReportDocument crReportDocument = new ReportDocument();

//Grab the dataset from session
DataSet ds = (DataSet)Session["CRDataset"];
DataTable dt = ds.Tables["MY_TABLE"];

//load the report from disk
crReportDocument.Load(@"C:\Inetpub\wwwroot\MyApp\Reports\MySummary.rpt");
crReportDocument.SetDataSource(dt);

//*****************************
// TODO: I have an unbound field named "UnboundString1"
// I need to assign a column from the dataset to that field.
// Is that possible on an ASP.NET application
//*****************************

//set the options for saving the exported file to disk
DiskFileDestinationOptions dfdOptions = new
DiskFileDestinationOptions();
dfdOptions.DiskFileName = strPathFname;

//set the exporting information
ExportOptions crExportOptions = new ExportOptions();
crExportOptions = crReportDocument.ExportOptions;
crExportOptions.DestinationOptions = dfdOptions;
crExportOptions.ExportDestinationType =
ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;

//Export the report and write the file to the client browser
crReportDocument.Export();

 

[Scott]

There's getting to be quite a few Crystal questions in these groups. Does
anyone know how we can get MS to add a
microsoft.public.dotnet.crystalreports group?

Sorry for not being able to help with your question. <g>

Scott

 

[Rick Thiel]

UPDATE: I emailed crystal about this subject and here is there response:

Hello Rick,

First I would like to thank you for using Answer By Emails (ABE) service.

Unfortunately, unbound field is not supported in Crystal Reports for
VS.NET.

For information on using Crystal Reports for Visual Studio .NET with
ADO.NET, go to 'http://support.crystaldecisions.com/docs' and search for:
'crnet_adonet.pdf'

For a sample application demonstrating passing an ADO.NET dataset to a
report, go to http://support.crystaldecisions.com/download and search for:
Vbnet_win_adodotnet.exe

 

[Yan-Hong Huang[MSFT]]

Hello Rich,

Thanks for posting in the group and sharing the information here. I believe
it could help Crystal Report developers much here.

For the question, please try using the SetDataSource method to do it at
runtime.
Eg.:
myConn = new SqlConnection("Server=.;Database=Northwind;Integrated
Security=true;");
SqlDataAdapter adapter = new SqlDataAdapter("select EmployeeID, LastName,
Firstname, HireDate from employees",myConn);
adapter.Fill(myNorthwindDS,"Employees");
myNorthwindReport.SetDataSource(myNorthwindDS);
crystalReportViewer1.ReportSource = myNorthwindReport;

Hope that helps.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!From: (e-mail address removed) (Rick Thiel)
!Newsgroups: microsoft.public.dotnet.general
!Subject: Re: Crystal Report Unbound Fields
!Date: 15 Sep 2003 06:13:28 -0700
!Organization: http://groups.google.com/
!Lines: 63
!Message-ID: <[email protected]>
!References: <[email protected]>
!NNTP-Posting-Host: 198.7.47.200
!Content-Type: text/plain; charset=ISO-8859-1
!Content-Transfer-Encoding: 8bit
!X-Trace: posting.google.com 1063631609 5918 127.0.0.1 (15 Sep 2003
13:13:29 GMT)
!X-Complaints-To: (e-mail address removed)
!NNTP-Posting-Date: 15 Sep 2003 13:13:29 GMT
!Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
..phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!n
ews.maxwell.syr.edu!news-out1.nntp.be!propagator2-sterling!news-in-sterling.
newsfeed.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-
01!sn-xit-09!supernews.com!postnews1.google.com!not-for-mail
!Xref: cpmsftngxa07.phx.gbl microsoft.public.dotnet.general:108219
!X-Tomcat-NG: microsoft.public.dotnet.general
!
!UPDATE: I emailed crystal about this subject and here is there response:
!
!Hello Rick,
!
!First I would like to thank you for using Answer By Emails (ABE) service.
!
!Unfortunately, unbound field is not supported in Crystal Reports for
!VS.NET.
!
!For information on using Crystal Reports for Visual Studio .NET with
!ADO.NET, go to 'http://support.crystaldecisions.com/docs' and search for:
!'crnet_adonet.pdf'
!
!For a sample application demonstrating passing an ADO.NET dataset to a
!report, go to http://support.crystaldecisions.com/download and search for:
!Vbnet_win_adodotnet.exe
!
!
[email protected] (Rick Thiel) wrote in message
!> Hello,
!>
!> I am trying to build a Crystal report VisualStudio.NET for an ASP.NET
!> application. I would like to build a report that doesn't connect to
!> any particular database at design time because I am planning to pass a
!> dataset to the report at runtime. From what I have read, it sounds
!> like unbound fields might be the answer. However, I am having trouble
!> figuring out how to bind these unbound fields to my dataset at
!> runtime.
!>
!> Any help would be greatly appreciated! thanks, --Rick
!>
!> //Here is the code I have so far...
!> ReportDocument crReportDocument = new ReportDocument();
!>
!> //Grab the dataset from session
!> DataSet ds = (DataSet)Session["CRDataset"];
!> DataTable dt = ds.Tables["MY_TABLE"];
!>
!> //load the report from disk
!> crReportDocument.Load(@"C:\Inetpub\wwwroot\MyApp\Reports\MySummary.rpt");
!> crReportDocument.SetDataSource(dt);
!>
!> //*****************************
!> // TODO: I have an unbound field named "UnboundString1"
!> // I need to assign a column from the dataset to that field.
!> // Is that possible on an ASP.NET application
!> //*****************************
!>
!> //set the options for saving the exported file to disk
!> DiskFileDestinationOptions dfdOptions = new
!> DiskFileDestinationOptions();
!> dfdOptions.DiskFileName = strPathFname;
!>
!> //set the exporting information
!> ExportOptions crExportOptions = new ExportOptions();
!> crExportOptions = crReportDocument.ExportOptions;
!> crExportOptions.DestinationOptions = dfdOptions;
!> crExportOptions.ExportDestinationType =
!> ExportDestinationType.DiskFile;
!> crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
!>
!> //Export the report and write the file to the client browser
!> crReportDocument.Export();
!

 

[John Eikanger [MSFT]]

Hi, Scott

Crystal Reports has always generated a lot of questions.
Microsoft.public.vb.crystal gets a lot of traffic, but it also causes
confusion. because Crystal is not a Microsoft product, even though it
ships with VS.Net, Our policy has been to point our customers at Crystal's
site, http://www.crystaldecisions.com/ because that is where Crystal
Decisions has committed to be. They have a self-help section and they offer
phone & e-mail support. Their web sites states that you get two Crystal
incidents with the purchase of Visual Studio .NET.

I hope that this clarifies things a bit,

John Eikanger
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.
"Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."

--------------------
| From: "Scott" <[email protected]>
| References: <[email protected]>
| Subject: Re: Crystal Report Unbound Fields
| Date: Sat, 13 Sep 2003 18:25:25 -0600
| Lines: 11
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| There's getting to be quite a few Crystal questions in these groups. Does
| anyone know how we can get MS to add a
| microsoft.public.dotnet.crystalreports group?
|
| Sorry for not being able to help with your question. <g>
|
| Scott
|
| > I am trying to build a Crystal report VisualStudio.NET for an ASP.NET
|
|
|