Recent content by johnstrang

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