Hi, all;
I created a basic Macro Derived Field that works fine and gives the correct result in its own column – Good.
But: that Macro Derived Field doesn't show up as a regular Selection or as a Database Grouping Selection, nor is it an option to Sort by.
While it's nice to see the column, it'd be nicer if I could filter down by it. Is there a workaround?
I’m on ADP Enterprise, Reportsmith 4.0 – SQL and here’s my basic Macro :
Sub count()
x=(SumField$("AL_EMPL_STATUS","PS_JOB",1,"Count"))
DerivedField(x)
End Sub
ThanX !
I created a basic Macro Derived Field that works fine and gives the correct result in its own column – Good.
But: that Macro Derived Field doesn't show up as a regular Selection or as a Database Grouping Selection, nor is it an option to Sort by.
While it's nice to see the column, it'd be nicer if I could filter down by it. Is there a workaround?
I’m on ADP Enterprise, Reportsmith 4.0 – SQL and here’s my basic Macro :
Sub count()
x=(SumField$("AL_EMPL_STATUS","PS_JOB",1,"Count"))
DerivedField(x)
End Sub
ThanX !