Solved

crystal reports date parameter - how do I get a report to ask for a date range, then select records based on that date range

Posted on 2008-06-13
4
3,425 Views
Last Modified: 2013-11-16
Crystal Reports version 12
How do I get the report to promp for a FROM DATE and TO DATE at run time, then select transaction records that fall between these dates?
0
Comment
Question by:dragon_au
  • 2
4 Comments
 
LVL 4

Expert Comment

by:habibb
ID: 21777206
if you have created 2 parameters i.e. fromdate and todate then crystal report will ask you to provide values for fromdate and todate parameters but my recomendation is you should get values by having your own parameter input page. if you have succeded to get parameter values from user  then by using record selection formula editor you can write as

{yourtable.datefield} in {?fromdate} to {?Todate}

it wil only print those records which will fall in user provided date range.
0
 

Author Comment

by:dragon_au
ID: 21777242
How do I  "get values by having your own parameter input page"?
0
 
LVL 5

Accepted Solution

by:
analliah earned 500 total points
ID: 21778532
{?fromdate} and {?Todate} is a parameter that you create

on you select expert
click new >> choose your date field and on the first drop down column choose
is between
On the right drop down, you should be able to choose the {?fromdate} (first option)
on the {?Todate} as second options

or
{yourtable.datefield} in {?fromdate} to {?Todate} paste this on your select expert
0
 

Author Closing Comment

by:dragon_au
ID: 31466869
Thank you so much for your detailed response. I'm just a beginner at this, and now I understand how to apply this. Thanks !!!!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now