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


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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


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.

Answered 11/19/2015 by: chucksteel
Red Belt

Please log in to comment