Editing reports in k1000 using SQL workbench
Hi guys
Need a little help. I would like to edit some reports that I
created in the k1000 using an sql editor...(Workbench to be precise).
I have connected successfully but cant seen to find the report to
edit.
I am not an sql guru, and haven't worked with it in a while... but I
have used it before.
Any one know how to edit reports or any other schema in the k1000??
Where are they located?? Cant find them in the KBSYS or the ORG1.
Thanks Guys.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
You can't edit the reports directly in the database. Open the report in the web interface and copy the SQL query to Workbench. Once you have made the necessary changes, either paste them back into the original report or create a new SQL report in the reporting module.
Reports are stored in the SMARTY_REPORTS table so if you really want to pull the query directly from the table that's where you'll find them.