Recent content by jwray100

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.

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

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

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

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

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.

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

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

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