Need Plugin For MS SQL Server Data view for Print

Multimedia Builder

Need Plugin For MS SQL Server Data view for Print

Postby weakzone » Wed May 22, 2019 8:02 am

Hello Everyone,
I've a MMB Plugin name NAP Access Report View.
Plugin with Demo: http://weakzone.xyz/sub_domain/mmb/access_plugin_with_report_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 436 times
1.PNG
1.PNG (6.67 KiB) Viewed 436 times
weakzone
 
Posts: 10
Joined: Tue May 14, 2019 4:48 pm

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

Postby dgilmour » Thu May 23, 2019 3:32 pm

Check this plugin:
viewtopic.php?f=17&t=1116
You can use it to connect to MS SQL and get data from the DB.
dgilmour
 
Posts: 523
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko

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

Postby weakzone » Fri May 24, 2019 2:48 am

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
weakzone
 
Posts: 10
Joined: Tue May 14, 2019 4:48 pm

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

Postby dgilmour » Fri May 24, 2019 11:15 am

Why can't you create your own report using HTML?
dgilmour
 
Posts: 523
Joined: Fri Oct 22, 2010 11:29 am
Location: Moskva, Rusko

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

Postby weakzone » Fri May 24, 2019 11:23 pm

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
weakzone
 
Posts: 10
Joined: Tue May 14, 2019 4:48 pm


Return to MMB

Who is online

Users browsing this forum: Bing [Bot] and 1 guest