Specific Months

[olushow]

I want to know how to pull data for a all the months so far this year meaning April, March, February, and January. As well as December,November and October of last year. The tricky part is that I have 4 sub-reports that need to pull information based on this criteria. This is a one time report, meaning I don't have to run it again. I already have a monthly report that pulls from the previous month, but when I tried to modify it, it gives me wrong data.

{Datefield} in LastFullMonth) - This obviously gives me data for the previous month, but what if I want to pull specific month/year data, can anybody provide any advice.?

Thank You.

SQL Server 2005
Crystal reports 10

 

[Charliy]

The easiest way is to add date parameters. Then you juse select on {table.date} in {?BeginDate} to {?EndDate}

 

[olushow]

Thanks for your response. The tricky thing is that the main report is not really the issue. I have four subreports within the report that need pull that data. How can I use your suggestion for the subreports?

 

[Charliy]

Use those date parameters as the links to the subreports.