crystal-reports

Search Crystal Reports in Visual Studio and determine whether SQL table/proc is being used

Hello I have a number of crystal reports in my VS2008 project. I am making a change to a couple of my database tables and want to ensure that I make all the necessary changes to the reports. I have done a standard VS search for the specific stored procedure that is being used and it found no results. However, when I went into a report a...

Crystal Reports: New Page

My application prints statements for customers. Naturally, I want each customer's statement to start at the top of a page. How do I make it do that? In the Section Expert, if I check 'new page before' the first group, it wastes a page at the beginning, and if I check 'new page after' the last group, it wastes a page at the end. I don't ...

Minimum & Maximum Values in Crystal Reports 2008 Column

Say I have this column returned in a command for Crystal: deposit_no 123 130 125 124 126 127 128 129 and I need to have this in the report title: Includes deposits between 123 - 130 I've tried a running formula for minimum and maximum and they aren't returning the correct values no matter how I manipulate them. I've tried evalu...

Binding a list property to crystal report

I have a data object that contain fields with many datatypes one of this is dictionary, when I add this object as a datasorce fo a crystal report, the dictinary filed is not added to the field explorer with the crystal report editor. How can I add the properties that are of a list or dictionary types to a crystal report? ...

Replace a database connection for subreports with JRC

Hi Since I'm using a newer release of JRC a replacement of database connection information do not work any more. I've no idea why. This code worked with a JRC version from last autumn (unfortunately I don't have a release number): ReportClientDocument doc = new ReportClientDocument(); doc.open("report.rpt"); IDatabase db = null; // g...

ParameterFieldCurrentValueException when data not saved with a report and exporting to PDF.

I have a report that I created with Crystal Reports 2008. This report uses upwards of 40 parameters to control the layout of the report. All the parameters are boolean and are defaulted to False in the saved report. The report is saved with the save data with the report option unchecked as I want to read the results from the database ...

What reporting platform do you prefer?

Crystal Reports? SQL Server Reporting Services? A 3rd-party tool? ...

Crystal Reports changes text to lower case.

I have text objects on a Crystal Report in Visual Studio with an initial capital. When I print the report, the text is all lower case. And the reason is? ...

Crystal Report 2008 numeric formatting (using C#)

Greetings, I am using Crystal Reports with Visual Studio 2005. I need to display a currency field in the following format: $0.0 (which will be a value in 100,000s). If the value is 0 the field is always displayed as $0 and not $0.0. I have set the decimals settings in the numeric formatting to $1.0 and the rounding setting to 0.1 and n...

Crystal Reports hanging

The company has recently implemented software not written by us. The software uses Crystal Reports and whenever somebody draws a particularly large report and close their browser before the report is finished loading, we cannot draw anymore reports. The only way to fix it is to reset iis which is obviously exceptionally bad practice. An...

Deploying Crystal Reports Basic for Visual Studio 2008

I am developing a chained installer including the .msi installation of Crystal Reports Basic (10.5) using Inno Setup. I cannot find any deployment guidance to determine if this is already installed on the target PC, though it appears I can call the .msi multiple times and it always attempts to install (never goes to the typical repair/r...

Adding a new group in Crystal Reports causes all of my existing groups to disappear

My problem in a nutshell: I create a new report, I insert a number of groups one at a time, and everything goes fine until I add the final group and suddenly I get zero results back for the entire report. I'm new to Crystal Reports, so I'm not even sure I'm using the right vocabulary, and I'm sure this is one of the reasons I'm having ...

Crystal Reports 2008 connection problem

Hi, I have migrated Seagate CrystalReports 8 to Visual Studio CrystalReports 2008. We have used Oracle drivers for CrystalReports 8 provided by the 3rd party vendor. Now we have to use OLEDB for CrystalReports 2008, its throwing errors. Can anyone suggest in this regard. Can any one suggest step by step process for using stored proc...

How to access various databases using OLE DB with minimum installation

Hi, Our reporting tool needs to access the database and get information from it. The tool uses Crystal Reports. The database can be one of SQL Server, Oracle, Sybase and Postgres. Currently, we install the database client with the report tool installation. We would like to avoid this client installation due to licensing issues and user p...

Is running a CrystalReport through a .NET application differs from running it using any CrystalReport Designer?

Hi all. I designed a CrystalReport using CrystalReport Designer that embedded with VisulaStudio.NET 2005, while running the report using report viewer, it runs properly and retrieves the required data. While running it throught the application, no data is retrieved?! Is running a CrystalReport through a .NET application differs from ru...

Error Opening CrystalReport viewer

Hi All, I have this problem which I am trying to debug for a lot of time. The setup is like this: i. The application is a Windows application developed using VS2005, .net 2.0. ii. I use the Cyrstal reports component Crystal Report Viewer and dynamically display various reports in the same form. iii. The db is SQLSERVER Express 2005 ...

Print a 2-column report in .net

How do you create a report with 2 columns: Example: Student Name: Reyes JA Student Name: Reyes K Student ID: 2008-1000 Student ID: 2008-1000 Semester: First Sem, 2008-2009 Semester: First Sem, 2008-2009 Amount: 2000.00 Amount: 2000.00 ...

Accessing crystal reports in an ASP.NET application?

I need to access a Crystal Report that is deployed on a Crystal Report server. I want to display this report on my ASP.NET page. However, I don't want to include the report file in my project. I need to use the report file deployed on crystal report server. Can you please guide me on how to do this? ...

how to find first record from group in crystal reports?

how to find first record from group in crystal reports? ...

How to count group records based on certain values?

Hi guys. I have a report, divided into set of groups, one of them is grouped by "Status". Status values are: S, R, V. I need to make two total fields to get 1- Count of S and V records. 2- Count of R records. Any suggestions? FYI: I use CrystalReport Designer embedded with VisualStudio.NET 2005. ...