Hi All, I'm currently using CR 2008 for design and running my reports in InfoView. I have a fairly standard report with about 6 groupings and 2 details sections. The groupings are all hierarchichal and can be drilled into. The report contains 5 parameters that the user has access to edit in Infoview. My problem occurs only when users c...
I am using a crystal reports through crystal report viewer server side control in a webform. I am using a webform because the crystal report viewer provides an easy way to export to PDF and to Excel. My problem is that when I deploy to the server, the crystal report .rpt file does not get copied to the target folder. My solution struc...
Crystal Reports in Visual Studio 2008 with C# Normally Data from single column comes like Column1 val1 val2 val3 val4 val5 val6 val7 val8 BUT,I want to show data from my Single column in following format: Column1 val1 val2 val3 val4 val5 val6 val7 val8 val9 val9 val10 ...
Being new to Crystal Reports 11, I’m struggling to find the reason why one particular report inserts rogue carriage returns when outputted as a .txt file. The report needs to present itself as one customer per line, but at random, some customer lines have carriage returns inserted half way through the line therefore spreading the informa...
I'm trying to translate this Crystal Reports IF Statement for use in a WHERE clause - {@receipt_datetime_daylight} in {?DateRange} and (if {?Call Sign} = "All Call Signs" Then {cacs_incident_task.resource_or_class_id} = {cacs_incident_task.resource_or_class_id} Else If {?Call Sign} = "All Sierra Call Signs" Then {cacs_incident_t...
Assume i have a custom Windows application written in C#. This application has only the following functionalists, add, edit, delete and view. For example, a user can add a sale, change sales record, delete a sale record or view the whole sales record. I need to add some reporting functionalists e.g. i want a user to print the sales of a...
Hello, I am trying to make a connection to JDBC(JNDI) in Crystal Reports and I get the following error : Invalid Argument provided. Details: Java Server startup failure. Please verify the PATH (JDK), CLASSPATH and IORFileLocation properties in the CRConfig.xml file. In addition, please verify you are using JDK 1.4. I am using th...
i have a formula field named @prodValue: {#TotalStock} * {spRptStockDetails;1.purDetRate} It is in the group head 2 section and i want to get the sum of this field in the Group head 1 footer. how to do this. sum({@prodValue}) it is not working. ...
Hello, I am bit confusing in generating crystal report from linq-to-sql object in my WpfApplication. crystalreport1 rpt = new crystalreport1(); datacontextclass1 db = new datacontextclass1(); var q = (from records in db.emp select records).toList(); rpt.setDataSource(q); crystalviewer.reportsource(rpt); I have done above steps... b...
I am developing a WPF application, and I need your advice. I have to generate reports in my application. What should I use, Crystal Reports or SQL Server Reporting Services? Which one is better, and why? ...
Hi, I have a crystal report in which i have two subreports. Each subreport is having a group expert for the grouping. While I run the report it give me 15 pages but only 1 page is expected to come. All 15 pages are same. The first page is repeating for 14 time. Can any one please help me out. Thanks in advance! Ritesh ...
Hi I am using Crystal Reports 10 with IIS Server. I wish to display some of the reports in Portuguese language. How can I configure Crystal Reports to display data in Portuguese ? I guess I will need to download a language pack for this but will it allow word-by-word conversion from English to Portuguese ? Grammatically correct sentences...
Hi I am using Crystal Reports 10 to generate my reports. In one of the reports I see that a group header is getting repeated 2 times in the output document while in the design tab I can that it is present only one time. I am having my query as a "Union All" of 2 data sets. Please advise what could be the cause. Thanks. ...
I am using Crystal Viewer in a C# windows application. When I try to print the report using PrintReport() method, the print dialog opens after a long time (near about 45 minutes). How to fix it? Is there any other way to print the report? ...
I have a VB6 application using Crystal Reports XI. After almost two years suddenly I cannot set RecordSelectionFormula anymore. The error message says, that Basic syntax is not allowed in record selection formula. The formula is {article.id} = 1234. I've tripple checked that formula. It works fine in the Crystal Reports designer, bu...
I am using an Intermec PF8t for label printing. My labels are the size of 40mm(width) and 20mm (height) and they are rendered in a crystal report from where I print them dynamically. The problem is that no matter what the page orientation I specify either in crystal report or in printer settings, the result is printed vertically(i.e. my ...
Hi, ive been dealing with a kind of no error message my application is throwing after the setup has been installed on my machine. The application run fine and generate a report exactly the way i want it. The problem is that after compiling it as set up, it throw this message: System.Runtime.InteropServices.COMException (0x80000000); No...
We have a .NET Winforms application that hosts the Crystal Reports Viewer control (Version XI). It works well for the most part but when an export of data from the viewer is performed the application will crash on exit and in unmanaged code. The error message is not very useful and just says that an incorrect memory location was accessed...
I have a report designed in Crystal 2008. The report has a parameter field called "Member ID" that I want to use to get a string input from the user running the report. However, I want to do some sort of validation to ensure that the ID they entered is valid (it exists in a database table that I already have set up). Is there any way to ...
Hello! I was wondering if there was a way in Crystal to do the following: If a field has a character limit of 10 characters...and the data fed in has 11 characters, instead of showing truncated data, i'd like it to show ** . Excel has a function like this where if a column is too narrow for a field to show completely, it shows ###### ...