Archive

Archive for January, 2013

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.

Advertisements

QODBC

January 23, 2013 Leave a comment

QODBC is a product from FLEXquarters that provides a data connection to QuickBooks.  They do this by providing an ODBC connection with their driver that makes reading and writing data to QuickBooks easy.   From the standpoint of Sunset Reports, we are only interested in reading the QuickBooks data.  If you have QuickBooks and QODBC installed, you are ready to connect and start creating your custom reports with Sunset Reports.  Even though QuickBooks has it’s own reports, you want to look at this option for the following reasons:

  1. Create your own custom reports
  2. Create reports not provided by QuickBooks
  3. Connect to more than one QuickBooks file and create reports for multiple companies
  4. Show multicompany data on the same report
  5. Use the tools available in Sunset Reports to create reports you could not create in QuickBooks (Charts, Gauges, Pivot Tables, Images, etc.)
  6. Use the features of Sunset Reports for Report Distribution

In several followup posts, you will see some examples of how you can use Sunset Reports with QODBC.

If you are ready to get started and have Sunset Reports, then refer to this link to understand the QODBC connection so you can create your data sources.   QODBC Technical Reference

 

Licensing Change

January 18, 2013 Leave a comment

Our previous single user workstation license did not work on servers like Windows Server 2003 or 2008.   We now offer a license for a single user to use Sunset Reports on a workstation or server.   This is the same price as the workstation license.

Categories: Advantages Tags:

Sunset Reports Gauges

January 15, 2013 Leave a comment

With Version 1.89 you now have 4 new items on the toolbar in the report designer.   These items are:

  • Full Circle GaugeGauge
  • Half Circle Gauge
  • Horizontal Gauge
  • Vertical Gauge

With the combination of gauge types and background styles, you have over 100 gauges to choose from.

There are numerous properties associated with each gauge and some properties can be bound to your data source.

For more information, see the this PDF file – > Sunset Reports Gauges

Categories: Examples, Features Tags: ,

Version 1.89 Released

January 15, 2013 Leave a comment

This version adds

  1. Gauges to the toolbox so you can now have gauges on your reports
  2. The report converter for importing your report designs from Microsoft Access, Crystal Reprots, Data Dynamics Active Reports. Dev Express. and Microsoft Excel is also being updated
  3. You can now create calls to Stored Procedures
  4. Several bug fixes are also included

This is a FREE update to all existing licensed Sunset Reports users.

QuickBooks and CleverQ

January 5, 2013 Leave a comment

Intuit has provided an ODBC source called QODBC which is a data source interface to Quickbooks.   With this ODBC interface you can extract data from Quickbooks allowing reports and other information gathering applications to use the data.   A version of Sunset Reports is included in a product called CleverQ which can extract Quickbooks data in a different way and can provide dashboards, gauges, scorecards, charts, reports, and more.   It can also import data from Microsoft Excel, Access, and other compliant ODBC databases.  Click HERE to find out more.