Search results for query: *

thread782-827443: Viewer Problems in CE10- Major Concern!!!!! Crystal Developer; Product Type: Full Product Version: 11.0.0.1282 The viewer we use is crystal 12 Tag jsp viewer Reports that display fine in our client/server application display overlapping fields in our Web application when...

thread782-827443 Crystal Developer; Product Type: Full Product Version: 11.0.0.1282 The viewer we use is crystal 12 Tag jsp viewer Reports that display fine in our client/server application display overlapping fields in our Web application when viewed by the customer. In design the reports...

Crystal Developer 11.0.0.1282 SQL Server 2000 MS Windows XP Professional- version 2002 Service Pack 2 I have been asked to add the ability to track the "Total number of new records opened in the last 7 days" and "Total number of records closed in the last 7 days" to a report. The reporet is...

Crystal XI version 11.0.0.1282 SQL Server 2000 MS Windows XP Professional Version 2002 Service Pack 3 I am getting the "Dates must be between year 1 and year 9999" error message when I run my report. The following formula comes up and the bolded line is the line highlighted in the Crystal...

thread768-493919 Did anyone ever have any luck determining what caused the 'field name not known' error message? My error message is: Exception in formula '{@Record_Selection}' at '{PROJECT_TEXT.PROJECT_ID}': This field name is not known Which makes no sense to me. I've checked all the...

Exception in formula '{@Record_Selection}' at '{TABLE.FIELD}': This field name is not known Crystal XI (11.0.0.1282); Oracle 10g; running a Java web application and I don't know what other information I should provide. (I'm still learning all this.) My report runs in my SQL application without...

Crystal XI product Version 11.0.0.1282 SQL DB ODBC Connection Data type is picture Blob field in this instance contains text but could contain a .jpg, .xls, .pdf, .msg file depending on the record being viewed. I have opened the text file in the client-server application so I know there is...

I have been instructed to create a report showing, in line chart form, the number of Corrective Action Requests over 5 years shown in 6 month increments. I should have 10 data points on the chart. I know very little about writing formulas least of all formula's using variables. I'm using Crystal...

Crysta XI; SQL 2000 DB I have a cascading Country, State, City parameter and haven't been able to figure out how to account for instances when there is no state or city. My selection formula follows: {SUPPLIER_MNT_V.COUNTRY} = {?Country/State/City - COUNTRY} and {SUPPLIER_MNT_V.STATE} =...

My thanks to IanWaterman for posting the following formula which seems to have solved the problem I've been struggling with. Of course, no sooner, is one problem solved and another comes along to fill the void! The result is rounded and I prefer to display two digits to the right of the decimal...

Crystal XI; SQL 2000 DB I would like to total two number fields per record (labor cost + material cost). The SUM function doesn't seem to be what I'm looking for and I can't find an ADD function. (I'm new enough and dumb enough to think it could be that easy... as if!) I'm sure there is a way to...

I'm trying to retrieve a date from 4 subreports using a parameter. I only want the user to enter one date range and have it apply across the entire report. In regards to the subreports one date might be a due date, another a closed date. I think I need to use a shared variable but I don't know...

I have an unlinked subreport and I would like to retrieve records for the current month only. I am grouping on the following formula: If {Table.StringField} = "R" then "Past Due" else "On Target" I tried {Table.DueDateField} is in period MonthToDate in my record selection formula but that...

I'm having a problem with a report that was designed in Crystal XI (11.0.0.1282) using a stored procedure and is running against an SQL 2000 DB. The report has a mind of it's own. The report works fine when first opened, however, once I close the report and attempt to reopen I receive the...