Recent content by RCCRookie

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