crystal-reports

Crystal Report deployment error

i have C# program that works with Oracle 11g when it works on my computer all works excellent but when its run on the customer computer - the connection to Oracle work good but when i try to run any Crystal-Report i get this error: Could not load file or assembly CrystalDecisions.windows.forms.version = 10.5.3700.0. culture = neutr...

How to run cleanup code after a call to Crystal Reports ExportToHttpResponse method?

We're having a problem in our ASP.Net application where the Crystal Reports engine leaves garbage .tmp files in the server's Temp folder after generating reports for the users. So we're trying to figure out how to run the .Close() and .Dispose() methods on the Report object, but we're finding that the code never gets run after the expor...

Crystal Reports: Is it possible to sum for more than one column?

I work on an accounting project in .NET. I want to sum all transaction and its opening balances. I use summary but it Allows only one column.. ...

Crystal Report Viewer control isn't loading the images inside the report

Hello everyone I have an ASP.Net (.Net 2.0) application that creates Crystal Reports (version 11.5) and shows them with CrystalReportViewer control. For some reason the control isn't showing the logo image in the header of the report. It renders the following html <img width="320" height="76" alt="Imagem" src="CrystalImageHandler.aspx...

Report Viewer or Gridview/Datalist/Repeater

I want to display data in format Store Name Department1 User1 2 3 5 6 User2 2 3 5 6 User3 2 3 5 6 User4 2 3 5 6 Department2 User1 2 3 5 6 User2 2 3 5 6 User3 2 3 5 6 User4 2 3 5 6 Store Name1 Department1 User1 2 3 5 6 User2 2 3 5 6 User3 2 3 5 6 User4 2 3 5 6 Department2 User1 2 3 5 6 User2 2 3 5 6 User3 2 3 5 6 User4 2 3 5 6 WHich...

Crystal Reports 9 and Sql Server Synonyms??

We use a variety of Schemas in our SQL Server 2005 installations. Crystal Reports works with those properly but I have a third party app that won't render the Crystal Reports that use different Schemas (no clue why). Is it possible to get Crystal to recognize a table that is addressed by a Synonym? If so how? ...

Crystal - How do I specify a specific record value to be displayed(usually first) when there are multiple records

I have a Crystal report that needs to display the data from the first record regardless of the number of records (usually 1 to 13 records). This field is placed at the bottom of the report and without any control it will always display the last record. This field indicates the container number being used for blood transport and the fir...

How can I filter my data in Crystal Reports in C#?

I have text fields where I can enter all my data, and when I click a button print it will directly go into the Crystal Report which is already filtered containing my data. How do I do this? ...

How to filter Crystal Reports in C#?

How can I filter my entered data in one form that contains a text field into the 2nd form that contains the Crystal Reports viewer using C#? ...

Crystal Reports Date Format

Hi, how can I format the day from a date field to print like 1st 2nd 3rd and so on? Thanks ...

How do I correctly align numeric fields in Crystal Reports 2008?

I've got a problem in Crystal Reports that's been bugging me for years, and I wondered if anybody might have a solution. I've got a few fields (data fields and formulae, numeric and string) all aligning to the left in design mode. When I move to preview mode, the numeric fields never line up with the other fields, and they are slightly...

Specifying a default export format for the CrystalReportViewer

Possible Duplicate: How do I make PDF the default export option for a Crystal Report? There appears to have been a change in behaviour between versions of the viewer that have changed the default from PDF to the virtually useless (in our scenario) native Crystal Reports format. Is it possible to specify the default file type ...

How do I get Crystal Reports for Eclipse to notice my new POJO fields?

I have an existing Crystal Reports .rpt that uses POJOs for its data source. I have added some new fields to my POJO. How can I get Crystal Reports for Eclipse to show these new fields in the Field Explorer so I can use them in my .rpt? ...

Getting error while running web application with crystal reports

I am getting error as below Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified ...

Loading images dynamically in Crystalreport.

HI I am running a crystal report from .net application.i am passing parameter name as company and report should display the logo depends on company. how we can load the image dynamically in crystal report.(how to write formula to load the image from specific directory) ...

In crystal report unable to open rowset. Incorrect syntax near...

Failed to load rowset. Incorrect syntax near...this error comes when I run the program. I want to show report in a crystal report. I have many tables linked by key. Anyone can suggest ...

Suppress Crystal Reports section if there are no rows in a datatable

I have a section in a Crystal Report that I want to suppress. I need to suppress it if there are 0 rows in a particular table in the dataset I am using. How would I do this? The Record Number special field provided appears to be an internal count of records in the report, and does not relate to the rows in the underlying data table. I ...

C# create report programatically

I want to create a report, using either Crystal reports or RDLC, doesn't really matter which. I can get all the data sources together as a series of dynamically generated textboxes etc, but how do I add that to a report? Eg I want customer name and all of their ordered items in a report. Now I can get all of the information in an array....

Crystal Report "Logon failed..." Error when trying to navigation to next page

Hi, I have a web-based Crystal Report that loads successfully, but when i try to navigate to the next page using the toolbar at the top of my CrystalReportViewer then i get the following error: "Logon failed. Details: ADO Error Code: 0x Source: Microsoft SQL Native Client Description: Login failed for user 'sa'. SQL State: 28000 Native...

Crystal grouping sum problem

Hi there, I'm trying to do a sum on a group with a total of the sum at the end of the report. Basically in the group header field I need to sum 5 fields to create a total. This is easy with a simple formula that just adds up the fields which I place in the header. I now need to have a grand total at the end of the report. The details s...