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...
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...
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...
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...
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...
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...
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...
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...
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... ...
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...
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. ...
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...
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! ...
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? ...
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...
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'...
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...
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...
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 ...
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...