Link to home
Create AccountLog in
Avatar of radersolutions
radersolutions

asked on

Crystal Reports - filter by user input

I created a Crystal Report and it prompts the user to choose the date they want to start from.  Ex. Show me when someone changed this field on or after the date they select.  I cannot seem to have it filter for the date range.  It is returning every time the field was ever changed (not >= the date the user selected.

How would I filter the results based on the user input
Avatar of dougvarga
dougvarga
Flag of United States of America image

Paste your record selection formula
That should have read:

 POST your record selection formula!
Avatar of radersolutions
radersolutions

ASKER

I have a parameter named @AsOfDate
I tried going to Report>Select Expert and tried making a formula {Audit.AuditDateTime} => @AsOfDate, but it does not like that.  I want the results of the report to filter all changes made on or after hte date selected by the user.  

(I am a beginner for Crystal Reports)
parameter.bmp
Ok.  Goto the report menu --> Selection Formulas --> Record

Then post what you see there.
{Audit.AuditType} = 51

This is a filter I already have in place to only return that specific audit type
ASKER CERTIFIED SOLUTION
Avatar of dougvarga
dougvarga
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This worked!  It looks like i was forgetting the part Date(...).  Also, I am getting a 9 duplicates of each result.  Is there a way to not filter for duplicates?
Perfect!  Any idea how to not show duplicates?  
9xresults.bmp
Goto database --> Select Distinct Records