OK, this is a stupid question but I

[Maker1]

OK, this is a stupid question but I wanted to make sure. Is it possible to enter data into a table through Crystal Reports? I am 99% sure that it is not, just wanted to make sure.

 

[nagornyi]

Yes it is possible. I am aware of 2 ways of doing that.
1) UFLs written in VB or VC++ can provide any imaginable functionality, including writing data back to DB.
2) Report SQL can call DB stored functions, which can not only return values, but also do other things inside them, including writing to DB. This is especially useful when you need to keep track of the last record included in the report (I bet that's what you are trying to accomplish, right?)

 

[Maker1]

Actually, my HR department is wanting to set up a call in phone line for employees to check on when they are to come back from layoff. They want a crystal report that will allow them to enter in information to a table on our AS/400 if the employee calling opts to talk to a live person rather than go through the IVR (which is writing straight to the table.) Is it possible to have them pull up an employee record and then make entries into the table? These would be new entries not modifying existing data. Seems to me that it would be better in Access rather than Crystal.

 

[GMcNamara]

Crystal 9 allows entering your own SQL Commands, which allows you to write directly to the database through the report.

 

[Maker1]

Is the same fuctionality available in 8.5?

 

[GMcNamara]

No.

 

[bdreed35]

If you are asking if someone can open a report, and then enter data, and have those changes update the database then the answer is NO.

~Brian

 

[GMcNamara]

bdreed35,
Be careful with your blunt answers. In CR9, you can update the database through an SQL Command. Crystal has not become a fancy data entry interface, but YES you can open a report, enter data (through a parameter), and have those changes update the database.