Page 1 of 1

Need Plugin For MS SQL Server Data view for Print

PostPosted: Wed May 22, 2019 8:02 am
by weakzone
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

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

PostPosted: Thu May 23, 2019 3:32 pm
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.

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

PostPosted: Fri May 24, 2019 2:48 am
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

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

PostPosted: Fri May 24, 2019 11:15 am
by dgilmour
Why can't you create your own report using HTML?

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

PostPosted: Fri May 24, 2019 11:23 pm
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