Recent content by dlblack

You might try a combination of dividing by 100 and left pad (lpad) with zeroes to the final length desired. Something like lpad(yourfield/100,12,0) David L. Black Consulting

erikhertzel is correct. If your pc has been running ok you can sort these by date and delete the ones that are a couple of months old if you want to get back the space. Just make sure that they are all the uninstalls. This has worked for me. David L. Black Consulting

You might try removing the quotes from '1' or add quotes to 0 for your compare. David L. Black Consulting

Sorry, I should have said a whole number. Try trunc("yourfield"/10000) David L. Black Consulting

The way I would do this is as follows: 1. Add 999 to your original field. 2. Truncate to a derived 2 digit integer field. 3. Multiply by 1000 with result in an appropriate size derived field to accomodate your largest possible answer. This may not be the best way but it should work for you...

I would try modifying the sum macro to include an "IF condition THEN action [ELSE Alternative_Action]", so that when you are stepping through the records if the value of the next macro derived field is greater than the current value, set the new derived field to the greater value. Just a...

You can aways use the old trick of adding .005 to your field and truncating it if you don't come up with a better answer. David L. Black Consulting

There is a sample of this type of report in ADP's samples called annivers.rpt. You should be able to use a derived field for length of service like the following: (displays a field of years and months from the system date) TRUNC(((TO_CHAR(SYSDATE,'YYYY') -...

Have you tried dividing by 1000 into an interger type field? David L. Black Consulting

I believe you can accomplish this with a string of multiple decodes. Assign a value for each of the 7 groups to group by. DECODE(Greatest(x,y),x,1,y,2) David L. Black Consulting

You may need to try using a macro to create the field you need. Try this site for support. http://www.srs-inc.com/support/HowDoI/start.htm David L. Black Consulting

I installed them on my Toshiba laptop with XP Pro SP1 and upgraded to SP2. Have not had any problems with these apps. David L. Black Consulting

Yes, I meant the group by, try to reduce the number of records that RS has to process. Your ADP RS support group should be able to provide you with a sample macro that will produce a fixed length flat file. I also recall an issue with the max. number of rows that EXCEL can handle. This is a...

Are you running this as a stand-alone or is the database on a separate server? You might look at the option settings, under tools on the RS screen and tweak the buffers and/or process on the server if possible. Look at the how the report is structured and use the group by sorting on the...

I have used scheduler for quite sometime and have not found anyway to save the file other than pdf. David L. Black Consulting