In this article I will take you step by step through the process of creating a custom, but simple, report on a Kik messenger database using the Forensic Browser for SQLite.
As we work through the process we will chose which columns we think will be useful in our report and modify our report by creating simple visual SQL joins on different tables displaying numerics as timezone adjusted dates and importing pictures saved in external binary PLists.