Specific data ( date range) to display 1

[Shusha]

HI,

Is there a way that i can run a report based a date range by using the parameter field values.?

Right now I have to go into the SELECT EXPERT to keep changing the dates every month - i.e. start date of activity and end date of activity..

I wld like the parameter box to come up and for the user to answer the question , "What specific dates are you looking for ?" - and for those dates from a specific field in the report ( called Activity date time) to display the data.

Right now, by using the select expert, i can get that. but it is a nuisance. Also i want the requested date ranges to be printed in the report header? I know this is possible. but am too sick to spend time figuring it out. So any pointers wld be wlecome.

Thanks

Usha

 

[rosemaryl]

Dear Ushameister,

I am assuming CR 8.5.
This is very easy.

Create either one Date Parameter of Range Type or
2 Date Parameters. (From Date - To Date). The choice is yours.

Here are the steps for the Range Style

Insert/Field Object

Scroll down and choose Parameter

Click New

Name it DateRange

In the prompting text type: What specific dates are you looking for?

Choose Value Type and click the drop down and select Date

Click Range

Click ok.

------
Now in the select expert use the following formula:

//change the table field to yours.

{MyTable.MyActivityDateTime} in {?DateRange}

Refresh your report. You will be prompted to enter dates for your date range parameter. Do so and click OK. The report will run as you need.

----

To display the values chosen on the report create the following formula (obviously change the text and fieldname to match your data and requirements)

"For Dates Chosen from " & minimum({?DateRange}) & " to " & maximum({?DateRange})

This formula, when placed on the report will show the dates chosen in the lower bound and upper bound of the date range box.

I hope you feel better soon, please let me know if I can be of any other assistance.

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Shusha]

Hi Ro,

Thks for ur help. U are truly amazing. I was almost there. You know I had done this before, but completely forgot how-to now. Your help is greatly appreciated. This forum is awesome. There are times when it takes away half the worries when u are stuck with something as there are so many experts here who give their help so selflessly. YOUr tip on how to add the date range as part of my header worked beautifully. I sis not know hot-to do that. So in all this is a great tip u gave me and I thank you from the bottome of my heart.
I am recovering from an emergency female ( major ) surgery and there are times when i just forget the whole thing and then it comes back to me, but then i have already wasted so much time. that is why I find thisforum so useful as it jogs my memory pretty good and i find it immensely useful.
Thanks agai Ro.

Usha

 

[rosemaryl]

Dear Usha,

I am happy to help you any time. I wish you a very speedy recovery.

Best regards,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.