Search results for query: *

For clarification: sdow81 wrote GB = Scotland, England and Wales UK = Scotland, England, Wales and Northern Ireland

I would like to include the Year Number in the title of a chart - something like "Count of Planned Works by Type for 2004". I know I could enter it as text, but then I would have to modify the report for next year - would be Ok if there was only 1 or 2, but I have quite a number of...

Thanks Ties - nice to get some positive feedback. It's just a pity that I had to create a MONTH_NUMBERS table. All it contains is the numbers 1 to 12 - I'd hoped it may be possible to avoid creating such a table. But it works, and it's not taking up much disk space! John

Hi again, I have come up with the following MONTH_NUMBERS.MONTH between to_number(to_char(PW_START,'MM')) and NVL(to_number(to_char(PW_STOP,'MM')), to_number(to_char(sysdate,'MM'))) OR (MONTH_NUMBERS.MONTH < to_number(to_char(PW_START,'MM')) AND...

Thanks for the information - I'll let you know how I get on with it. The users want reports only for the current year, so hopefully that will not be too complicated to implement. If I get stuck I'll be back :-)

Hi DataHugger, If your boss "loves using email to keep records" then send him an email (and make sure you get a "read recipt" for that email!) When he reads it, print the mail with the receipt. As to your concern that "I have also made mistakes only an inexperinced person could make." - that...

Hi, Using BO5.1.7 on an Oracle 8.1.7 database. I have a problem where I need to count the number of jobs worked on per month. There are fields "Actual Start Date" and "Actual Completion Date". Finding the month of the Start Date and Completion Date is straightforward, but the difficulty...

Hello Zoom, Here are my thoughts on your situation: 1. You say you have no major work in the last month, but you are currently working on another project on JSP. Does that mean your current project is not taking 100% of your time, or is less important than the ASP projects? 2. Make sure that...

Continuation from my previous post which I posted before completing the reply :( It is exactly the situation I found myself in a couple of months ago - nice to know I'm not alone! I can't agree more "Get a spec before you start" and if changes are requested, do your best to include them but...

Rosieb, What you wrote

My Apologies,sclark415 - I'd not tested thoroughly enough. I'd checked that the field was printing only once, but I'd not checked that the other fields were from the first record. Anyway, I'm pleased that you have the result you wanted - thanks to Katy44 for correcting me!

Sorry, no other ideas. I tried it on a test report (admittedly on 8.5 as I said) and it worked fine for me. I hope someone else who has more experience with V9 will be able to help you. John

In 8.5 (I don't know about 9 but I guess it will be similar) you can format the details section as follows: - for Suppress (no drill down) click on the X-2 formula editor - enter formula Next ({field1}) = {field1} This should include only the first record for each field1 I hope this helps you...

Hi all, It works fine. Thanks again to Lisa (I've given her post a star) who posted her reply as I was posting my own solution - obviously great minds think alike :-) Have a good weekend, John

I have had a brainwave. I have created a formula {@service_group} select left({ODS_CLF_ORDER.CLARIFY_X_SERVICESHORT},1) case "C" : "Concert" case "M" : "Mobile" case "S" : "Special" default : "Internal" then grouped on {@service_group} as Group 1, with my existing group on ORDER.SERVICE as...

Dear All, I thought this was complete, now I have one further requirement. To recap: All fields are in 1 table (ORDER) Data is grouped by ORDER.SERVICE Here is an example of the report: Week Number 21 Cumulative New Change Cease New Change Cease CATM...

Dear all, Firstly, I am sorry if my example data and required output was not detailed enough - but I cannot publish any live data in a public forum such as this. Many thanks for the replies - the approach of having 6 formulas worked fine, but I had a little trouble enabling summaries - it...

Pebcam is good, I like it :-) I also like the ID TEN T error = ID 10 T Another vital commandment is RTFM (Read The Flaming Manual)

Hello Swi, It seems to me that you are in quite a strong position, for the following reasons: 1 Your old company want you back (it was them who contacted you), so they must have been pleased with your work and perhaps they realise just how useful you were to them when you worked there. 2 You...

£30k sounds a little low, but it depends on so many other factors: Age Experience Location Other benefits (eg car, health insurance) Opportunities for attending training courses (management and technical - you may need both) Will you be on call 365 days per year, 24 hours per day? But as Pascal...