Recent content by racskelly

this is a two part question my raw data looks like this sales amount running total jun 1 1 1 jun 15 -1 0 jul 1 10 10 aug 1 -8 2 i want to find the maximum running total amount plus the date on which it...

not really... they will have to enter a invoice number (parameter) to generate the report

I have a generic report that is run company wide... but all I really want is to add a short cut to their desktops that runs this common report...instead of them having to go to our crystal server, login, pick a folder then pick a report. Is there anyway to do this?

I have a generic report that is run company wide... but all I really want is to add a short cut to their desktops that runs this common report...instead of them having to go to our crystal server, login, pick a folder then pick a report. Is there anyway to do this?

can i use maximum([if(not(isNull(field1))),if(not(isNull(field2)))..etc?

what if some of the dates are null... if so, maximum doesn't seem to work

Thanks Mr Bill... I thought of that... but what if i have dozens of date fields to check.. is there an easier way?

my question is how do you have a header appearing after your last record?

I need help writting a formula: Each row has the following information ref_no | this_date | that_date | the_other_date i would like to calculate max_date on the same row (max date of this, that and the other) as well a flag that indicates if max_date >= today+1year any ideas?

Number

maybe format is YYMMDD

that is what i'm trying to figure out...

921014 is a date stored in a hundred year format... thats what it means. its one of three possible date formats in AS400

thats the question... the database stores dates in the hundred-year format...but i have no idea how to convert 921014 to a normal date format...

does anyone know how in crystal to convert as400/db2 dates (that are formated using the hundred year format) to normal dates... for example the database returns my dates similar to 921014