Skip to Content
Former Member
May 29, 2013 at 08:37 PM

Need to specify particular query by month


We run Crystal Reports against a very large AS400 (system i) database. We have seen that we can create Views there for our purpose. We have one CR which takes very long time. THe user runs it for various month of the past year. I would like to create views that will hold each month and year.

Can the CR take as a variable which month Query it would use? or is this for the Enterprise?

IOW, if the user wants to see January 2013, they enter that, and the CR should then use this view, "Sales012013'