Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: parameters(date range) Post Reply Post New Topic
Author Message
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Topic: parameters(date range)
     Posted: 15 Feb 2011 at 1:41pm
i have a report with a start date and end date paramenter.
 
I want to display services for a certain client for the selected dates.
 
however when i enter the date range it still gives me all the services that were rendered instead of only the dates I have selected.
 
I did it trought the select expert and i choose the date range and it works however when i upload it into the EHR the date range does not seem to be working
IP IP Logged
kpsmithuk
Newbie
Newbie
Avatar

Joined: 03 Feb 2011
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote kpsmithuk Replybullet Posted: 17 Feb 2011 at 4:02am
So your record selection formula will look similar to below?
 
(if {?Customer} = "*" then
    True
Else
{customer field} = {?Customer parameter};) and
 
{date field} >= {?Sart Date Parameter} and {date field} <= {?Finish Date parameter}
 
how is the rest of the report structured and where have you placed the parameter fields? I put mine in the header and use them to form part of the report title so it prompts me when the report is run for the data and selects the relevant data, and then self titles the report

This way they don't need to appear anywhere else as only the selected records will be displayed so I can use the appropriate database fields and summary fields throughout the rest of the report without worrying about the parameter ones.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum