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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. samsci

    outer joins on more than 2 tables.

    Is it possible to do an outer join on more than 2 tables in ReportSmith? I know the unmatched records does not allow it, but was hoping that it could be accomplished via selections criteria. If it is possible, could someone give an example in sql server. Thanks!
  2. samsci

    creating macros for a crosstab.

    I have 3 fields from a table PS_JOB. They are emplid, deptid and empl_status. Creating the crosstab is pretty easy. I list the deptids and the total number of employees in each deptartment. However, I also need the following. 1). Total active employees in each department. 2). Total...
  3. samsci

    Report Smith and ADP

    ADP delivers ReportSmith 3.11 with their products. Depending on whether you are on Oracle or SQL Server and how your ReportSmith.ini file is setup, you might have to login different ways. Also, be aware of the effective date logic and translate setup. Basically, if you do not have...

Part and Inventory Search

Back
Top