We are looking for a way to replace standard database queries with calls to LiveReports. We need to do select, update and inserts to custom developed database tables. Is there any way to do this with CWS calling LiveReports with input parameters?
I am also interested in this topic. Instead of CWS, is there a way to call livereport from JavaScript?
Or in general, is there a way to update/insert data into content server custom table without back end programming or direct database talking (which requires odbc driver)?
Do we have to use a form template table to be able to submit data into the table?
If you have a parameterised LiveReport that the user has access to run, you can certainly create its URL in Javascript and just call it using document.location or window.open etc
We are wrapping livereport with webreport and call them from js using ajax like:
/OTCS/cs.exe?func=ll&objAction=RunReport&objId=123&prompting=done&nextUrl=
It produces html as output.
HTH
What is the need to replace the standard query with Livereport?
There should be a couple of samples on the CWS forums, for both Java and C#, for how to provide the correct data input arrays for runReport(), in CWS. If you're consuming just the webservice through something like a SOAPUI, you may find it difficult to provide input, as you cannot modify the backing store.
If you want to hit an external database, you can still do that, as LiveReports don't have to hit just the local CS databases, as they can be provided an external connection (LiveReport forums should have a few topics that covered this).
Further, if you link an external database to your CS database, then you don't need to do much in your LiveReport in order to query it.
My client has normal users to upload list of data into a custom table of CS server each month when they recevie the list from another department. We od have a applicationfor this task and it calls the standard query. Everytime when client IT decides to upgrade their PCs, we have to make sure the ODAC driver is installed and working with the applciation on user PCs. Often it will cause some problems. If Livereport can be called to insert the data, then I can deploy a html page in the CS server to parse and upload the data. This way, there is no need to worry about the system upgrade problem any more.
BTW, in the end, the .exe application is still kept and updated to use managed driver (Oracle database). Now the driver dll file is deployed together with the exe file.
