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 Rhinorhino 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. brianewo

    Printing report selection criteria and listing any drieved fields

    Is there a way to print a report's selection critiera, derived fields, report vairables and the names of all the tables that are used along with each field. With out maybe copying the SQL statement to a notepad doc and editing out what you don't need?
  2. brianewo

    Oracle vs. Access

    Pbowen, here is an example of a simple decode statement using the oracle version or reportsmith: DECODE("PS_JOB"."EMPL_TYPE",'S','Salary','H’,'Hourly') The Xlattable table that holds all the description, doesn't have a value to translate Empl_Type. Therefore IF you want...
  3. brianewo

    Report Variables

    To go along with Charles suggestion. Depending on how many line numbers there are. you might want to make a seperate report that list these. That way they will know which ones they are selecting. I find this helpful when I have a LARGE list of values, and I can't remember what all the values...
  4. brianewo

    using the CHART feature in reportsmith in a hosted enviroment

    Well all it took was for ADp to loadit on THE server. and that was about it.
  5. brianewo

    Macro creationg

    Are you tracking total wages over multiple weeks? If so you can use this derieved field to sum the wages over and then only have one row of data for the emp. SUM("PS_AL_CHK_DATA"."CK_GROSS") that should get you what you want
  6. brianewo

    using the CHART feature in reportsmith in a hosted enviroment

    I have tried to use the CHART function in reportsmith, but i get the error message that i need to open Word and install the Chart 97 feature. Well this would work just fine IF i wasn't in a hosted enviroment. My database os located on the severs at a ADP location. because of some liscening...

Part and Inventory Search

Back
Top