Hi,
I am running monthly budget-to-actual jet reports for each of our departments, where managers are required to comment on any account that is 10% and $10K over/under budget (both for the month and year-to-date). The report automatically generates a row for each account and shows a "Review" tag at the end of the row if comments are needed. Is there a way in Jet Reports to show a (1), (2), (3), etc. and then at the bottom of the page, automatically generate a few lines for each corresponding numbered variance so that the managers can just type in their comments directly?
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Interesting.
I haven't tried anything like this myself, but I would replicate the key formulas that are used to show the information normally, for your comments. I would then use some sort of formula to generate the (1) number in both places, such as a =rows() with a subraction so it can be automatically calculated. I'd finish it with doing a conditional hide on the comment rows where they do not require comments.
cheers, Mark
Please sign in to leave a comment.