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 strongm 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. Jameson55

    how to display running total on page/group header

    Unfortunately, the printed report has to exactly match the format from the union, so I went the "subreport" route and it worked just fine. Thanks for your help. Jamie
  2. Jameson55

    how to display running total on page/group header

    oooh- I was afraid that was going to be your answer. This report was created to replace a pre-printed form used to calculate and pay our union workers fees and dues based on the number of hours worked. The detailed information was listed after the totals. It was a really great report until...
  3. Jameson55

    how to display running total on page/group header

    This doesn't seem to work for placing the running total in the Report Header. I can show the total at the end of the report, but not at the beginning (where the summary information is located.) Any ideas? - Jamie
  4. Jameson55

    Another date range problem

    YEAH! That did it! Thanks for making me look like I know what I'm doing! It only required a bit of tweeking in order to make the VP of HR happy. thanks again - Jamie
  5. Jameson55

    Another date range problem

    Sorry for the confusion. Your solution will work, but only if I know ahead of time how many years are involved. Maybe I can make this clearer by illustrating how the results will need to be (not necessarily in the proper column format, but hopefully you can follow me): Employee #1- Joe - Start...
  6. Jameson55

    Another date range problem

    I am trying to create a report that will reflect the total number of hours worked by employee(s) for each year they've worked. The fun part is that HR wants it based upon their anniversary date! I can pull the data by the check date, but need to create a formula so that I can group by year...
  7. Jameson55

    Running total in Report Header not showing

    oh geez - how silly do I feel? I had already built the formula to calculate the hours, I simply needed to insert a grand total and then the formula to calculate the cost based on the grand total. Worked perfectly! It's amazing how much it helps to have someone else just open your eyes and...
  8. Jameson55

    Running total in Report Header not showing

    I created a running total and a formula mutliplying that total by a set dollar amount. Both pieces of information display correctly if they are in the report footer. If I move them to the header, they won't display. I've tried using the different "evaluation times" but no dice. I've tried...
  9. Jameson55

    Inconsistant results with if then statement

    Does it make any difference if you enclose everything from the IF statement to the THEN statement in parentheses? -JB
  10. Jameson55

    Fiscal year and weekly totals

    sorry, I forgot that the sales rep number is actually a formulated field pulled out of the line item job cost reference number - that's why I had to use a subreport. THe only way I can see around this is to create a formula with the names "hard coded", but that would mean that it would have to...
  11. Jameson55

    Dear Sir... or is it Madam?

    It depends on the person to whom you are addressing and the content of the message. If it is a "blind" letter to business contacts, it is acceptable to use either "Dear Sir or Madam" or "To Whom It May Concern" (this is used most often). If possible, you might want to address the letter "Dear...
  12. Jameson55

    Fiscal year and weekly totals

    I used your solution from Feb 8, 04 that had me create the forumula {table.date}-dayofweek({table.date},crMonday)+1 and then change the group name as suggested and it worked great! Especially in my cross tab and chart! The only new question I have - is it possible to have a subreport in a cross...

Part and Inventory Search

Back
Top