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

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?

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?

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

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

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

Hi I'm trying to prevent users from double clicking buttons when they submit a form.. Ideally I'd like to load a flash preloader file floating in the middle of the screen when they click submit on the button. I'm also using images as my buttons on my forms..not standard html buttons. Any ideas?

I have two datasources related by a common trade_num field... i want to find all of the trade_nums in datasource A that are not in datasource B... how do I join those two tables.. I tried inner join - not enforced - != but it didn't work... any ideas? Thanks Shane

is there a SQL query I can run to determine which users are currently running some process on my server?

I want to join the unique data in a field into a string for each group... lets say my data set is 1 Red 2 Blue 3 Green 4 Red 5 Yellow 6 Blue i want to show a formula in the group for these rows that indicates the distinct colors separated by commas: so for this example Red...

Is it possible to link to a specific view-on-demand report from a users desktop? Even if they have to enter in their username and password thats ok... but I'd like to put a shortcut on their Windows desktop straight into a file, so they don't have to click through a whole bunch of steps to get...

I'd like to know if it is possible to use Crystal Parameters in a SQL Command... for example... I want the user setup a complex SQL statement SELECT * FROM APPROVED_TRADES WHERE trade_dt in {?Start Date} to {?End Date} UNION SELECT * FROM VOID_TRADES WHERE trade_dt < {?Start Date} and...

I'd like to have a prompt that goes live to the database and gets all the companies in the system that the user can then choose one or more of before running the report... when i setup a dynamic parameter it only includes the first couple hundred... Any ideas?