Page 1 of 1

MMB with MS SQL Server Table data report print

PostPosted: Thu Oct 04, 2018 7:04 am
by arifbsn
Hello everyone,
I hope you are passing good time.
I have a plugin ODBC 1.0 and its very usefull to connect MS SQL Server Database and support all queries as well. But I can't print database table data as like crystal report.
Anybody can make a plugin like Crystal Report or Fast Report to view SQL Server table Data?

Thanks all

Re: MMB with MS SQL Server Table data report print

PostPosted: Thu Oct 04, 2018 7:12 am
by dgilmour
You can make HTML page containing report data and print it. I doubt anyone will write plugin now.

Re: MMB with MS SQL Server Table data report print

PostPosted: Thu Oct 04, 2018 7:26 am
by arifbsn
Thanks dgilmour,
There are a lots of data in different table. How can I make multiple page range in HTML like page 1, page 2, page 3, page n with header and footer?

Re: MMB with MS SQL Server Table data report print

PostPosted: Fri Oct 05, 2018 3:55 pm
by dgilmour
I believe it can be done with, for example, JavaScript? I know it may seem a bit difficult, but I'm sure you'll be very satisfied when you'll solve it. ;)
If you able to select data from the table then no problem to format it with some scripting.

Re: MMB with MS SQL Server Table data report print

PostPosted: Wed Apr 24, 2019 6:29 pm
by Nigg
You can write a html file with MMB which contains all data from the database. Then just add a javascript plugin like this:

https://datatables.net/

to the html content. No need to build a page navigation yourself.