Search results for query: *

If you are using an SQLBase database then use this Macro Derived Field: Sub row() r=current() + 100 derivedfield r End Sub

Instead of using a wildcard for the value I think you are going to have to parse the Home Department first and then compare to a literal. ----- If you are using an SQLBase database try this: @DECODE(@RIGHT("REPORTS"."V_CHK_VW_EARNINGS"."CHECKVIEWHOMEDEPT",2), 'AH'… ----- If you are using...

Note, this will only work with an Oracle database.

Create a Derived field as such rownum + 100 That will take the rownum of the output and add 100 so your first row will show 101 then 102 etc. Hope that helps.

You didn't indicate what product you are using. If you are using ADP PC/Payroll for Windows with an SQLBase database then create a report with at least Hire Date, Termination Date and Rehire Date from the V_EMPLOYEE view (they can be Query Only if you want) and then create a Derived Field...

We really need more information like: What ADP product are you using? What version of ReportSmith are you using? In general all of the ReportSmith v4.2.x versions below 4.2.2005 have various "Save As" issues. If you are not on the newest ReportSmith (4.2.2005) and are an ADP Majors...

You are going to have to build a Macro Derived Field instead of an SQL Derived Field similar to this: Sub test() if Field$("COMPANYCODE") = "ABC" or Field$("COMPANYCODE") = "XYZ" then build_first_function_here elseif Field$("COMPANYCODE") = "123" or Field$("COMPANYCODE") = "456" then...

Try deleting this key from the registry: \KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing\Store\LICENSE000 If that doesn't work remove the Citrix client, install the latest Citrix client and then try again.

You can't use them on the Selection Criteria screen but you can use them at the bottom of the Database Grouping screen in the Group Selection box. This box works very much like the Selection Criteria screen but is for summary fields included in your groups.

If you have multiple earnings codes you will have to do a "hidden detail" report. Insert a footer for each employee Sum each column Insert the name into the footer Hide the details on your report (Format » Section » Detail » check Hide Section) You will have to do some clean-up of the...

When you say "in ADP" to which ADP product are you referring?

This Derived Field should do it for Oracle users: ROUND(field_name_here + 500,-3) Tim I know nothing about MS SQL but it should be similar to one of these.

This Derived Field should do it for SQLBase users: @ROUND(field_name_here + 500,-3) Tim

Charles, I work at ADP; not in the ReportSmith dept but help them out sometimes. The export limitation numbers I posted came from our internal knowledgebase.

I believe the export (Save As) limits for ReportSmith v4.2 are: Excel (XLS) = 16,310 records Comma Delimited (CSV) = 31,999 records Data Interchange Format (DIF) = 65,000 records So if your report is under 32,000 you can save as a CSV and if under 65,000 you can save as a DIF. Since Excel...

“When attempting to link tables in the ADP company level jobcode table to the employee job table via jobcode by "edit(ing) the SQL" query in the report. When we added our linking to the from clause of the query, as you can do in true SQL (client and I are SQL people, not Oracle), it failed with...