Search results for query: *

dateserial(year(currentdate),month(currentdate)+1,day(currentdate))

Reverse the dates and specify the isnull first. {LastSold.CustomerNo} startswith "T" and (UPPERCASE(LEFT({LastSold.CustomerName}, 6)) <> 'CLOSED') and ( isnull({LastSold.DeliveryDate}) or {LastSold.DeliveryDate} in Over90Days ) and {LastSold.ItemNo} = {?Item}

Try this formula if TotalPageCount = 1 then "***" else if TotalPageCount > 1 and PageNumber = 1 then "*" else if TotalPageCount > 1 and PageNumber = TotalPageCount then "***"

Try this {STATUS_TBL.STATUS}<>"CLOSED" and ( if {CASE.ROW_ADDED_DTTM}>= currentdate-3 then "0-3 Days" else if {CASE.ROW_ADDED_DTTM}in currentdate-6 to currentdate-4 then "4-6 Days" else if {CASE.ROW_ADDED_DTTM}in currentdate-9 to currentdate-7 then "7-9 Days" else ">9 Days" )

I will finally see the life and what a life it will be!!! After this Friday, everyday will be a Saturday.... I'll be retired!!!

What are you trying to accomplish? Changes to Crystal Report selection criteria will always generate a new sql statement that is sent to Oracle. Perhaps you should address this in the Business Objects: Crystal Reports 1 Formulas

Check the top and bottom page margins. Reducing it will allow more lines to be displayed.

Since you stated that employees have either 1/1/1753 or 12/31/2008, then I can safely assume that there is only one {BENEFITS} record per employee and no need for the maximum. You record select would be {BENEFITS.STOP_DATE} IN [DATE(1753,1,1), DATE(2008,12,31)]

As Hilfy said, any changes to a report must be rescheduled. Here's how I do it. From CMC, bring up the folder and click on the Schedule tab. Select a new date for start date and click update and then click schedule. Note: If you want the job to start immediately, specify the current date as...

Not knowing any specific details on what you are reporting, I would look into your suppression criteria for Group 3K and Group 3L. Apparently, there is some anamoly that is causing both to print.

Sorry about that but Monday is 2 not 1 {yourtable.datefield} in LastFullMonth and DayOfWeek({casemain.actcase_start_datetime}) <> 2

Or this {yourtable.datefield} in LastFullMonth and DayOfWeek({casemain.actcase_start_datetime}) <> 1

From the Main report, go into the field explorer and create the formula. Then insert a new group and select the formula, @FakePH, to group. On the group options tab, check Repeat Group Heading on each Page. Go ahead and delete the FakePH group name from the main report Click and drag the...

Try this From the main report, right click on the subreport and click on format subreport. On the common tab, uncheck Keep Object Together and Close Border on Page Break. If that doesn't work, then create a fake page header //@FakePH WhileReadingRecords; "" Create a group on @FakePH (be...

You could do the following. In GH1, place formula //@Max_Init shared numbervar maxtot := 0; In GF2, place 2nd formula //@Max_check shared numbervar maxtot; if sum_of_qty_used > maxtot then maxtot := sum_of_qty_used else maxtot := maxtot In GF1, place 3rd formula to display...

I've often wondered how much ribbing the students got when they said they attend Frankfort University of Central Kentucky

I have used Crystal reports to create the SQL update transactions. I then export it to a text file and process them in the database.

Saw this yesterday on a Mazda Miata. PAPRJAM Maybe a Printer/Copier service rep?

How about ({Name_Address.PURPOSE} = "P.O. Address" and (isnull({Activity.THRU_DATE}) or {Activity.THRU_DATE}>=CurrentDate) and {Activity.PRODUCT_CODE} = "COMMITTEE/ST_STRAT_TM" and ( Select {?StateCode} Case "AL": {STATE_REPS.ALABAMA} Case "AK": {STATE_REPS.ALASKA} . . . Case "WY"...

Saw a couple over the weekend LILMEXY GD2BALIV