Record Selection in Crystal Report 2008
I have a Crystal report 2008 that selects records from dynamic prompt based on Client field with status “Approved”. When i select records that i know have a staus of “Approved” I see all of the records, but if I select records from dynamic prompt that dont have a status “Approved” some other status like [...]
Answer Question
| February 23, 2011 7:32 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Record Selection
I have a Crystal report 2008 that selects records from dynamic prompt based on Client field with status “Approved”. When i select records that i know have a staus of “Approved” I see all of the records, but if I select records from dynamic prompt that dont have a status “Approved” some other status like [...]
Answer Question
| February 23, 2011 7:32 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Record Selection
Crystal Reports XI period in database name
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?
Answer Question
| January 13, 2012 12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
Filtering Dates in Crystal Reports
Is there a way to get Crystal to filter dates showing the next 5 or 7 days? I know about filtering using “in the period” but none of those options are for future dates, except like next 30 or 60 days, but I don’t want to see all of that.
Answer Question
| March 11, 2011 9:10 PM
Crystal Reports, Crystal Reports Filter Formula, Crystal Reports Filtering
Is there a way to get Crystal to filter dates showing the next 5 or 7 days? I know about filtering using “in the period” but none of those options are for future dates, except like next 30 or 60 days, but I don’t want to see all of that.
Answer Question
| March 11, 2011 9:10 PM
Crystal Reports, Crystal Reports Filter Formula, Crystal Reports Filtering
Crystal report asks for parameter at runtime
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Hello All, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens….. My Report also contains [...]
Answer Question
| August 12, 2011 10:22 AM
.NET, C#, Crystal Report, Crystal Reports, Crystal Reports Conditional Parameters, SQL Server 2005
Crystal Report error
What does this error in crystal report mean “This fieldname is not known”
Answer Question
| January 6, 2011 4:40 AM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors, Visual Studio 2010
What does this error in crystal report mean “This fieldname is not known”
Answer Question
| January 6, 2011 4:40 AM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors, Visual Studio 2010
How to execute Crystal Reports subreports on priority base
Hi I’d created two sub reports(x,y) which uses different queries. In main report i have to call ‘x’ report first because i have to pass the grand tot from ‘x’ report to ‘y’. How ever my two reports are calling at a time so that ‘y’ report getting wrong result because it is calling before [...]
Answer Question
| December 28, 2010 5:07 PM
Crystal Reports, Crystal Reports Subreports, Crystal XI, Oracle
Hi I’d created two sub reports(x,y) which uses different queries. In main report i have to call ‘x’ report first because i have to pass the grand tot from ‘x’ report to ‘y’. How ever my two reports are calling at a time so that ‘y’ report getting wrong result because it is calling before [...]
Answer Question
| December 28, 2010 5:07 PM
Crystal Reports, Crystal Reports Subreports, Crystal XI, Oracle
Crystal Reports 2008 Error Failed to retrieve data from the database. TABLE space exhausted
won’t display over 300+ pages at one time, get this error message: Failed to retrieve data from the database. Details: HY000:[ODBCLINK Host]
Answer Question
| December 13, 2010 9:45 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Database, Crystal Reports error messages, Crystal Reports Errors
won’t display over 300+ pages at one time, get this error message: Failed to retrieve data from the database. Details: HY000:[ODBCLINK Host]
Answer Question
| December 13, 2010 9:45 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Database, Crystal Reports error messages, Crystal Reports Errors
Crystal Reports 8.5 and Oracle 9i
Hi Brothers and lovers, I’ve tried in designing the crystal report.while designing,i used multiple columns to view the records.Here i’ve a problem in designing.the problem is , i selected the down the across in the layout of details section in the crystal report 8.5.Through this i can’t control the record to next column before [...]
Answer Question
| December 11, 2010 3:59 PM
Crystal Reports, Crystal Reports 8.5, Oracle 9i
Hi Brothers and lovers, I’ve tried in designing the crystal report.while designing,i used multiple columns to view the records.Here i’ve a problem in designing.the problem is , i selected the down the across in the layout of details section in the crystal report 8.5.Through this i can’t control the record to next column before [...]
Answer Question
| December 11, 2010 3:59 PM
Crystal Reports, Crystal Reports 8.5, Oracle 9i
Sort Crystal Reports detail data once to process then again to display
I have a report in which I have to sort the details in a specific way in order to calculate summaries but for display purposes I want to sort in a different order. Is this possible in Crystal XI
Answer Question
| December 6, 2010 2:59 PM
Crystal Reports, Crystal Reports Conditional Formatting, Crystal Reports XI
I have a report in which I have to sort the details in a specific way in order to calculate summaries but for display purposes I want to sort in a different order. Is this possible in Crystal XI
Answer Question
| December 6, 2010 2:59 PM
Crystal Reports, Crystal Reports Conditional Formatting, Crystal Reports XI
Does Crystal Reports 10 have ActiveX capabilities?
does crystal reports software version 10 have activex capabilities?
Answer Question
| November 29, 2010 2:11 PM
ActiveX, Crystal Reports, Crystal Reports 10
does crystal reports software version 10 have activex capabilities?
Answer Question
| November 29, 2010 2:11 PM
ActiveX, Crystal Reports, Crystal Reports 10
Unhandled win32 exception occurred in crw32.exe
When running the Standard Report Wizard, I get “An unhandled win32 exception occurred in crw32.exe[1904]“. The bracketed number may change, but the error continues and terminates the program. I do not have DEP turned on. I do have third party software (Echo Database) that uses Crystal Reports. Once I got the report open and the [...]
Answer Question
| November 24, 2010 10:54 PM
Crystal Reports, DEP, Win32, Windows XP, Windows XP Error Messages
When running the Standard Report Wizard, I get “An unhandled win32 exception occurred in crw32.exe[1904]“. The bracketed number may change, but the error continues and terminates the program. I do not have DEP turned on. I do have third party software (Echo Database) that uses Crystal Reports. Once I got the report open and the [...]
Answer Question
| November 24, 2010 10:54 PM
Crystal Reports, DEP, Win32, Windows XP, Windows XP Error Messages
Crystal report 9 formula issue
I have a crystal report using two Lawson OLEDB queries, with employee.employee and supervisor.employee. Please let me know how can I write a formula which shows the employee which is listed in the report is a supervisor or not. The report does not shows the supervisor.employee field.
Answer Question
| November 17, 2010 2:21 PM
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB
I have a crystal report using two Lawson OLEDB queries, with employee.employee and supervisor.employee. Please let me know how can I write a formula which shows the employee which is listed in the report is a supervisor or not. The report does not shows the supervisor.employee field.
Answer Question
| November 17, 2010 2:21 PM
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB
Why aren’t the Crystal Reports indexes showing since loading V6R1?
I use Crystal reports via ODBC to the iSeries and have for years. After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to. The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]
Answer Question
| November 8, 2010 6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1
I use Crystal reports via ODBC to the iSeries and have for years. After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to. The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]
Answer Question
| November 8, 2010 6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1
Crystal Reports 2008 Error – 0
I am getting this error – Report Engine not Opened. What can I do to fix this?
Answer Question
| October 29, 2010 2:38 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports error messages, Crystal Reports Errors
I am getting this error – Report Engine not Opened. What can I do to fix this?
Answer Question
| October 29, 2010 2:38 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports error messages, Crystal Reports Errors
Enable close button in Crystal Reports 9
when pulling up the a report where you can select your parameters the close button is disabled, how do I enable the close button in case I chose wrong report
Answer Question
| October 28, 2010 4:57 PM
Crystal Reports, Crystal Reports 9, Crystal Reports Buttons
when pulling up the a report where you can select your parameters the close button is disabled, how do I enable the close button in case I chose wrong report
Answer Question
| October 28, 2010 4:57 PM
Crystal Reports, Crystal Reports 9, Crystal Reports Buttons
Crystal Reports header/footer formatting
I was able to create a group header to print memo then statement page following memo for each employee but now am having trouble with the header and footer appearing on the memo. I only want the header and footer to appear on the statement not my memo. How can I fix this?
Answer Question
| April 13, 2011 6:17 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Conditional Formatting, Crystal Reports printing
I was able to create a group header to print memo then statement page following memo for each employee but now am having trouble with the header and footer appearing on the memo. I only want the header and footer to appear on the statement not my memo. How can I fix this?
Answer Question
| April 13, 2011 6:17 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Conditional Formatting, Crystal Reports printing
New Page Insert to an existing report in Crystal Reports 8.5
I am trying to insert a new page to an existing report, I want two pages to print per person and am having trouble with this. Please help.
Answer Question
| August 12, 2011 5:45 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports printing, PeopleSoft
I am trying to insert a new page to an existing report, I want two pages to print per person and am having trouble with this. Please help.
Answer Question
| August 12, 2011 5:45 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports printing, PeopleSoft
Crystal Reports 8.5 to Crystal 11.5.0.313
Can you convert Crystal 8.5 reports to version 11.5.0.313?
Answer Question
| October 26, 2010 3:17 PM
Crystal 8.5, Crystal Reports, Crystal Reports 11.5, Crystal Reports 8.5
Can you convert Crystal 8.5 reports to version 11.5.0.313?
Answer Question
| October 26, 2010 3:17 PM
Crystal 8.5, Crystal Reports, Crystal Reports 11.5, Crystal Reports 8.5
Getting prompted for userid/password when viewing Crystal Reports
Connections are ODBC Oracle. You can see a pic of what I am talking about here: This happens for every report on the server. Everyone uses the same login and password so I wish there was a way this wouldn’t bug the user.s
Answer Question
| October 14, 2010 6:13 PM
Crystal Reports, Crystal Reports User Settings, ODBC, Oracle Crystal Reports, Oracle Reports
Connections are ODBC Oracle. You can see a pic of what I am talking about here: This happens for every report on the server. Everyone uses the same login and password so I wish there was a way this wouldn’t bug the user.s
Answer Question
| October 14, 2010 6:13 PM
Crystal Reports, Crystal Reports User Settings, ODBC, Oracle Crystal Reports, Oracle Reports
Crystal Reports 2008 filter an array
How can I return records in a data set that have a specific variable, but not another? Ex: Return records when field A includes X but not Y?
Answer Question
| February 9, 2011 6:05 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Filter Formula, Crystal Reports Filtering
How can I return records in a data set that have a specific variable, but not another? Ex: Return records when field A includes X but not Y?
Answer Question
| February 9, 2011 6:05 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Filter Formula, Crystal Reports Filtering
