crystal-reports

Is there some way of recycling a Crystal Reports dataset?

I'm trying to write a Crystal Report which has totals grouped in a different way to the main report. The only way I've been able to do this so far is to use a subreport for the totals, but it means having to hit the data source again to retrieve the same data, which seems like nonsense. Here's a simplified example: date name ...

.NET 3.5 SP1 and aspnet_client Crystal Reports

I recently (a few days ago) installed .NET 3.5 SP1 and subsequently an aspnet_client folder with a bunch of Crystal Reports support code has been injected into my .net web apps. Anybody else experienced this? Am I correct in saying that this is a side effect of SP1? What is this? ...

Easy way for Crystal Reports to MS SQL Server Reporting Services conversion

Is there a way to easily convert Crystal Reports reports to Reporting Services RDL format? We have quite a few reports that will be needing conversion soon. I know about the manual process (which is basically rebuilding all your reports from scratch in SSRS), but my searches pointed to a few possibilities with automatic conversion "acc...

What's the best way of diffing Crystal Reports?

If you have two versions of the same report (.rpt) and you want to establish what the exact differences are, what is the best way to go about this? I've seen some commercial tools to do this, but I'm not too interested in forking out cash for something that should be relatively straight forward. Can I hook into the Crystal API and simply...

Broken chart images in Crystal Reports in web application

I hve a collection of crystal reports that contain charts. The look fine locally and when printed, but when viewing them through a web application using a CrystalReportViewer the charts dispay as broken images. Viewing the properties of the broken image show the url as "...CrystalImageHandler.aspx?dynamicimage=crtmpimage_8d12a01f-b336-...

Summary fields in Crystal Report VS2008

I need to have a summary field in each page of the report and en page 2 and forward de same summary has to appear at the top of the page. Anyone know how to do this? Ex: > > Page 1 > > Name Value > a 1 > b 3 > Total 4 > > Page 2 > Name Value > Total Before 4 > c 5 > d 1 > T...

"File Save Failed" error when working with Crystal Reports in VS2008

Occasionally while attempting to save a Crystal Report that I'm working on in VS2008, a dialog titled "File Save Failed" pops up saying "The document could not be saved in C:\Users\Phillip\AppData\Local\Temp{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.rpt. It has been saved in C:\Users\Phillip\AppData\Local\Temp\~zzz{YYYYYYYY-YYYY-YYYY-YYYY-Y...

How to handle variable width FieldObjects in Crystal Reports

I have a Crystal Report which is viewed via a CrystalReportViewer control on an .aspx page (using VS2008). The report has two data-driven FieldObjects (which can contain a variable number of chars) which I would like to display on the same line beside each other. Problem is when the text in the first FieldObject is too long it over...

Is it okay to have a lot of database views?

I infrequently (monthly/quarterly) generate hundreds of Crystal Reports reports using Microsoft SQL Server 2005 database views. Are those views wasting CPU cycles and RAM during all the time that I am not reading from them? Should I instead use stored procedures, temporary tables, or short-lived normal tables since I rarely read from m...

Replace a database connection for report and all subreports

Is there is any way to change the datasource location for a report and all of it's subreports without having to open each of them manually? ...

XML dataset in Crystal Reports

I am trying to print a report from within an InfoPath template. So my dataset is an XML DOM that I will load into the Crystal Report at runtime. But how do I define the dataset off which the Crystal Report is developed? Crystal Reports has a great tool to build a dataset from an SQL database. Is there something similar for XML schema t...

Using MySQL on Visual Studio 2008

I am using the ODBC connector to access a MySQL db from visual studio 2008 and i am facing performance problems when dealing with crystal reports and to solve this i need a native connector to visual studio. if someone has had a similar problem and knows a solution or tools ( freeware preferable ) , i would be really grateful. ...

Crystal Report icons/toolbar not working when deployed on web server

I have built a web page which contains a Crystal Report built using the Crystal libraries included in Visual Studio 2008. It 'works on my machine' but when deployed to the web server the icons (Export, Print etc) on the Crystal Report toolbar do not display or work. Just seeing the 'red X' where the button image should be and clickin...

Crystal Reports 2008 InprocServer + TempDir = "Operation not yet implemented"

I have a .NET web app that uses CR 2008 for reports. The server it's deployed on is saddled with McAfee, and we want to tell CR to use a temp directory other than the Windows temp dir. Google found me the following registry key: SOFTWARE\Business Objects\Suite 12.0\Report Application Server\InprocServer\TempDir. Adding this key does ...

How do I query the CrystalReports CMS database?

Is it possible to query the Crystal CMS database and get meaningful data back? The data appears to be encrypted. I am running Business Objects Crystal Report Server version 11.5 ...

How do you detect and print the current drilldown in the CrystalReportViewer control?

When using Business Objects' CrystalReportViewer control, how can you detect and manually print the report the user has currently drilled into? You can print this automatically using the Print() method of the CrystalReportViewer, but I want to be able to do a manual printing of this report. It is possible to print the main ReportSource ...

VB.NET 2005 problems with Designer not being able to process a code line.

Hi, I have a problem in my project with the .designer which as everyone know is autogenerated and I ahvent changed at all. One day I was working fine, I did a back up and next day boom! the project suddenly stops working and sends a message that the designer cant procees a code line... and due to this I get more errores (2 in my case), I...

Crystal Reports and LINQ

Has anyone figured out how to use Crystal Reports with Linq to SQL? ...

Merge Modules for Crystal Reports 2008 - Needs a Keycode?

I've not been able to find any information on this, but is a keycode required to be embedded in the CR2008 merge modules for a .NET distribution? They used to require this (which had to be done using ORCA), but I've not found any information on this for CR2008. ...

VB6 / Crystal Report 8.5 error: A string is required here

I recently inherited an old visual basic 6/ crystal reports project which connects to a sql server database. The error message I get (Error# -2147191803 A String is required here) when I attempt to run the project seems to be narrowed down to the .Printout command in the following code: 'Login to database Set Tables ...