Search results for query: *

thanks everyone. worked a treat!!

Hi, I'm using CR9 on an oracle DB. not sure if this is possible. I am writing a report which has many groups. The final group gives a lot of detail, but I want the report to be able to remove the second from last group on end user selection (through a parameter I'm assuming) and still give the...

I'm sorry if this is so simple, but I am quite weak on cross tabs. I am trying to create a report showing the following:- A 50(DISTINCT COUNT OF "WO_NO" - IN SUMMARY) 10 (SUM OF FORMULA CALLED "@IN TIME" - IN SUMMARY) 20% (FIELD I NEED TO CREATE) B 100 60 60% C ETC...

yes, they are REAL_F - for Actual Completion for planned completion, I have a formula which requests the larger of the two date fields below. (I know, this makes it more complicated!!) REQUIRED_END_DATE - is a deferral date but not always larger PLAN_F - is the planned completion, so my...

all fields are from the IAL. the view is XXX_AWOT2 with the fields below in it. SECONDARY WO_NO

it's oracle database. the table is an IAL - XXX_AWOT2 site is "SECONDARY" work order is "WO_NO" can you help, I'm not good at SQL, and seem to be inputting it wrong!

My fields are = site, work order number, planned date, actual date. My groups are, GP1 - planned date (by month) GP2 - Site (defaulted to ascending) Formula in details is, if actual date <= planned date then 1 else 0 - this is to give a sum of whether that work order was completed in time. My...

Hi, I'm very stuck here. I'm using CR9 I have two columns in my report, grouped by the first column(defaulted in ascending order), and a percentage summary (worked out from GP 1 sum of a formula returning 1 or 0 in the details divided by a count of site) I want to be able to present the report...

Hi, I'm very stuck here. I have two columns in my report, grouped by the first column(defaulted in ascending order), and a percentage summary (worked out from GP 1 sum of a formula returning 1 or 0 in the details divided by a count of site) I want to be able to present the report in highest...

you absolute star! thanks so much, this has taken me so long to work out!! cheers charlie

it doesn't recognise "RoundUp" as a function! I'm using CR9 if that helps

Thanks lbass, this worked briliiantly, just one more question, how do I make the 5% round up to the next whole number, e.g if there is only 1 record in that group, I want it to return that one record, if there is 25 records in that group, I want it to return 2 records etc etc. your help is much...

thanks for the info, although still having problems, I have grouped sites and done a distinct count of work orders per site. record sorted them by ascending using the rnd(work_order)in the details section. In section expert details, I have ticked suppress and input the following formula:-...

the database is oracle9, the number of work orders could change every month - this is to pick 5% of work orders per month for audit, so has to be completely random.

Hi, I have a sample of 85 work numbers which I need to select 5% at random. I'm new to rnd command and the help on crystal reports V9 isn't idiot proof, could anyone help? I'm not sure what to put in and where!! Greatly appreciated.

I am able to set parameters, formulate SQL for selection formulas, but my knowledge of the sql functions isn't that good. I can do if else, datetime, strgvar, I'm just struggling with this one and the help on CR9 doesn't prompt you unless you understand the more complex commands. I have...

I have CR9, but what do you mean by building a command? ]sorry, I'm still new at this and teaching myself

Hi, I have a history journal on my database which has many entries for one work order. I only want the latest date entry of the history log to appear in the details section of the report. Is it possible to ask for this in the selection formula?

Hi, I have a number of parameters in the selection formula, but want the end user to be able to use all or as little as one parameter when entering the report. I can't quite seem to be able to use my little knowledge of SQL to make this work, it doesn't wnat to know when I exchange AND for OR...

Thanks very much, I had the < in the wrong area!! so simple!!