Crystal Reports

Crystal Reports Duplicating Records

Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

pasting a database query into crystal

I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

Crystal Reports file error: data may have been lost

using CR7 xp sp 3 office sp 3 when I do a export from CR7 to excel I receive the following message file error data may have been lost

Crystal Reports migration issue

I have report created with CR basic for VS .NET 2003. Some time ago i have to put this report to project crearted in VS 2008. IDE automaticly converted the report to the newest version of CR. Report include one subreport. When this report is printed from .NET 2003 project it looks fine. When i...

Crystal Reports ERROR

Does anyone know what causes this error and/or how to research and resolve the root cause? The remote session was disconnected because there are no Terminal Server License Servers available to provide a license

Inserting Subreport Problem

When I insert my third subreport into my main report I get a message "Performing this action will cause all open subreports to be closed" Why can't I insert my remaining sub report?

Crystal Report XI authentication

Please help on implementing the authentication feature to open the Crystal report XI. Every time user opens the report it should prompt for user name and password

Old Crystal Reports display after uploading new reports to intranet

Dear All, We are using crystal reports at our office for reporting purpose. The issue is we are uploading the reports from our local p.c (India) to our intranet server and still it displays old reports on the intranet server and the new reports are not uploading. We do have a diiferent shared p.c...

Running Crystal Reports with a SQL Server Login instead of a Network Login

I'm trying to run a Crystal Report using Crystal Runtime but I'm getting a "Logon Failed. Details: [Database Vendor Code: 18456]" After running a SQL Trace, I think I have found why. It appears as though it depends on how the user is logged on to the network as to whether or not they are able to...

How to convert number to words in Crystal Reports

I want to convert number to word in crystal report formula fields. Suppose the amount is 35500 It should show like three lakhs fifty five thousand only.

Date Conversion In Crystal Reports 11

I have a datafield {artrans.invdte} thats is a string lenght of 8 formated "MM/DD/YY" trying to check this date against ToText(currentdate, "MM/DD/YY") to select records not working . Tried a pramater field @date StringVar DT := {artrans.invdte}; NumberVar YR := Val (Split (DT , '/')[3]); if...

How to set fixed number of records in details section in Crystal Reports XI

how to set fixed number of records in details section in crystal report XI

error detected by database DLL

please explain this error message in crystal reports

Font problems when exporting the crystal reports into pdf

I usedArial Fonts in Crystal Report.When i export the report into PDF format, some of the Characters in the report contents are displayed like chinese. Please help.

Leak rate trigger

If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

Preview tabs

I have sub reports in my report. How do I get rid of all the numbered preview tabs on my crystal report.

Duplicate values in different columns in Crystal Reports 10

-------------------- ID COL1 COL2 001 1000 7777 002 9999 7777 003 7777 3000 004 9999 4000 005 6000 9999 006 1000 1000 -------------------- I need to use Crystal Reports to make a group which have the rows that have duplicates BOTH in COL1 and COL2. Could you show me how to create GROUP(s) in...

How do you save a template in Crystal Reports 2008?

How do you save a template in Crystal Reports 2008?

When subreports, details and formulas are executed?

I have a formula in the Detail B section called @Status. This formula gets the job status code for each job being displayed in the detail B line, using shared variables. These shared variables get their data from various subreports which are in the Detail A section. It is grouping on Due dates with...

subreport

I have a report in crystal ver.10 with tree subreport to calculated the misc.charge i use the case stament but now the database change the value in some case positive number and negative number the negative number display only when is a intercompany sales order. here is the original code Local...