We help IT Professionals succeed at work.

Crystal report date range

85 Views
Last Modified: 2016-01-15
Let me preface this that I have little to no Crystal Report training, however I have been able to tweak reports and convert reports for our new ERP.  I have an existing report that shows a list of vendors and dollar amounts from "this year" and from "last year."  The report pulls from two custom views that were created for us (ap_ytd_purch.amount and ap_lstyr_purch.amount) and also pulls vendor name from a table (apvenfil_sql)  What i want to be able to do is ask the report for a date range.  So I've created a Bdate and Edate in the formula fields and tied them to a parameter.  I know I'm missing something but for whatever reason I can not think of it.  This is not working.  It shows me the same data no matter what dates i enter.  Any help?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2011

Commented:
You need to create parameters and use them in the record selection formula. Here is a video showing the process
https://www.youtube.com/watch?v=NkmXGu2fqF8
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you using the views as the data source or did you build a COMMAND?
If you are not sure look at
Open the report
Click DATABASE --> DATABASE EXPERT
Do you see a list of tables/views or do you see a single leaf in the tree?
If a single leaf if you right click it do you see EDIT COMMAND and VIEW COMMAND?

mlmcc
techitch2Network Admin

Author

Commented:
Vasto, That was great info but there is no date fields to associate the parameter too.

mlmcc, These are part of the database.  I am adding a screenshot below.
Capture.JPG
Capture1.JPG
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
techitch2Network Admin

Author

Commented:
No they do not.  Here is what they consist of (attached)
Capture2.JPG
CERTIFIED EXPERT
Top Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
techitch2Network Admin

Author

Commented:
I was afraid of that.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.