crystal-reports

Is there a way to sort by more than one field in Crystal Reports?

I'm using Crystal Report with VB.NET in Visual Studio 2005. I have report that works if I pass in a list of List(Of Stuff). I had been sorting the report by one of the members of Stuff but a need now to sort first by one member, like Stuff.StatusCode and then by another member, like Stuff.ItemNumber. Can I do this just be having more ...

Creating a Non-Databound Report in Winforms

I am using Visual Studio 2008 and all the components that come with it as well as Infragisitics for Winforms. I need to design a label that will print to a label printer. None of the controls are databound and will most likely be set in code eg/Label.Text = "My Heading"; as there will be minimal information on the label. One piece of...

Crystal Reports -- displaying one decimal in my formula field

Hello I have the following in my formula field: toText(((Sum ({DataTable1.Ending_Value}, {DataTable1.Name})) - (Sum ({DataTable1.Starting_Value}, {DataTable1.Name})) - (Sum ({DataTable1.Investments}, {DataTable1.Name})) + (Sum ({DataTable1.Proceeds}, {DataTable1.Name})) + (Sum ({DataTable1.Interest_and_Dividends}, {DataTable1.Name})))/...

Report with WPF and EF in VS 2010

I need to quickly build a report. In VS 2010 when I'm adding new item in the 'Reporting' brach there are 3 items: Report Wizard; Report; and Crystal Report I tried to play with the first one - couldn't find a way to get the data through existing entity model. Also I stupidly confused what's the real difference between 'Report' ...

crystal reports sticky problem

hi I have a project with following sql table companymaster expbill invcarat companyId companyid companyId name invno invno address ...

Error opening crystal report in excel format

We have an application written in VB.NET 2003 which has built in Crystal reports. When we install the application on Windows 2008 server we get the following error while trying to open crystal report in excel format Error is : Error in File :"....rpt" Error detected by export DLL. The report opens up fine in PDF on server Opeing repor...

How to suppress a group header based on running-count results?

HELP!!! THIS IS AN URGENT REQUEST!! Hi I'm trying to suppress a group header when there are no detailed results in another following group. I have added a manual running count total which is showing correct numbers (such as 0 when no records show on the report). I've taken this approach since I have various items suppressed within th...

Crystal report loop

I have a running total and would like to stop it when a condition is matched. Eg: I have STOCK qty 100pcs; qty is accumulated from Purchase Order Receiving transactions as below: No. Qty Accumulate 1. 20 20 2. 30 50 3. 10 60 4. 40 100 5. 20 120 The ru...

multi crystal report 9.0 in asp.net 3.5

Hi, I might be asking a very basic question and I am sorry for that. I have a web application which is sort of a reporting portal. I have a ReportViewer.aspx page which has the crystalreportviewer control on it, and i am using the same viewer to show different reports. The reports are made by someone else altogther so i just have a .rp...

Diagonal group label in Crystal Report Chart

Hi! I designed a crystal report with Microsoft Visual Studio 2008 SP1 and Crystal Report Basic for Visual Studio 2008, which has a chart. How can I make group label in this report, diagonal? here is the screen shot of my report which group labels are horizontal.(Value1, Value2, ...) Thank you. ...

problems deploying crystal reports with a asp.net website

I have a asp.net website which I have publish and it contains some crystal reports files . I get an error that say something about crystalReportImageHandler. How do I deploy this website If it were a web project I know I can use the crystalreport msm when I am creating a setup project But a website I don't know how. ...

Viewing Crystal Reports other than through custom developed webform or winform apps

At work we currently have a custom in-house built winforms app for the business users to view reports. It has role-based security and several administrator functions. My boss is thinking about getting me to port this app to webforms. My question is, are there options other than custom built winforms and webforms apps for deploying/view...

CR error the group section cannot be printed because its condition field is nonexistent or invalid.

Hello I have inherited a CR report and when running i get error: "the group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field." Is there a way for me to know what field is it refering to? Any pointers on when should i start to look for the problem? I ha...

Binding object with List<> to Crystal Report

I have a class that contains a few properties including one that is a List<> of children objects. Simple Example: public class LineItem { public string Name { get; set; } public decimal Amount { get; set; } } public class Invoice { public string Name { get; set; } public DateTime Created...

Crystal reports - Encoding Issue UTF-8 / iso-8559-1

Has anyone had this error before when running reports in Crystal Reports 2008: Character set encoding from transport information [UTF-8] does not match with character set encoding in the received SOAP message [iso-8559]. I presume this indicates a file needs changing, but trying to find it is causing me a real headache. There are r...

Problem using VB6 and Crystal Reports

HEllo, i have a small problem: i have a Crystal 8,5 Report in a VB 6 application. About 2 days ago, all worked like a charm. Since this morning, whenever i press View REport, it shows on screen but the PRINT BUTTON is disabled, meaning has visible=false. I cant see it so i can print the report. I searched the net like a maniac and st...

I am using mysql stored-procedure.My SP return dataset ,how to bind the value into crystal report

I am using mysql stored-procedure.My SP return dataset ,how to bind the value into my crystal report. ...

Errors with large data sources

I'm doing some benchmarking on large data sources and binding/exporting data for reporting. I started with using a data set, filling it with 100000 rows and then attempting to open a crystal report with the retrieved data. I noticed that the data set filled just fine (took about 779 milliseconds) however, when attempting to export the ...

How can I filter a report with duplicate fields in related records?

I have a report where I need to filter out records where there is a duplicate contract number within the same station but a different date. It is not considered a duplicate value becuase of the different date. I then need to summarize the costs and count the contracts but even if i suppress the "duplicate fields" it will summarize the va...

How does Crystal Reports Runtime Licensing work?

I am designing an application in C# and I want to use some Crystal Reports in my application. I am selling this application as freelance to a small business. This is my first program that I have ever sold. I have Crystal Reports 2008 that I am using to design reports with. Do I need to get any kind of licensing from Business Objects to i...