crystal-reports

Subreport source in Crystal Reports for .Net

I am using several sub-reports in a Crystal Reports solution in .Net. I created a stand-alone report, then imported that report into several other reports as a sub-report. Changes to the stand-alone version are not incorporated into any of the reports leveraging it. Will I need to continually re-import the report in this manner, or is th...

Why do I get a "Failed to export the report" error when I try to export a Crystal Report to an HTML file?

I'm trying to export a Crystal Report to an HTML file, but when I call the Export method, I immediately get this error: Source: Crystal Reports ActiveX Designer Description: Failed to export the report. I have tried both crEFTHTML40 and crEFTHTML32Standard as export format types - and both result in the same error. Here is a...

How do I export a Crystal Report to a Unicode text file?

I'm trying to export a Crystal Report to a text file, while preserving any Unicode characters that are found within. By default, Crystal Reports seems to export to an ANSI text file. Here is a highly simplified version of what I'm doing: Dim objCRReport As CRAXDRT.Report [...] objCRReport.ExportOptions.FormatType = 8 'crEFTText objCRRe...

How do I send control characters to a Windows printer in Crystal Reports?

We are trying to build a Crystal Report that sends control characters directly to the printer, without going through the (buggy) Windows driver for that printer. Does anyone know a way to do this from within a Crystal Report? The specific control character we are trying to send is CHR(2). However when we put that in a Crystal Report, a...

Dynamically load pictures from file system into Crystal Report (VS 2008 version)

I have a VB.NET application which needs to generate reports (invoices) which contains optional images. The images are going to be loaded into 1 of 6 places on the report, but will reside on the client PC (deployed with the application). I've been trying to access the ICROleObject object, which is what's placed onto the report, but I ca...

Is there a type of report or cross-tab that would display this data elegantly?

I have data in this form, Article ID Company A Company B Company C 1 Featured Mentioned -- 2 Mentioned Featured Mentioned 3 Mentioned -- -- 4 Featured Mentioned Mentioned 5 Mentioned Mentioned Featured I’d like to show, for example, how many times Company B was...

Strange CrystalReportsViewer toolbar behaviour

I have a problem with the CrystalReportsViewer's toolbar that puzzles me. Let's say I have a report that consists of five pages. If I click the next button, I get to page two as expected, but if I press it again, page two reloads! I can click the "last page" button and get to the last page, but if I try to go to the previous page from th...

Is there a way to save or edit Crystal reports in version 8.5 format in Visual Studio 2008?

I have a crystal report file I need make a tiny edit in. It was created in/for Crystal Reports 8.5. I can open it in Visual Studio 2008 but saving the file updates the file version and the report fails with the third part software that reads it (Actinic). I don't know much about Crystal reports. Is there a way I can edit the file witho...

What is the best way to convert a UTC string to a date in Crystal Reports?

Given a UTC time string like this: 2005-11-01T00:00:00-04:00 What is the best way to convert it to a DateTime using a Crystal Reports formula? My best solution is posted below. I hope someone out there can blow me away with a one-liner... ...

Crystal Reports 8.5 grouping

I am grouping using a formula fCity which goes like this If {X.MailingCity} > "" Then {X.MailingCity} Else {X.City} I have two different fields in my view (Home City and Mailing City) Now, these fields contain many rural communities and in my report I want to have these smaller rural communities included with the major city it is locate...

Anyone Know a good tutorial of how Crystal Reports for Visual Studio works?

I am stuck building reports that will be generated by a custom application using the Crystal Reports 9.1.5 that comes with Visual Studio 2003. In addition to the editor being one of the most infuriating things I've ever had to work with I am also constantly hounded by the various gotchas having to do with their code generation engine. ...

Checkbox in a Crystal Report

What is the best way to display a checkbox in a Crystal Report? Example: My report has a box for "Male" and "Female", and one should be checked. My current workaround is to draw a small graphical square, and line it up with a formula which goes like this: if {table.gender} = "M" then "X" else " " This is a poor solution, because ch...

Crystal Reports problem

Hi, I'm having problem in the following line: rd.PrintOptions.PaperSize = PaperSize.PaperFanfoldStdGerman; it throws an exception saying HRESULT: 0x8002000B (DISP_E_BADINDEX)) if I skip this line, the same error eccurs here: rd.PrintOptions.ApplyPageMargins(config) Did anyone have this problem before? thanks! ...

Entity Framework and Crystal Reports

As I understand it, Crystal Reports can use EntityFramework, is the correct? I'd rather use Entity Framework instead using datasets. How would I do this? ...

SQL - Need to find duplicate records but EXCLUDE reversed transactions

I have a table of transactions which will occasionally have duplicate entries. If/When an admin finds these duplicate entries, they will reverse the transactions, therefore creating a negative value (but the original duplicate still remains due to regulatory requirements). I'd like to create a SQL query (and use Crystal Reports) to make...

How to use if then else to build a string in a crystal reports formula

This is Crystal Reports 9 in Visual Studio 2003 by the way Simple question about crystal reports formula syntax: How do I build the formula's result using if then clauses? Specifically I would like something like this: dim val as string val = {table.level} if {table.uom_id} = 5 then val = val & ' feet' else val = val $ ' meters'...

Can I force a display font from inside a formula in Crystal Reports?

I have a report with a lot of formulas that translate the word "TRUE" into an "X" and "FALSE" into a blank space. I use these to put an "X" in a checkbox. Sometimes there is text after my checkbox. To avoid slight shifts to the left and right, I print the "X" and the " " in a fixed width font. It is very tedious to manually set the f...

Crystal Reports exporting to Excel Issue

In a current C# application I do maintenance on, we have upgraded to Visual Studio 2008 from Visual Studio 2003. We have always used the included Crystal Reports that came with Visual Studio. Since the upgrade we have found an issue with our reports when exporting to excel. If the column in the details section is null, then all the res...

Crystal Reports for VS 2008 - "The user function manager DLL (ufmanager.dll) could not be found."

StackOverflow, you're my only hope! I am unfortunate enough to have inherited an ASP.NET 3.5 application roughly 3/4 in development. This project uses Crystal Reports Basic for VS 2008 to generate a PDF file from a data source. Pretty straightforward. Anyway, this project compiles and runs fine on my development machine (VS 2008), but ...

Problem with embedding CrystalViewerControl inside a Custom Web Control

I'm building a Custom Web Control in ASP.NET 2.0 that embeds the CrystalViewerControl inside it. The CrystalViewerControl accepts its ReportSource as a ServerFileReport, that means that my report file I'm trying to view is accessed as a Web service. I successfully render and create the CrystalReportViewer control and the ServerFileRepor...