Search results for query: *

Hi, I have a job that runs every hour, see code below. How do I get to run at 08:00, 12:00 and 16:00 only? Do I have to create 3 jobs to run at 8/12, 12/24 and 16/24, or is it possible to do it all 3 in 1 job? Thanks in advance. DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job =>...

I once heard a weather forecast in Ireland "There may be drizzle between the showers." So it could be dry, drizzly or showery. The only way this forecast could be wrong is if it snowed!

I went into a chipper and asked for a cod and chips twice. The guy behind the counter said "I heard you the first time." :-) (probably only makes sense in Ireland and UK)

Perhaps "aspirate" would be appropriate?

Hi, Flan O'Brien (author of "The Third Policeman", mentioned in the TV show, Lost) had a story about a plan to conserve essential supplies during WWII. Everyone was to go to bed for 3 days a week, thereby reducing the amount of food they would consume, as they could get by with just bread for...

When somebody asks how I'm doing, I vary my response between "I'm about average for this time of year" to "Well, I have this dull pain in my right side, and a ringing noise in my left ear since I got up this morning, and ..." until I see they have lost interest in my reply. Then I say "Do you...

Apparently, there were both 2- and 3-cent coins issued in the past. See http://cgi.ebay.com/1872-Fine-detail-Two-2-Cent-Coin-MY706_W0QQitemZ8413643868QQcategoryZ3356QQcmdZViewItem and http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=8416489887&ssPageName=MERCOSI_VI_ROSI_PR4_PCN_BIX_Stores for...

Lbass, That worked OK and the users are happy. Thanks, tr

Lbass, Thanks for that. I will try it and let you know. Best regards, tr

Hi, I have a Cross-tab report in CR8.5, where I am displaying each group's Sum, Count, Maximum and Minimum. I display the text "Total/Count/Max/Min" in the "Grand Total" at the bottom left of the crosstab, but I would like to be able to display this within each group, like using the "Show...

I believe that, at the time the story was written, 2-cent coins were still in circulation. tr

Hi, The village where I come from has a sign saying that the next village is 5 kilometres away. That village has a sign saying that our village is 6 kilometres away. Back in the old days, they were both 4 miles apart. A couple of years ago, the other village got a traffic light. Within 30...

Hi, This may also be of interest. tr http://support.businessobjects.com/library/kbase/articles/c2018764.asp

Hi, Line and Bar in same chart is shown in p231 of the book "Special Edition Using Business Objects Crystal Reports XI" by Fitzgerald, published by Que. I saw this in the bookshop next door. I didn't buy it because it didn't have an answer to a question I have - how to display crosstab totals...

Hi, I've seen this done in a CR XI manual, but I don't have it to hand. I will try to locate it and post the reference later. tr

Satinsilhouette, Thanks for your suggestion. I fiddled around with this. In Chart Expert/Data/Show Value(s), I tried ticking and unticking "Don't summarise" for the total object. I found that I can get it to display either Types 1, 2 and 3, or the Total, but not both. I can export the data from...

Hi, I am using CR XI, reporting on an Oracle database. How do I include cross-tab Total figures in a cross-tab chart?, e.g. Type1 Type2 Type3 Total Date1 10 20 30 60 Date2 5 10 15 30 Date3 100 200 300 600 I am using a cross-tab report...

Rick, re the effect on performance of adding line numbers, I think it's worth having a little overhead in terms of performance if it saves time in development, support and trouble-shooting. User satisfaction is more import than optimum resource efficiency. Tony

Volk359, > the English tendancy to change nouns to verb... Turning a noun into a (transative) verb is mainly a feature of American English, I think. Eventually, I believe, all nouns will 'becomed' transitive.

There is a country song "You Can't Make A Heel Toe The Line". I think it was written by Hanlan Howard and sung by Johnny Cash.