Crystal Report 10 – Can not obtain error message from server
When running a Crystal Report(V10) I get the error message ‘Can not obtain error message from server’ My report is running over a Domino database, connecting two views to together with a single join (Left outer join, not enforced). If I run the report I get a different error message ‘Failed to open a rowset’ [...]
Answer Question
| June 22, 2009 10:25 AM
Crystal Reports, Crystal Reports 10, Lotus error messages, Lotus Notes Database
When running a Crystal Report(V10) I get the error message ‘Can not obtain error message from server’ My report is running over a Domino database, connecting two views to together with a single join (Left outer join, not enforced). If I run the report I get a different error message ‘Failed to open a rowset’ [...]
Answer Question
| June 22, 2009 10:25 AM
Crystal Reports, Crystal Reports 10, Lotus error messages, Lotus Notes Database
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 [...]
Answer Question
| June 22, 2009 10:08 AM
Crystal Reports, SQL, SQL Server
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 [...]
Answer Question
| June 22, 2009 10:08 AM
Crystal Reports, SQL, SQL Server
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?
Answer Question
| June 19, 2009 4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries
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?
Answer Question
| June 19, 2009 4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries
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
Answer Question
| May 19, 2011 12:20 PM
Crystal Reports, Crystal Reports 7, Crystal Reports error messages, Crystal Reports Export, Crystal Reports Export to Excel, Microsoft Excel, Microsoft Office, Windows XP
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
Answer Question
| May 19, 2011 12:20 PM
Crystal Reports, Crystal Reports 7, Crystal Reports error messages, Crystal Reports Export, Crystal Reports Export to Excel, Microsoft Excel, Microsoft Office, Windows XP
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 [...]
Answer Question
| June 17, 2009 12:01 PM
Crystal Reports, Crystal Reports migration, IDE, VB.NET 2003, Visual Studio, VS 2003, VS 2008
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 [...]
Answer Question
| June 17, 2009 12:01 PM
Crystal Reports, Crystal Reports migration, IDE, VB.NET 2003, Visual Studio, VS 2003, VS 2008
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
Answer Question
| June 16, 2009 5:00 PM
Crystal Reports, Crystal Reports error messages, Terminal Server
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
Answer Question
| June 16, 2009 5:00 PM
Crystal Reports, Crystal Reports error messages, Terminal Server
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?
Answer Question
| July 19, 2009 12:12 AM
Crystal Reports, Crystal Reports Subreport
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?
Answer Question
| July 19, 2009 12:12 AM
Crystal Reports, Crystal Reports Subreport
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
Answer Question
| June 15, 2009 2:56 PM
Crystal Reports, Crystal Reports Authentication, Crystal Reports XI
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
Answer Question
| June 15, 2009 2:56 PM
Crystal Reports, Crystal Reports Authentication, Crystal Reports XI
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 (U.S.A) [...]
Answer Question
| June 15, 2009 12:59 PM
Crystal Reports, 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 (U.S.A) [...]
Answer Question
| June 15, 2009 12:59 PM
Crystal Reports, Intranet
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 [...]
Answer Question
| November 5, 2011 4:46 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
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 [...]
Answer Question
| November 5, 2011 4:46 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
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 YR < 50 then YR := YR + 2000 [...]
Answer Question
| June 10, 2009 7:29 PM
Crystal Reports, Crystal Reports 11, Crystal Reports Data Conversion, Crystal Reports XI
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 YR < 50 then YR := YR + 2000 [...]
Answer Question
| June 10, 2009 7:29 PM
Crystal Reports, Crystal Reports 11, Crystal Reports Data Conversion, Crystal Reports XI
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
Answer Question
| January 5, 2010 6:34 AM
Crystal Reports, Crystal Reports 11, Crystal Reports XI
how to set fixed number of records in details section in crystal report XI
Answer Question
| January 5, 2010 6:34 AM
Crystal Reports, Crystal Reports 11, Crystal Reports XI
error detected by database DLL
please explain this error message in crystal reports
Answer Question
| October 3, 2010 3:31 PM
Crystal Reports, Crystal Reports Database, DLL
please explain this error message in crystal reports
Answer Question
| October 3, 2010 3:31 PM
Crystal Reports, Crystal Reports Database, DLL
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.
Answer Question
| June 11, 2009 6:00 PM
Crystal Reports, Crystal Reports 11, Crystal Reports to PDF, Crystal Reports XI
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.
Answer Question
| June 11, 2009 6:00 PM
Crystal Reports, Crystal Reports 11, Crystal Reports to PDF, Crystal Reports XI
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.
Answer Question
| June 3, 2009 9:49 PM
Conditional expressions, Crystal Reports, Formula Workshop
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.
Answer Question
| June 3, 2009 9:49 PM
Conditional expressions, Crystal Reports, Formula Workshop
Preview tabs
I have sub reports in my report. How do I get rid of all the numbered preview tabs on my crystal report.
Answer Question
| June 2, 2009 4:12 PM
Crystal Reports, Crystal Reports Preview Tabs, Crystal Reports Subreport
I have sub reports in my report. How do I get rid of all the numbered preview tabs on my crystal report.
Answer Question
| June 2, 2009 4:12 PM
Crystal Reports, Crystal Reports Preview Tabs, Crystal Reports Subreport
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 Crystal [...]
Answer Question
| June 1, 2009 11:02 PM
Crystal Reports, 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 Crystal [...]
Answer Question
| June 1, 2009 11:02 PM
Crystal Reports, Crystal Reports 10
How do you save a template in Crystal Reports 2008?
How do you save a template in Crystal Reports 2008?
Answer Question
| May 30, 2009 1:16 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Templates
How do you save a template in Crystal Reports 2008?
Answer Question
| May 30, 2009 1:16 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Templates
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 sub [...]
Answer Question
| May 28, 2009 3:15 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports Subreport
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 sub [...]
Answer Question
| May 28, 2009 3:15 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports Subreport
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 NumberVar Amount; // 0 [...]
Answer Question
| May 28, 2009 3:00 PM
Crystal Reports, Crystal Reports 10, Crystal Reports 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 NumberVar Amount; // 0 [...]
Answer Question
| May 28, 2009 3:00 PM
Crystal Reports, Crystal Reports 10, Crystal Reports Subreport
