Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Lari2
-
Macro to add Gross Checks together then sort by this field
I have created a ReportSmith report for selected employees and need to have each employees "total Gross Checks" for the period of time that is selected in a Report Variable to be sorted in Decending order. I have set up a Report Grouping by employee name and put the total of checks in...- Lari2
- Thread
- Replies: 0
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
How to display an accumulator if it does not exist for an employee?
All you need to do is a Derived Field with a SUM(DISTINCT DECODE("ps_al_ytd_accum.accum_nbr",'accumulator number',"ps_al_ytd_accum.accum_amount",0)) Also, be sure that you have Database Grouping On.- Lari2
- Post #2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
