Cross-Tab or Master Detail summary

[cbrydon]

Hi All,

I am trying to create a report that lists types of buildings and totals the estimated value of each building type. An example is below...

Apartment - $1,478,000
Commercial - $9,577,200
Institutional - $4,350,000
Residential - $70,994,00

I was able to do this fairly easily with a cross-tab and also a "side-by-side" Master-detail report.

What I would no like to be able to do is report based on different time periods, perhaps for last week, or August 2012 and so on.
This I can do by adding FromDate and ToDate variables to the report and have a user choose the date range they wish.

The problem I am having is that if I chose to report on the month of February 2013 and there were no commercial buildings erected
in that time period the line for Commercial wouldn't show up in the report, but I would like it to show $0.00 for the month of February.
In essence it would look like this...

Apartment - $1,478,000
Institutional - $4,350,000
Residential - $70,994,00

But I want it to look like this...

Apartment - $1,478,000
Commercial - $0.00
Institutional - $4,350,000
Residential - $70,994,00

If there was a way to print a blank line (or a line with $0.00) in the detail section of a master detail report when there is no detail to show, that would work nicely.
I'd also be quite happy if something like that could be arranged for a cross-tab.

If anyone has any suggestions, I'd love to hear them.

Thanks,
Carl

[HighAley]

Hello, Carl.

Did you try to set the Print if Detail Empty property of the master band?
It will solve your problem.

Thank you.

[cbrydon]

I did try that setting and it certainly prints the master heading, but what I'd like to have happen is have $0.00 printed
in the detail section when there is no detail. Sorry, I guess I didn't make that very clear in my original message.

I've attached a sample database and a couple of reports for reference. In one of the reports, I tried using an
IIF statement to print $0.00 when there is no detail, but that didn't seem to work. Maybe I'm not using it correctly
or in the right place, or maybe its not possible to do what I'm trying

Carl

[HighAley]

Hello.

Please, set the Print If Empty property of the Footer Band to True.

Thank you.

[cbrydon]

That worked nicely - Thanks so much!

[HighAley]

Hello, Carl.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.