Failed to Open Rowset Error in Crystal Reports

hello all,

i have developed a desktop application(software) inwhich used Crystal Reports 9. I am using Microsoft Developement Environment 2003 (Visual Studio 2003).The reports in this software runs well on my own system where i developed the software but when I install this software on the computer(client computer), the report does not open when the Generate Report button is clicked. This button click event fills the data using a simple query from databse(SQL Server 2000) and this error is displayed:

Failed to open Rowset.

The .Net Framework 1.1 is installed on the client computer before the software is installed and run.

I also include some merge modules in the setup of the project that I make. These merge modules are:

Crystal_Database_Access_enu2003.msm

Crystal_regwiz2003.msn

Crystal_Database_Access2003.msm

Crystal_managed2003.msm

Please help me to resolve this problem so that on the client computer the reports are displayed and data is shown.

Thanks in advance

hello all again,

I posted this problem yesterday and got no reply yet.

please help me solve this problem. I am in great need of this reporting software but don't know what is missing or wrong which is creating problem

Thanks all of you!

|||

Hi,

I have the exact problem. If some one can reply it will be great.

Thanx.

|||This sounds like a Crystal Reports issue. This forum is for questions regarding SQL Server Reporting Services.

Failed to open a rowset (Crystal Reports)

I am using Visual Studio .NET 2003 and the version of Crystal that comes with it. I have a problem that when a report is displayed and it doesn't have any data I receive the following error message "Failed to open a rowset" and only a blank screen is shown. I need at least the Header labels to show. How can I make it show at least the header labels.Ok, I figured it out. The stored procedure that runs the report gathers data into a temp table. If the there isn't any data it made the report error out. I rewrote the SP to not use a temp table and all is working well.|||hey,
i am having the same problem with Crystal reports.
i have a few Crystal Reports that were being used as stand-alone reports.
Now i would like to develop an application (WITHOUT including the reports into the application) that shows all the reports that are in a specific directory (done!), list all the report names in a listview (done), and when the user clicks on a reportname.... i want the application to open the report.

Currently i have the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
'Dim report As ReportDocument = New ReportDocument
Dim ReportName As String
ReportName = Me.ListView1.SelectedItems(0).Text
report.Load(ConfigurationSettings.AppSettings("DirPath") & ReportName & ".rpt")
report.SetDatabaseLogon("testLogin", "testPassword")

Dim frm As New frmViewer
frm.Show()
End Sub

I rewrote the SP to not use a temp table and all is working well
how exactly was this done?

Thanks..... i hope you solve my problem!

Failed to load database information

I have Crystal Report 9 installed. I created rpt in VS2003 and set database as a dataset. Also, I developed a VS2003 dll to print report.

When I called the dll in VS2005, always got the error as the title: Failed to load database information. Even I made up datasource in dll, no luck. So there must be something wrong while calling 2003 dll from vs2005.

Any idea?

If I add CrystalDecisions.CrystalReport.Engine and CrystalDecisions.Shared in vs2005 project as reference, but the version is 9.2.3300.0. I add some codes to print report:

ReportDocument rpt = new ReportDocument();
rpt.Load(@."D:\VS 2005 Projects\CallPrintCrystalReport\CallPrintCrystalReport\CrystalReport1.rpt");
rpt.SetDataSource(CreateDS());
rpt.PrintToPrinter(1, false, 0, 0);
rpt.Close();

Same error!!! Does this mean CrystalReport 9.2.3300 can not be called by VS2005?Probably not, since CR of VS2005 is based-on version XI.|||Thank you. I just wanna make sure about it.sql

failed to create crystal query engine

Hi,
when trying to run crystal reports from within application the error:
'Crystal.CRPE.Application' Failed to create the Crystal Query Engine. appears.
The full install has been done and is version 8.5
any help appreciatedOpen the report and do verify database
or try it here
http://support.businessobjects.com/

facing problem to export crystal report to PDF which contains some items images

I am facing problem to export crystal report to PDF which contains some item's images.

All images change with first item image. the application developed in Visual Basic 6.0 and MS access.

The images comes to crystal report from physical location not from any database. While i m using default export utility of crystal report.See if you find solution here
support.BusinessObjects.com

Extracting SQL Query from Report (.rpt) in CR for VS.NET

Hi all,
I am new to Crystal report. I have a scenario in which i need to obtain the sql query from a report (.rpt file).
I am using ReportDocument object but it does not contains the property or method that returns the query. It seems that Report Designer (or report itself may be) stores (constructs) the sql query that reflect the report data [e.g. right click on "Database Field" node in Report Designer and select "Show SQL Query", it displays the query for the report.]
Does any body know how to get that query programmatically?

I would appreciate any sort of help.

Thanks,
AsimHi,
For your information...
have a look at:

http://support.businessobjects.com/library/kbase/articles/c2013145.asp

Kind Regards,
Asim

Extracting Last Name Only

I am fairly new to Crystal Reports and need some help extracting a last name from a field.
The field {{Byrname}} contains both first and last name as one text string. How do I extract just the last name?
Any help would be greatly appreciated.
Thanks,
Hanselright('David Tavin',instr('David Tavin',' ')-1)

before posting new thread do check out earlier threads
Thanks