crystal-reports

Crystal Reports Error-Subscript out of range

I have deployed an application which uses crystal reports(8.0) runtime. The runtime files register fine during installation. However when I try to view a report on screen from the application I get the crystal Reports Error-'Subscript out of range'. The report however displays after the error message. This has never happened before despi...

Could not load CrystalDecisions.ReportAppServer.ClientDoc

Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. Hey everyone, I just deployed our web app to a new server that uses the Crystal Report viewer in several reports in...

Comparison between Crystal Report and RAQ Report

I'm searching for a reporting tool. I heard that RAQ Report is a free reporting tool. But I haven't used it. Who are using it? Is it useful? What is the difference between Crystal Report and RAQ Report? ...

How can I disable Parameter Prompt at run time in Crystal Report XI?

How can I disable Parameter Prompt in sub report at run time in Crystal Report XI? I used Ms VS 2005 and report also included. Other report features is the same Crystal Report features. Other report not show prompt at run time which are not included Sub report. Prompt appeared one is included sub report. so you may hv any suggestion. let...

Find instance of a formula on a report when it's been hidden

It's common practise in Crystal Reports to use a formula on a report that carries out some background logic. But to prevent it displaying, you have to hide the field. Question is, how do you find it again several years later when you've forgotten where it was? I've got a reference to a formula called @AddressedCount but I can't find wher...

Getting Crystal to properly embed TT fonts in a PDF

Has anyone run into problems getting Crystal XI to embed fonts when displaying reports via the web (served by RAS) and then exporting to PDF? We have a barcode font that we use in a few reports, and it worked fine via the web viewer and when exporting to PDF. When we moved our reporting server from a 2000 box to a 2003 box, the font is...

How to change schema name in Crystal report 11?

The report is being designed in Crystal Reports XI. It uses an ODBC connection to an Oracle database using the CR Oracle ODBC driver 4.1. I need this report to be easily distributed across 14 sites that use the same ODBC DSN, but the database at each site has a different owner and/or schema name. I followed Business Objects instructions...

Crystal report xi + c#.net document load problem

I have a crystal report which gives me undefined error when opening document, does any one come across this type of error, below is the coding: public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ///create instance of class first ReportDocument rpDoc = new...

Crystal Reports in a PDF file?

Guys, I am using the following code to output a Crystal Report to an ASP.NET application: Dim rptDocument As New ReportDocument Dim rptPath As String = Server.MapPath("Reports/Employees.rpt") rptDocument.Load(rptPath) Me.CrystalReportViewer1.ReportSource = rptDocument Everything is working fine. My question is, is there a way to ren...

How to hide the last record for each person?

Using crystal report 9 Example PersonID Date 3405 28-02-2009 3405 29-02-2009 3406 25-02-2009 3406 30-02-2009 So on…, I want to hide the last record for each personid Expected Output 3405 28-02-2009 3406 25-02-2009 So on…, How to write a formula for this condition? ...

Client and Server Side...

What is Client-Side reporting? What is Server-Side Reporting? How can I achieve those through Crystal Report? ...

Does CrystalReports have diagnostic logging? Certain fields won't show up when printed

I am using the Crystal Reports that comes with Visual Studio 2008 Here is my problem. I have a simple little command line utility that generates a single crystal report. It Connects to a database Gets a dataset out of a stored procedure. The dataset is always one table with one row. Sets the dataset as the report's DataSource Dep...

How to assign Custom class as datasource in crystal report

Hi, I created crystal report and through Data-->object i generated the DataSource and i added the fields from generated Datasource. My problem is, how to assign the values to the datasource. Is anything like grid.DataSource = MyCustomClass is available. I can't access the Database directly [its a remove service]. What is the way to as...

Supressing section in Crystal Reports with subreport

I am trying to create a report in crystal reports 11 based on this sql query SELECT *     FROM (table) OM, (table) OL, (table) C     WHERE OM.ORDER = OL.ORDER     AND OM.COMPANY = C.COMPANY     AND (EXISTS (SELECT *             FROM (table) OSD, (table) OSDD             WHERE OSD.ORDER = OL.ORDER             AND OSD.LINE = ...

How to filter a number field against a multiple string parameter or string array?

We have a Crystal Report that lets the user pick which of several fields to filter against. In the record selection formula, we have code like the following: if {?First Selection Type} = "CUSTOMER CODE" then {foo.CustCode} in {?First Selection Value} else if {?First Selection Type} = "ORDER" then {bar.OrderNum} in {?First Selection Va...

Sharepoint List to PDF report

I have a sharepoint list and I needto transform it into a document(any type) and export it pdf. Would you have any tips on the best way to do this? I have crystal reports but not sure if this is the correct use case for this. ...

What are the advantages/disadvantages of using OLE Objects?

Hello, This is the scenario for asking this question: I'm doing some Proof of Concepts with Crystal Reports, and noticed that images are added as OLE objects. I'm pretty sure this is a downside against other reporting tools like ActiveReports or XtraReports that uses other means to do the same. Let me know if I didn't state the proble...

How to avoid the duplicate values?

Using Crystal Report 8.5 Example Personid Date 3100 22-02-2009 3100 22-02-2009 3100 22-02-2009 3200 22-02-2009 3200 22-02-2009 3200 22-02-2009 3200 22-02-2009 3100 23-02-2009 3100 23-02-2009 3100 23-02-2009 3100 23-02-2009 3200 23-02-2009 3200 23-02-2009 3200 23-02-2009 3200 23-02-2009 So on…, Expecete...

Set font style to formula field

Hi All, I have a problem with crystal report 10. I have one formula field in the detail of crystal report. And I want to set font style in this formula field but I don't how to set it after I check the condition. So please help to solve this problem! Thanks, Ung Sopolin ...

Grabing a number from a non-number string.

I need to get the number from a non-numeric sting so that i can us it in a formula to be able to show unit price for example 4 of x = 1,000.00. I need to grab that number 4 out of the text and use it in the simple formula to show that the unit price of each is 250.00. Any suggestions please? ...