Search results for query: *

Thanks synapse - for the info and the leads.

Is it possible to Schedule a report to run at a given time and write to a specified file in CR 8.5 or is that only a feature of newer versions????? [ponder]

I am guessing because you have contact info you are pulling address/contact data from your customer master and joining that information with your payment history and then summing. So if there are 3 contacts all with the same customer number then it will join the payment history to all 3 and...

PDQBach- The difference between my above example of the "as is" at .02 hours per unit and "to be" of .0166 is 17%. Each of these units will be multiplied by 1,000's or 10,000's creating something more than "irrelevance". With the majority of the hours per unit being in the low digits, the net...

Using Ms Project 2002 I set up a custom formula in Number format, it all seems to work fine but I just need it to go deeper than 2 decimal places. Can anyone suggest a way to add decimal places? My formula looks like this (an "if" to avoid the annoying #Error with the Div/0 scenario) (Number 3=...

Beilstwh, A valid point. In my position I have all the permission I need to retrieve data from the tables. Just none that would permit me to put data in the tables so I am not able to create the data. Thanks Anyway

Santa, I think for what I am doing the hardcoded version will be perfect (even though it is longer). Thank you so much. You have a gift-[moroni 10]

Right now I am trying to find the simplest way whether it is INSTR/SUBSTR or something else. I am open for any suggestions. Thanks in advance

Hello All, I am trying to do an INSTR (unless someone has a better suggestion) The reference field combines several values that I need to isolate SELECT MS.IDENTITY, MS.INVOICE_NO, MS.CODE_A, MS.REFERENCE FROM IFSAPP.MAN_SUPP_INVOICE_POSTINGS MS WHERE MS.CODE_A IN ('5050','5051')...

Lewisp, I knew it was simple, but it had me going in circles. Thanks a ton. [rockband]

I have a field that contains date/time info but I need to convert it to a legible date time format. It is formatted like '20051206135428' and I would like for it to read 12-06-2005 01:54.28 pm (mm-dd-yyyy hh:mi:ss) or I could even drop the time and say mm-dd-yyyy. Whichever is simpler. Any...

lbass, It worked! You are BRILLIANT! Thank you

CR Verson 8.5 I am struggling with the Drill Down Headers. When I get to the 2nd Drill down i can't get the headers to work like I would hope. I am trying to get the title info over the detail section of drill down (2nd drill) without having it show over every result Maybe someone can help I...

Thanx Engi, I worked great. Much appreciated!! [orientalbow]

Thank you engineer2100, good stuff and I am half way there, I just need to be able to tell it to stop at the comma -1. Any other help on how I can do that?

I am trying to 'extract' if that is the correct word, a portion of a description for a field, please see example. here's my simple statement: select hla.LOG_ID, to_char(hl.TIME_STAMP,'mm-dd-yy')Chg_Date, history_log_api.Get_Description(hla.log_id)Part_Desc, hla.OLD_VALUE...

Gracias, I knew it was something simple Thanks for your help[unclesam]

This is a newby question, but can anyone tell me how to get the current year? There are simple ones like CURRENTDATE which shows today's date, but how do I isolate the year from the current date?[roll2]

djbjr, Thanks for the input, yours even looks simpler. I have already finished the report and the performance is quite good but gratefully the code is there for any other users that might happen upon this thread. **********[elk]**********

Does my question make sense above?[elvis]