Automatically adding parameters from a table.

[chrishorn]

I tried searching to see if this topic was already covered but was unable to find it.

My issue is that for one of my parameters I want to have a choice list generated from a table in the database. When a change is added to the table it has to be manually readded to the "Default Values" list box from the choice list box. I don't want to have to manually make this change and send the report out to hundreds of users everytime a new entry is added to the database.

Are there any programatic or other work arounds?

 

[IdoMillet]

Have a look at the list of 3rd-party tools at:

http://www.kenhamady.com/bookmarks.html

One option is to use "cView Pick" from Chelsea Technologies:

http://www.chelseatech.co.nz/ctprod.htm#cViewPICK

Another option is to use my DataLink Viewer:

http://www.milletsoftware.com/DataLink_Viewer.htm

Ken Hamady has a free e-mail Newsletter you can subscribe to at:

http://www.kenhamady.com/news.html

His June 2003 issue discusses exactly this issue.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com