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
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...
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
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
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.