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,431 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

724 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