Search results for query: *

I'm on ReportSmith version 3.11 and I hope someone has the answer to this one. I have a report that calls another report by using the "LoadReport" statement. This statement also allows you to pass a variable off to the report that is loaded before SQL execution. The below example displays...

We have over 50 users of ReportSmith where I work and we recently received new computers. We went from Windows 2000 to Windows XP Professional. Here's the strange part - for some users (not for all)when you double-click on a report that has already been created, ReportSmith opens but no report...

If you're doing a macro, you would write it like: If Field$("A") = "X" and Field$("B") = "Y" Then D = "Z" Else If Field$("A") = "X" and Field$("B") = "Z" Then D = "Q" Else D = "No value" End if DerivedField(D) I find it easier to either do a decode or case statement using a derived field...

You would want to set up your query using two PS_JOB tbls -I assume your using ADP Enterprise. You would then compare PS_JOB 1 with PS_JOB 2 (PS_JOB 2 being less then PS_JOB 1). My example below is copied from a report I did in ReportSmith, so the tables are already aliased in the background...

I've just placed Windows XP Professional on my notebook and when I go to look at files in my directories, the file extensions are missing. For instance, when I look inside a file folder that has 5 programs/files inside, I go to my tool bar, hit 'View' then 'Details' I'm still not able to view...

I've tried to rewrite this and I'm now getting the error: single-row subquery returns more than one row. I'm trying to compare all RATE_SCHEDULE_ID values on the table (4 distinct in total) and convert them into just two, giving me the TOTAL_COVRG_RATE for only two. SELECT X.TOTAL_COVRG_RATE...

I'm having a problem with the below script and I don't even know if this is possible. I would like to insert a case statement within my where clause to control rates but have received this error when I fire off the sql: invalid relational operator (its pointing to 'THEN' in my case statement)...

You rock Roy! Thanks for the very quit response...it's exactly what I needed!

Hi everyone. I have a problem that one of you could help me solve. I want to concatenate a string with a date - simple, right? Here's what I get: Column A1 Column A2 7/8/2004 The date is 38176 Here's my formula: =CONCATENATE("The date is ",A1) Why can't excel simply return the date...

use DECODE

Is there a way to do this within an sql script? Here's what I'm dealing with: PROD SQL> / update ps_position_data set descrlong = descr where descrlong <= ' ' * ERROR at line 1: ORA-00997: illegal use of LONG datatype Thank you for your help.

Thanks for all your help. After my post, I started receiving parser errors and I was just about to toss the whole computer out the window. I was finally able to reinstall windows. For future reference if someone else ever runs across this nasty virus (or whatever it was), I had to go into my...

My computer for the last month has been giving me errors but I've always been able to log on to my desktop. I know I must have received a virus, but I always thought that I would just format my drive when it became too much of a nusance. Now I can't even log in. I receive the error message...

Thanks vongrunt!!!! I'm glad to see a programmer say this was unusual - now I don't feel like such an idiot. It works perfectly and is exactly what I need. Thanks again.

I've tried that also, but it seems to only go up by a dollar - see below. 60665.28 60666 63394.24 63395 I need it to go up to a thousand.

I have a situation that has left me feeling like a complete newbie. I've even tried to research this on the internet, but haven't located anything on it. Here's my problem: I'm trying to round a salary amount to a thousand, trying to always round up. So, for instance, if someones salary was...

I am forever in your debt. Thank you!!!! It works GREAT!

Yes, it would have that field also.

Sorry about that, I've left out alot of info in my above example. I'm actually working on Oracle 8i and the database is very simular to PeopleSoft called ADP HRMS. Since there are a ton of tables out there, for this example lets say I'm using only 3 tables to gather the info. PS_PERSONAL_DATA...

Thanks for your quick response, SantaMufasa. The output will be a file type TXT. From there, we would either zip it or use PGP to send it to the vendor.