Date Parameters

[GerberGirl]

I am a new crystal user and am really bad at formulas. :-(

I am trying to create a Date Parameter that allows the person accessing the report to select his or her own date range.

I am sure it is pretty simple, but i can not get it to work.

Any advice?

 

[synapsevampire]

Create a date range type parameter, make sure you check the Range option.

In the record selection formula (Report->Edit Record Selection->Record) place something akin to the following:

{MyTable.DateField} = {?Daterangeparameter}

Adjust the names accordingly.

-k

 

[GerberGirl]

Thank you very much for your reply.

My next questions is what exactly should the {?Daterangeparameter} be looking at?

My report is based on info in Track IT and is looking at all completed calls, so should i just select the date field that i want to base the report on or do i need to create a new formula?

 

[synapsevampire]

{MyTable.DateField} = {?Daterangeparameter}

{mytable.datefield} is the date field in your database.

{?Daterangeparameter} is the date range parameter you created.

-k

 

[GerberGirl]

Hello again, maybe i didn't explain my problem correctly. When i create a {?Daterangeparameter} and then save it, when the users open the report, they do not get prompted to select the dates needed, instead the report just opens with the dates i have put in the {?Daterangeparameter}

Thank you for being so patient.

 

[GerberGirl]

Actually i have just managed to find my problem. Thank you very very much for your help.

You are the best