Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • Last Modified:

Crystal Reports data selection

I have a Crystal Report that pulls from a table that has columns for 1.) Accounting Period and 2.) Accounting Year.
I need to be able to set a parameter for both of these (ex. 05/2016) and have the data from all previous periods populate the report.  What happens now is that if I select period 05 and year 2016.  It only populates with data up to period 05 of every year.
How can I fix this?
0
slmc
Asked:
slmc
1 Solution
 
vastoCommented:
Do you have a criteria for the year  in record selection formula ?
Something like <your year field> = {@year}
0
 
mlmccCommented:
Try this

(
{Accounting Year Field} = {?Year}
and
{Accounting Period} <= [?Period}
)
OR
{Accounting Year Field} < {?Year}

mlmcc
0
 
slmcAuthor Commented:
Exactly what I was looking for.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now