Search results for query: *

I also need to format some dates using System Long or Short Format for international customers. This is where the date field overlap becomes a big issue. Even though I may size the field to display only the date the viewer ignores the fields border and displays the time anyway. Sorry I haven't...

I guess I set myself up for that one! True I could format the date to only display the date portion of the datetime field. That's what I've been doing as, what I hope is, a short term workaround. I'd prefer to resolve the problem of the fields overlapping once and for all so reports display as...

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...

I think I mistakenly posted this question to the wrong forum. I'm not sure how to move it to the Business Objects: Crystal Reports 4 Other Topics. So I'm going to copy and post there. If swear I'm not attempting to double post. I'm just ignorant to the method of moving an incorrectly added post...

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...

New customer communications or closed customer communications within the past seven days when the report is run on any given day. If I ran it today I would want to see all closed and opened communication records within the past 7 days to include the date the report is run. If I run it a month...

New in relation to the time period (last 7 days). Doesn't matter if the customer is a previous customer or not. The first 2 groups specified are fields from the customer communication table. The 3rd group is from a Nonconformance table (possibly) resulting from a customer communication...

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...

Thanks for the responses lbass and CoSpringsGuy. My eyes are crossing at the idea of delving into the formulas in this report. I'm definitely in wayyyyy over my head on this report. I'll have to give your ideas a try and hope that both I and the report survive to tell the tale. Thanks to both...

CoSpringsGuy - I tried your suggestion but still get the same error message. I don't get any data returned at all, just the error message. Lbass -it's a calendar report with a bunch of subreports that was written way before I came along. If it doesn't make sense to you I feel better about the...

Still getting the same error message and the same line is highlighted (see bolded text) EvaluateAfter({@Year}); EvaluateAfter({@Month}); Global DateVar StartDate; Global Stringvar strMonth; Global StringVar strYear; Global NumberVar nSuppressYear:=CDbl(strYear); Global NumberVar...

Month formula: Global Stringvar strMonth:=Totext(Month({DOCUMENT_MNT_V.NEXT_DATE}),0) Year formula: Global StringVar strYear:=ToText(Year({DOCUMENT_MNT_V.NEXT_DATE}),0,"") Sorry I'm troubleshooting a report but have very little knowledge of formulas. I'm just now beginning to learn about...

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...

Thanks for your response. I eventually attributed the problem in the report to fact that there wasn't any qualifying blob file to display. The record selection in the report was limiting the return and the customer did not have qualifying data. The report worked just fine once I figured that...

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} =...

Thanks lbass, I appreciate the help!