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!

Recent content by jwray100

  1. jwray100

    DECODE wildcard

    RSHelp, Now why didn't I think of that! :-) Sometimes you need a fresh set of eyes to help you see the forest past the trees. Thanks for the help. Joel Ray Ronile, Inc.
  2. jwray100

    Add condition to macro?

    Should work with addition of If/Then as below. If c > 1 it will be untouched. Sub TotalAssets07() a=val(SumField$("Field16","",3,0)) b=val(Field("StBalTotalAssets07")) d=val(field("Field10")) c=(a+b+d)/1000 IF C <= 1 THEN C = 0 END IF derivedfield str$(c) End Sub Hope that helps...
  3. jwray100

    Reading from a text file

    I'm familiar with writing to a text file (i.e. .csv). I think I learned the method from this forum. I have a need to read from a text file, but I'm not sure of the best way to go about doing this in a RS macro. The requirement is to have some semi-static, non-ADP DB data for use in the report...
  4. jwray100

    DECODE wildcard

    Is it possible to use wildcards in a SQL derived field with a DECODE statement to approximate a "LIKE". For example: DECODE("REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWHOMEDEPT", '%AH', ( NVL( SUM(DISTINCT "REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWGROSSPAYA") , 0 )), 0 ) to return the gross pay...
  5. jwray100

    Comments/Remarks in derived fields

    Thanks. That worked perfectly. Joel Ray Ronile, Inc.
  6. jwray100

    Comments/Remarks in derived fields

    Is it possible to add comment/remarks in SQL derived fields? I'm looking for the character(s) to use like the character (' I think) used to remark out lines in RS Macros. Thanks, Joel Ray Ronile, Inc.
  7. jwray100

    Summary Fields within Selection

    Oops! Sorry, I pasted the wrong thing in my post. The actual derived field I used did not have the >= 20000. OK, here's the data I'm trying to get in my report: A list of all EEs with their company code, file#, SSN, first name, last name, total gross earnings for the year, total of deduction...
  8. jwray100

    Summary Fields within Selection

    Hi Charles, Thanks for your input. I'm actually trying to create a selection criteria a level deeper, if you will, than my derived fields. Let me clarify a little. They are SQL derived fields: SUM(DISTINCT "REPORTS"."V_CHK_VW_DEDUCTION"."CHECKVIEWGROSSPAYA") SUM(...
  9. jwray100

    Summary Fields within Selection

    I have a similar issue. I'm trying to select all EEs who have a total gross pay for the year >= a certain value. I have a SUM DISTINCT derived field to extract the gross values for each paycheck and a summary field for the File# group to total all for the year. Also have SUM derived field for...
See more

Part and Inventory Search

Back
Top