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
How would I filter the results based on the user input
Crystal Reports
Last Comment
dougvarga
Paste your record selection formula
That should have read:
POST your record selection formula!
POST your record selection formula!
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
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.
Then post what you see there.
ASKER
{Audit.AuditType} = 51
This is a filter I already have in place to only return that specific audit type
This is a filter I already have in place to only return that specific audit type
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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?
ASKER
Perfect! Any idea how to not show duplicates?
9xresults.bmp
9xresults.bmp
Goto database --> Select Distinct Records