Hello,
I have recently made crosstab query/report which helps me in my every-day
work but it is not fully complete. This is one example of my report:
Basically, function of this report is to show much money is spent on car repairs monthly.
This is how Sorting ang Grouping option is set (for both rows option "Group footer" is set to Yes):
http://img830.imageshack.us/img830/3831/541653.jpg
This is how I would like my report to look like:
I am note sure is it possible that *if* there was only car repair for one Car Type *then*
report should show only one row (total row - footer of Car Type with total sums) and in case
there are *more than one* type of car (of some brand - for examp. Audi) on repair then it
is OK to show both rows (footer Sum of Car type AND Car Brand)?
Any help is appreciated and many thanks in advance for prompt replys!
Cheers
I have recently made crosstab query/report which helps me in my every-day
work but it is not fully complete. This is one example of my report:
Basically, function of this report is to show much money is spent on car repairs monthly.
This is how Sorting ang Grouping option is set (for both rows option "Group footer" is set to Yes):
http://img830.imageshack.us/img830/3831/541653.jpg
This is how I would like my report to look like:
I am note sure is it possible that *if* there was only car repair for one Car Type *then*
report should show only one row (total row - footer of Car Type with total sums) and in case
there are *more than one* type of car (of some brand - for examp. Audi) on repair then it
is OK to show both rows (footer Sum of Car type AND Car Brand)?
Any help is appreciated and many thanks in advance for prompt replys!
Cheers
Last edited:
