Need Ideas on a report

[MikeL91]

I need to create a report that shows a tables growth, that I can run once a month. I was thinking of running some counts on a few standard fields like state, city or zip, maybe phones etc. and show a previous qty, a new qty and a percentage.

Does anyone have any helpful tips on the best way to do that, or maybe a better report etc. I was going to maybe run the counts in month 1 and then match them to a count I run in month 2 etc. but I know there is a million better ways, and reports.

need advice.

-Mike

 

[white605]

Not sure what you are trying to achieve, but
if you index on year and month,
in the report set the grouping on year(date)+month(date),
leave the detail band blank,
in the group footer band put the _tally system variable,
set its calculation to count
you will get the number of records sorted by year and month

Again, not sure what info you are trying to get, might want to have a look at the logic to write a comparative balance sheet or income statement for ideas
wjwjr