Search results for query: *

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

great suggestions...i'll try that.

Some of my reports seem to take forever to run...and i don't feel like there is enough data there to cause this slow down. For this example I have the following table structure Table A - trade_num 1. trade_num Table B - trade_specs 1. spec_id 2. trade_num 3. spec_description i want to...

On your database expert highlight the table you want to rename in the selected tables window and hit F2 to rename it...

Hi has anyone else here used Ghostscript before? We are trying to install it on our mediatemple server via SSH (with Putty) but we keep getting the following error after our make command... make: *** [obj/gdevx.o] Error 1 anyone else heard of this... Thanks

Hi, I'm trying to create a site where users can upload PDFs to my server, and the server converts the PDFs to PNGs using ghostscript, and then GD converts the PNGs to JPGs does anyone know how to do this in GD? I already have the first part finished. thanks