Report Monthly Count

[ssaucedo]

I need to create a report that shows by month how many records are created and modified based on date fields.

Not quite sure how to approach this?

I how do I get FM to count something that is a date field. Do I have to create fields for every month? Jan-Dec?

As you can see I have no idea how to get this off the ground.

Would really appreciate some help my boss wants this info by next Wed. Hope this is not a difficult and involve process.

[Fitch]

Create a calculated field: Month( yourDate )

Then create a subsummary report using that as the break field.

Create a summary field: Count(ID)

Where ID is some field that always has a value. Put that on the subsummary part along with your month calc.

[ssaucedo]

So what I am doing now is searching each field, say "Accept", by a date range, say e.g. 05/01/07-05/31/07, and by type say type A.

Then I take the number of records returned and type that into an excel spread sheet that is for the month of May 07 showing how many of each colum/category and by type (a, b, c etc.)

I really want to automate this and if I can put it all into a layout and just click a button and print that would be great.

Monthly.fp7.zip

Edited November 20, 2007 by Guest