How to put the parameter field in select expert?

[EngJoo]

Dear all,

i am on the beginning stage of using CR8.0. I come across a parameter field function and started try to use it.

For my previous practice, i am using the select expert to choose the date range of the report that i requested.
It is too troublesome for my user to change because i have many selection on the select expert. Sometimes it really confuse them.

and i am so happy to know the usage of parameter function. but i am not familiar how to perform it.

i have created the parameter for create_date.Eventually the report doesnt show the period that i chosen on the ENTER PARAMETER FIELD interface but includes all data.

So my question is can i or how to put the parameter field into the select expect.Like what i did last time. If it is can, then i am really happy. if not Thank you for your advise.

 

[dgillz]

Personally, I NEVER use the select expert as it just restricts me on what I can and cannot do. This is a perfect example of this limitation.

Click on report, edit selection formula, record, and write your selection formula manually. The parameter fields should show up on the left side as available objects.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[EngJoo]

Dgillz,

Thank you for your advise.

can you brief me in detail?

Is it once the date range been chosen in the parameter field, the execution will be same like the select expert?

Awaiting for you reply.

Regards,
Andrew

 

[EngJoo]

what i should write on the formula. so that i choose the date range on the ENTER PARAMETER FIELD interface. it will pass it to the formula.

i write it in this way.but prompts error.

{prospect.create_date} in datetime({?Create Date}) to datetime({?Create Date})

Please advise.

 

[EngJoo]

Finally i should be able to resolve my problem
by writing the formula as

{prospect.create_date} in minimum({?Create Date}) to maximum({?Create Date})

Thank you Dgillz at the first place.

how to put default date in different date range on ENTER PARAMETER FIELD interface?

 

[dgillz]

Actually your formula can be this:

{prospect.create_date} in {?Create Date}

The above assumes that {?Create Date}is a date range parameter and that {prospect.create_date} is a date field.

As to your last question, I am unsure what you mean. Can you explain a little more?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[EngJoo]

Sure.

in the ENTER PARAMETER FEILD, there is start date range and end date range.

basically i have set the default date into it. But what i want is start date range is in one date whereas end date range is in another date.

Please advise.

 

[dgillz]

I just tested this and I don't think there is a way to do this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[EngJoo]

Thank you so much..i am so happy.