Need Plugin For MS SQL Server Data view for Print

Multimedia Builder (Legacy Forum)
Post Reply
weakzone
Posts: 10
Joined: Tue May 14, 2019 4:48 pm

Need Plugin For MS SQL Server Data view for Print

Post by weakzone »

Hello Everyone,
I've a MMB Plugin name NAP Access Report View.
Plugin with Demo: http://weakzone.xyz/sub_domain/mmb/acce ... t_view.zip

This plugin is so awesome to view MS Access data. But I need same type of plugin which is view data from MS SQL Server database.
Anyone help me?

Thanks
Attachments
2.PNG
2.PNG (55.3 KiB) Viewed 1071 times
1.PNG
1.PNG (6.67 KiB) Viewed 1071 times

dgilmour
Posts: 530
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko
Contact:

Re: Need Plugin For MS SQL Server Data view for Print

Post by dgilmour »

Check this plugin:
viewtopic.php?f=17&t=1116
You can use it to connect to MS SQL and get data from the DB.

weakzone
Posts: 10
Joined: Tue May 14, 2019 4:48 pm

Re: Need Plugin For MS SQL Server Data view for Print

Post by weakzone »

Dear dgilmour,
Thank you so much for your suggestion. I know well ODBC PlugIn (Database) which is retrieve data from MS SQL Server. But I need to print preview report from SQL Database as like Crystal Report or Fast Report to manage report using SQL Query.

Thanks again

dgilmour
Posts: 530
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko
Contact:

Re: Need Plugin For MS SQL Server Data view for Print

Post by dgilmour »

Why can't you create your own report using HTML?

weakzone
Posts: 10
Joined: Tue May 14, 2019 4:48 pm

Re: Need Plugin For MS SQL Server Data view for Print

Post by weakzone »

Dear dgilmour,
Thanks for your suggestion.
I solved my problem. I just change connection string and retrieve data for print.

MS Access Connection:
[Connection]
CString=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Database.mdb;Persist Security Info=False;Jet OLEDB:Database Password=
TableName=tbl_book

MS SQL Server Connection:
[Connection]
CString=Provider=SQLOLEDB.1;Data Source=ARIF-SERVER\SQLEXPRESS;AttachDbFilename=;Initial Catalog=DatabaseName;User ID=sa;Password=12345;Persist Security Info=True;
TableName=tbL_book

Post Reply