Search results for query: *

Create a derived field "A" that counts the distinct paychecks they have already received this year. Then a 2nd derived field (12 - A)

Are you physically dragging the data when you are looking at the report, or are you dragging the detail section in the list? I'm talking about the list of the sections where you link the Detail Reports to the Master.....make sense? You may also have to look at the page breaks for the different...

The following global macro should, in theory, open and print 2 reports in succession. For some reason, ReportSmith prints the first one twice...as if it doesn't clear it from memory. Any ideas? Sub WEEKLY() Dim DB as DataSet DB.Connect 7,"mnwo","USER10","passwd","mnwo" LoadReport...

I responded to this issue in your other post.

Here's the solution: Add the JOB table, but set the Effective Date Logic of the Report to "As of current date". Then go into Selection Criteria and delete the line that sets the EFFDT of the JOB table to be the current date. This is a good way to show history from a table without setting the...

This derived field will rank the rows...then you select which ones you want. I'm assuming that you've added the JOB table to the report and given it an alias of 'J1' (SELECT COUNT(*) FROM DEMOV4.dbo.PS_JOB J2 WHERE J1.EMPLID = J2.EMPLID AND (J1.EFFDT < J2.EFFDT OR...

Change the derived field to read something like this: When the sum is not equal to zero, show the sum. When the sum does not exist, show a zero. CASE WHEN ( SELECT SUM(DED.AL_AMOUNT) FROM DEMOV3.dbo.PS_AL_CHK_DED DED WHERE DED.FILE_NBR=CHK_DATA.FILE_NBR AND DED.PAYGROUP=CHK_DATA.PAYGROUP AND...

OK...adding tables from multiple data sources can be tricky, and perhaps not solvable in an online forum. There is, however, a fairly straightforward solution to using values in a text file as selection criteria. We're going to create a Macro that reads a text file, and then passes the text...

Is there any way that the names could be stored in an Excel file? That will make things really easy.....

Please give an example of starting data, expected output, and actual output. What do you see in ReportSmith, and then what do you see in Excel.

DED is the alias (or nickname) that you're assigning to PS_AL_CHK_DED. Since we're referencing the table, and not physically adding it to the ReportSmith report, we're just assigning the alias in the derived field. The alias is only local, however.

While I know nothing of Maximizer, I can tell you that ultimately what matters is the SQL that is generated by ReportSmith. You need to determine whether the data fed to Maximizer is making it the final SQL statement. That might help your analysis of the issue. Meanwhile, Using ReportSmith's...

What's in the Selection Criteria? What's the SQL that ReportSmith generates?

OK....I worked out a pretty neat solution to your report. 1. Add PS_AL_CHK_DATA (alias of CHK_DATA) to the report. Include PAYGROUP, FILE_NBR, CHECK_DT. 2. Select a specific CHECK_DT in Selection Criteria by hard coding a date, using a report variable, or you can even use the following...

That's not a problem. I'll give you the code tomorrow morning at the latest.

Try this: (end the if statement before the derivedfield statement) Sub Job_Title() If Str$(Val(Field$("PS_JOB.DEPTID"))) = Str$(0733118200) Then D = "CMP"+Str$(Val(Field$("PS_JOBCODE_TBL.DESCR"))) Else D = Field$("PS_JOBCODE_TBL.DESCR") End If DERIVEDFIELD D End Sub

Hosted ADP client? First of all.....it looks like you are trying to add up all the deductions from all of the checks in a given month (the month of a certain check) If that's the case, then you want to get rid of the DISTINCT from your CASE function. If 'X' was taken out of 4 paychecks, and...

Depending on which version of Oracle you are running, you can actually use CASE.

The LoadReport function only seems to pass ReportVariables if they are strings values.

Clyde, Did you get the reference material you were looking for? Matt Waugh (remember me?)