Search results for query: *

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

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

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.

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

Hi, hope you can help. I am trying to group a datetime field into "current month", "previous month" and ">previous months" e.g current - January 2007 Previous - December 2006 >Previous - November back to 2004 this is what I have so far, but I can't work out how to get >previous months without...