Hi,
Can anybody point to a library with an example on how to create a pdf with multiple pages from a db file, each pdf having data displayed in tabular form having 10 rows and 5 columns, with A, B, C, D,E as column names.
So, for eg if there are 100 rows in the db file , then I need to create a pdf file from it displaying 10 pages(10 rows per page)with data in same/different column order, having 5 column names A,B,C,D,E...Thnx
3 Little steps:
1) Load data from SQLite using B4X Table (a tutorial is here)
2) Get a bitmap from the table, using B4XTable.mBase.Snapshot
3) Print it using Printing library
I am using Flexible Table.
How can I take 10 snapshots of table(Rows 1-10,11-20,............,91-100) ?
And then convert 10 jpgs to pdf file having 10 pages using Erel's pdf creation?
.....
Maybe take snapshot of complete table and then use pdf.canvas.drawbitmap to pick up appropriately sized(10 rows) source rectangle from snapshot for each page of destination rectangle of pdf. But how can I take snapshot of Flexible Table ?
I tried a while back. But, I guess B4Xtable is not vertically scrollable. It is page based and horizontally scrollable. Vertical scrollability makes flexitable more intuitive.