Can I create a generic group separating by month?

[pokerace]

Is there a way to create a generic group of months so that I can then link each grouped month to a date field in a subreport so that the subreport will only show data for the grouped month?

 

[synapsevampire]

Why do you need a subreport? Rather than trying to specify an architecture, you might consider explaining what you have and what you need:

Crystal version
Datqabase/connectivity used
Example data
Expected output

You can just insert the date as a group within the subreport and select section will be grouped for each month.

Then in the record selection formula you can limit the rows being used in the report to whatever months or date ranges you want. An example for months might be:

month({table.date}) in [1,2,3]

That would return the first 3 months and group accordingly.

-k

 

[lbass]

You could create a formula like the following in both the main report and the subreport:

month({table.date})

And then link the subreport to the main report by linking the two formulas. I would also advise linking based on a year formula:

year({table.date})

-LB