Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gtarrant

    Macro "LoadReport" variable problem

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

    Report launching oddity - any solution?

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

    If..Then with multiple criteria

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

    Prior Row - gtarrant reference

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

    Where's my file extensions?

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

    Case statement in a where clause?

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

    Case statement in a where clause?

    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)...
  8. gtarrant

    Concatenation with dates - I want the date not numbers

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

    Concatenation with dates - I want the date not numbers

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

    equivalent to case statement

    use DECODE
  11. gtarrant

    How can I update a LONG datatype?

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

    Can't log on and can't format...Please help a newbie.

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

    Can't log on and can't format...Please help a newbie.

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

    Rounding help needed - I thought this was simple.

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

    Rounding help needed - I thought this was simple.

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

    Rounding help needed - I thought this was simple.

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

    Can this be done using only sql? Programmers please advise.

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

    Can this be done using only sql? Programmers please advise.

    Yes, it would have that field also.
  19. gtarrant

    Can this be done using only sql? Programmers please advise.

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

    Can this be done using only sql? Programmers please advise.

    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.

Part and Inventory Search

Back
Top