Topic: Insert/Update a column value of report to OracleDB Posted: 01 Apr 2011 at 3:44am
Dear ALL, I am a newbie in crystal report.Please help me Problem: Currently when user download the crystal report in excel ,there exist a blank column.
Fields DATE , TIME , NAME , REASON, NOTE Here REASON and NOTE fields are often empty.
Requirement: user need to update the blank value in database. Is it possible to have the row updated by a combo box in crystal report ? or update in Oracle database from download excel files???
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 04 Apr 2011 at 3:38am
CR doesn't update the database. You could have a stored proc that pulls the data update it at the same time, but I personally, don't like to have reports change data.
As to the updating when the excel file is created, would again go against the export routine, and I don't know if you have access to that.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
