crystal-reports

Crystal XI - Can you split or filter a single datasource to create multiple charts?

I have a dataset which has a daily count spanning over several months and I want to create a graph showing the daily counts however I want to have a separate chart for each month. Is this possible to do by isolating each month? For example if I have 2009/1/1 45 2009/1/2 21 2009/1/3 11 2009/1/4 11 2009/2/1 34 2009/2/2 45 2009/2/3 11 200...

Issues exporting an Excel file from Crystal Reports

I am having an issue exporting Crystal Reports into an excel file. I tried both options of exporting the Excel data AND exporting as an excel file. When i export my Crystal Report as an excel file, i cannot sort any of the fields in my excel file. When i export the report as just the excel data, when i open in Excel, the headers are re...

Tips for debugging likely Crystal Reports hang in ASP.NET

Attempting to keep this short: our shipping personnel use a Windows Mobile-enabled barcode scanner to scan the serial numbers of items shipped on customer orders. That data is submitted via asmx web service and a report is automatically printed to a networked printer showing customer info and the details of items shipped. All of this h...

Crystal Reports not included in Visual Studio 2010 – What are the consequences for the introduction of the new VS version?

Yesterday I stumbled over the information that Crystal Reports will no longer be included in Visual Studio 2010. Instead – it will be provided as a free download, but with a separate installation and a separate release date. According to the linked information the release of CR will be later than that of VS. My projects depend in parts o...

VBPrnDlg object incorrectly disabling page selection

I'm changing some crufty old printing code to use the Visual Basic Print Dialog Control to pass printer information to a CrystalReport object. It works great except for one thing - the page selection box is consistently disabled no matter what flags I pass the object. Here is my code: Public Enum PrintDialogFlags NoFlag = 0 Di...

Subreport with query inserted into main report

I have a crystal report with a bunch of parameterized fields that are being filled by code and displayed through CRViewer. I need to add a few sections in here to execute a query to return a dataset and display this in the same report. I am not sure if the best way to do this with a subreport. I am trying to add a subreport and then s...

Images printing in Asp.net Crystal Report

Hello Guys, I'm using crystal report in my MVC application. I wanted to display an image on my CR viewer. The image is generated using a Handler. Example if I want to display an image it would be (http://localhost/imagehandler?imageid=1&width=4). Something like that. When I use that in my Crystal Report the image just doesn't show. ...

Crystal reports sum

Hi, i need the sum of two database fields. i use this formula field : {dbfield1}+{dbfield2} and if dbfield1 and dbfield2 are != from null in database the sum is showing, but if the dbfield1 or dbfield2 are missing(no data) the formula field is not showing. how can i manage this in cr? thank you! ...

CRS - Dynamically change a report locale

I am using CRS (Crystal Reports Server) 2008 v1 and we are viewing reports through a JSP application deployed on the built-in Tomcat server that comes with CRS. I would like to know how to dynamically change the locale of reports through this application (i.e. through Java). The below code seems to work fine for CRS XI but it is not work...

how do I get a Section to grow to fit its content?

I've got a text field in a CR Report that is variable in size and in it's own section. I'd like the section to fit the content of the field and grow if the field grows. The text is in the page footer and needs to print on every page. Currently I've got these set on the Text Object: Keep Object Together, Close Border on Page Break, Can ...

Crystal report with binding source

I am new to crystal reports. I have a form with a binding source bind to the invoice table. I want to generate invoice report when the user selects an invoice record from the datagridview and clicks generate report. What i want is how can i set the report's source to the binding source can i do this using the crystal report generatin...

crystal reports problem

hi i am developing C# application with crystal reports and ADO.Net Dataset and found that the data on reports header and details section are displayed but data on area of report footer is not displayed. I have try by another simple way same project is moved the data on area of report footer to report header and details the same are dis...

Crystal Reports: Using Business Objects xi Datasource

Hello all: I'm a total Crystal Reports/Business Objects newbie... I've been tasked with going through 100 or so Crystal Reports to determine which reports are using an 'embedded' connection string vs. one supplied by the BOXi server. I've installed Crystal Reports and accessed a sampling of the reports, but haven't been able to locate...

Changing size of crystal report print image runtime

I am new to .net application. Here i am generating the crystal report in my application. My problem is that i want to change the size of crystal report print image. How can i customize the size of print image in crystal report.I have used jquery to change the size of print button on run time. I got succesfull in changing the size but whe...

Crystal Reports - Verify Database

I have an issue that's pretty baffling: Main report contains subreport Subreport uses a stored proc with a parameter In the subreport I've set a default value for that parameter In the main report, I've created a Formula Field with the value I'd like to pass to the subreport, and thus, the stored procedure, and linked it to the subrepo...

Exporting multiple page headers in crystal reports (in visual studio) to Excel

I'm having a heck of a time trying to manipulate my reports so that when i do a data-only excel dump, excel can recognize page headers. I was wondering two things. 1.) Is there any way to change excel export options in Visual Studio? I know you can do this with Crystal Reports standalone...but unfortunately my project requires the us...

Crystal Report on C#

Well I have a Cyrstal report which has 4 sub reports on and it is linked through an ItemID column and a Culture, so it has a parameter value "?Pm-ItemID" and "?Pm-Culture" now i'm using DataSet to load the data to the Crystal Report's datasource, when I run the report its giving me an error which was an asking parameter field was not sup...

Crystal Reports: Inverted type when printing on certain printers

I inherited a .NET project with Crystal Reports which I upgraded from VS2005 to VS2008. Suddenly, some of the labels are inverting (ie. white text on black 'highlighting'). This is only on one printer. The rest of the printers print normally. Is there a setting on the VS2008 CR designer that I'm missing (that only the one printer picks ...

Crystal Reports Sub-report not displaying data

I currently have a crystal report that I'm generating in Visual Studio 2008 which has a sub-report. I've linked the sub-report parameters and when I run the report from the report previewer within visual studio, it runs fine. HOWEVER When I deploy the report to my production server, the report runs and the main report has data, but the...

How to display pretty fractions in Crystal Reports generated PDF

I'm exporting a report to PDF using Crystal Reports bundled with VS2008. I need to display non-standard fractions so that they look nice instead of just something like 26/32. I have turned html interpretation on for the field so &frac12; and other standard html fraction entities display nicely, however, because CR does not understand <s...