Search results for query: *

Thanks for looking into it Charles! What a shame! The Second big code block in my first post is an example of one of the macro derived fields, some are more complex. I probably should learn SQL well-enough to do the translation, sometime... I called ADP, and, no surprise, they do not support...

They look perfect. Drat. I removed "#FileNumber" from the print command within the conditional. The output to the screen was perfect! I removed the "#" and got perfect output to the screen, with a "1" at the beginning of every record. I tried replacing the "FileNumber" variable with "1", and...

Hi Charles, I went through them all, and the only fields that cause the error are Macro-derived fields, any of them. I tried Printing a macro-derived field result outside of the loop, right after the "GetRandom 1", and it gave the same error. Are you supposed to be able to deal with...

Hello hello, I went to run a macro to produce a csv file like normal and I got a "Bad File name or number" error, and the file was only created with the headers. the macro is as follows: Option Explicit Sub ProbToCSV() Dim today as string today = format$(Date$, "medium date") Dim Filename...

Ok, so the Field "TERMINATIONDATEROE" can't just be included "For Query Only".... Problem Solved.

Please post your derived fields, so we know what we're dealing with. thx

... I've also just tried: If (IsNull(Field("TERMINATIONDATEROE")) = (-1)) Then DerivedField "-" Exit Sub End If at the very beginning of the macro, with the same result.

Hello all! (RS V4.2, ADP SQLBase) I have a simple Macro-Derived Field to format termination dates into the "Medium Date" format. The code is as follows: Sub TermDate2() Dim TermDt TermDt = Field("TERMINATIONDATEROE") Dim TermDt2 as string TermDt2 = Format$(TermDt, "Medium Date") DerivedField...

oh man. I'm using the Code in that PowerPoint for EVERYTHING now! I'm making the files .csv, and linking it to after report run. Now i can open the report, close reportsmith, and the data I want is in a tiny CSV file, where I want it. I'll never have to open an excel-formatted report from...

Thank you for the PPS, That gives me some ideas about using ReportBasic to create other files, record-by-record. I've stuck with the SaveReport command in my ReportBasic macro, and just added the Header fields to each record(in the body of the report). It turns out that with those fields...

The SaveReport command doesn't include Headers when it saves the report. Is there a way to include the headers, like it does when you save as excel to the Catalog? Thank you!

I want a macro to save the report as an excel file but when i test the macro, it tells me there's a syntax error on the SaveReport line. My macro script is as follows: Sub saveasexcel() Dim Sitenm as string Dim Filename as String Dim Num as variant Sitenm = Field("site") Filename =...

Sorry, that was unclear. I want to select for checkview paydates between the dates 3 days before the report is run to three days after the report is run. So far I have Macro derived fields which return the date of 3 days previous to the report's run-date, and three days after. I have tried...

I have two derived fields which return strings containing the date three days prior to the current date and three days after the current date. they are strings in the format that the Selection criteria uses when it's in SQL. I have linked the macros to Before the report opens, but I still get...

Shoot! Of course! Thanks for your help, that solved it.

Thanks for your time, I don't understand what you are saying about the file_nbr and PAYGROUP, I can't find this field or table (but I now suspect it's neither!). Please alleviate my curiosity if you can. The "Include Unmatched Records" thing sounded very promising, but alas, yeilded no change...

SO I'm writing a report that needs to list all my terminated employees,(selected FOR in the selections) and tell me whether they have any thing accumulated in a couple of accumulators. I notice that the link: V_EMPLOYEE.FILE# = V_YTD_ACCUMULATOR.FILE# Causes those employees with nothing in...