How do I create a report using SQLite3 DB? I'd appreciate just step by step or pseudo-code.
+3
A:
That's quite a big open-ended question. SQLite is really the built-in REALSQLDatabase class and it inherits from the generic Database class so it works just like every other database class in REALbasic.
There are numerous ways to do a report in RB. The first way is to use the built-in reporting tool in REAL Studio itself. Look for examples in the Example folder that comes with RB.
You could use RSReport from Roth Soft available at http://www.rothsoft.ch/realbasic/rsreport/
You could use On-Target Reports at http://www.ontargetreports.com/
That doesn't answer your question directly because those are the tools involved. Each tool has its strengths and weaknesses so you should check each of them out.
There are tutorials available for all of these tools in the Association of REALbasic Professionals (ARBP) source code repository at http://arbpmembers.org (free registration required to access the repository).
BKeeney Software
2010-05-14 16:12:21
Hello I appreciate your response. I don't want to purchase any additional software. I have MBS and RStudio 2010 R2.The example project uses Dim rpt As REALDatabaseIm using SQLConnectionMBS to connect to my DB. All I want to to is display fields from my DB and allow the user to print it. I'm just seeking something that's quick (no runtime calculations or fancy conditional statements to determine if the data should be displayed). I want to say "SELECT * FROM tblUsers" and then get the data using cmd.Fields("field1").asStringValue to some how bind it to my Report fields.
Cocoa Dev
2010-05-14 17:36:41
Did you look at the REAL Reports tutorial on the ARBP site? And you do NOT need the MBS plugin to connect to an SQLite database.
BKeeney Software
2010-05-14 19:31:33
ARBP is blocked by WebSense :(
Cocoa Dev
2010-05-26 00:22:49