retrieving last year data today

building reports crystal reports
1

I need to be able to retrieve data in my Crystal report for December last year. What will be the best possible way to do this as I dont want to hardcode any variables as this report will be run at each yearend ie Jan, Feb the next year.

ghexham (BOB member since 2012-02-21)

2

Welcome to B:bob:B!
Retrieve the year from the current date and use year-1 (the previous year) and month = Dec/12 in your report selection criteria.

Jansi :india: (BOB member since 2008-05-12)

3

Thanks for that. Its just that I didnt want to hard code any months

ghexham (BOB member since 2012-02-21)

4

I agree, but 12 or Dec is not hardcoded. It is always the last month.

Jansi :india: (BOB member since 2008-05-12)