Parameter help, Street address problem 1

[ziggs]

The addresses in the database that I'm tring to write to is like this:

digits, Street Direction, Street Name, Street Type, and Apt.

Now, I created a formula that combined all and called it @Address and I'm using the starts with command in the Select Expert to perform Searches. Unfortunately, I'm about to give this to others to use and I don't want to confuse them with five separate field queries. So, I want to create a parameter off of the formula field, @Address, as opposed to every individual field in the DB (digits, Street Direction, etc). Is there a way to do this? I'm using CR 8.0 and it looks like I can only point to the database field names as opposed to the @address formula I created. Thanks.

 

[kenhamady]

You create the parameter and then use it in a formula, like the selection formula. Those fields that are available in the parameter window are only for browsing sample values. They do not link to a field. You will not be able to browse sample values from the formula, but you can still use the parameter with a formula in the selection formula or in the select expert.

My concern is that if you put the digits first, how are you going to do a "startswith". You might need another (invisible) formula to use for selection, one that has just the street or city.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal