Avatar of techitch2
techitch2Flag for United States of America asked on

Crystal report date range

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?
Crystal ReportsMicrosoft SQL Server

Avatar of undefined
Last Comment
techitch2

8/22/2022 - Mon
vasto

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 McCracken

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
ASKER
techitch2

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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
techitch2

No they do not.  Here is what they consist of (attached)
Capture2.JPG
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
techitch2

I was afraid of that.