Monthly Summary Report

[AnthonyDixon]

I'm trying to create a summary report by month, But I need to display the month header even

though there are no records for that particular month. Here's what I have so for, but I a little

stumped on how to get all months to show.

Thanks in advance!

Anthony

Monthly Summary Report 2.fp7.zip

[comment]

You cannot show something you don't have. You will need to add a table of months. How many months at most will you report on?

[AnthonyDixon]

All 12, January - December

[comment]

Well, then you only need 12 records in that table, and a global field for the year. Unfortunately, your report must use either portals or calculation field/s to list the actual transactions.

There are other options (such as calculating fake "headers" for the missing months, or using a reporting table with dummy records) but I believe this would be the simplest one.