Archive

Posts Tagged ‘MS SQL Server’

Stored Procedures

January 24, 2013 Leave a comment

Sunset Reports provides many options for connecting to data.   This includes:

  1. Direct Connection to Microsoft Access Tables and Queries
  2. Direct Connection to DSN defined ODBC Connections
  3. Direct Connection to Microsoft SQL Server
  4. Direct Connection to Oracle
  5. Direct Connection to MySQL
  6. and others….

There are also a many options using OLD EB and ODBC connection strings as well as Excel, Outlook, XML, and CSV files.

In general connecting to a table, query, or view is straightforward.   But you can also connect to a stored procedure by defining the SQL directly.  And you can pass parameters to those stored procedures as well.

In the following figure, you can see a a stored procedure defined in the SQL block.  This can be edited directly on this form.

1-24-2013 10-10-49 AM

As long as you have a valid ODBC, PDC, SDC, or QB Connection, you should be all set to retrieve data from stored procedures.   This implementation is similar in functionality to Microsoft Access Pass-Thru Queries.

MS SQL Server Reporting Tool

May 22, 2012 Leave a comment

Sunset Reports offers several methods of connecting to SQL Server databases that makes it a good choice for creating reports.

Using the built-in Query builder you can connect directly to a SQL Server database as shown in the next figure.

The Query Builder also supports SQL Dialects for different versions of SQL Server.

Even in the Report Designer, you can use the Report Wizard and make a connection to SQL Server…

 

But of course, you can simply use the ODBC connection if you choose.