Can CR XI be used to update a table?

[Dom71555]

Hello All,
I need to create a template that has many values a user can select. I would like to incorporate the use of "check box's" but I am not sure if Crystal supports this.
By selecting one or more of these check boxes, I would like to update a SQL SERVER table with the values selected.

Is this possible?

 

[IdoMillet]

Not possible unless you add a 3rd-party tool or create your own UFL.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

Ugdating a SQL database can be done with a stored procedure in the crystal report. The SP must have at least 1 select statement in it. After that it can do anything.

Not sure on the checkboxes, but you could certainly use parameters with drop doen lists.



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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Dom71555]

Thanks IdoMillet, dgillz. What I need to do here is create a from that elementary school teachers can check different standards as the year goes on, thereby tracking a students progress. I wanted to create the form with checkboxes so I can store their selections in a table.
I'll play around with the stored procedure idea.
Thanks again!