Recent content by twes3

Anybody ???

Need assistance. Is there a way to print a White font to a printer file? I have an overlay that have a black background and the font have to be White. Can't hardcode the font because its a variable. Thanks in advance.

Work like a charm!!!! Thank you IanWaterman.....

Need help with getting the minimum and maximum for a record location from my database. In my database an item can be in it twice. The difference is the record type which is either a '1' or '2'. In my Crystal Report (ver10), I am grouping on the item. In my group footer I am displaying the item...

Thank you all for the advice. I used Ian suggestion and it works like a charm. Thank again. ((Year(currentdate)-2000)*1000)+datediff('d', Date(Year(currentdate), 1, 1), currentdate)+1 [2thumbsup]

Thanks everybody for the advice. I forgot to mention my 5 digit julian date is numeric. So i will need a conversion for numeric. Thanks again.

Hello, I need to convert a calendar date parameter (example 11/12/2012) to a 5 digit julian date (example 12317). The 5 digit julian is how I will access my data. Any ideas to how to do this? Thank you in advance.

Hello all, I am running on Crystal Reports 10. I have a numeric date that will always be the same that I'm getting from a database field in my subreport. I need to pass this value back to my main report and display it in my page header. Can this be done? If not are there any other options...

Hi, I am using Crystal Reports 10. I am trying to display 'N/A' on a formula field. Here is my formula: If {v_test.exception_flag} = 'N' then {v_test.inv_onhand_qty} else 'N/A' I keep getting an error message that 'NA' is not numeric. Any suggestions???

Here's my problem. I have two databases, FISCALDATE & INVOICEDATE. In my FISCALDATE file, i have two fields (begdate & enddate). In my INVOICEDATE file, I have one field (invoice date). I need all records from the INVOICEDATE file that fall within the begdate and enddate of the FISCALDATE file...

I forgot to mention I am only using one parameter called 'REPORT DATE' as a date range option.

Ok...The user enter a parameter start date as '20050101' and a end date as '20050131'. The parameter has a string value type. In my database the field is a 11 char field so I used a forumla to give me the first 8. I just want to display whatever the user inputted into a true date version on the...

Hello. How do I convert character date field (YYYYMMDD) to a true date field? Thanks

Hello. I converted a JDE date that I get from our database to a CR date format (01/01/2006) using the formula below: STRINGVAR JDEDATE; numberVar JDECENTURY; numberVar JDEYEAR; JDEDATE := TOTEXT({Command.CDDFYJ}, "000000"); JDECENTURY := TONUMBER(JDEDATE[1]); JDEYEAR := TONUMBER(JDEDATE[2 TO...

Hello. I need a formula where my end of month will fall in a 4-4-5 format. Example: start of month is 01-01-06 end of month is 01/28/06 next end of month is 02/25/06 the next is 04/01/06 Thanks in advance