MMB with MS SQL Server Table data report print

Multimedia Builder

MMB with MS SQL Server Table data report print

Postby arifbsn » Thu Oct 04, 2018 7:04 am

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
arifbsn
 
Posts: 14
Joined: Fri Jul 29, 2011 5:06 pm

Re: MMB with MS SQL Server Table data report print

Postby dgilmour » Thu Oct 04, 2018 7:12 am

You can make HTML page containing report data and print it. I doubt anyone will write plugin now.
dgilmour
 
Posts: 523
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko

Re: MMB with MS SQL Server Table data report print

Postby arifbsn » Thu Oct 04, 2018 7:26 am

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?
arifbsn
 
Posts: 14
Joined: Fri Jul 29, 2011 5:06 pm

Re: MMB with MS SQL Server Table data report print

Postby dgilmour » Fri Oct 05, 2018 3:55 pm

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.
dgilmour
 
Posts: 523
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko

Re: MMB with MS SQL Server Table data report print

Postby Nigg » Wed Apr 24, 2019 6:29 pm

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.
Nigg
 
Posts: 54
Joined: Thu Apr 14, 2011 2:10 pm


Return to MMB

Who is online

Users browsing this forum: No registered users and 2 guests

cron