Archive

Archive for July, 2012

The Perfect Data Analyst Tool

July 7, 2012 Leave a comment

If you are a data analyst or do data analysis work, Sunset Reports may be the perfect tool for you.   It can connect to a varient of business applications and databases.   You can create very sophisticated queries and data extractions.   With the report designer, you can produce almost any kind of report you want with many different type of charts or graphs, pivot tables for OLAP sources or any source, calculations, statistical and regression analysis, forecasting, and more.   The results can be sent to a variety of formats and distributed in a number of different ways.   It is ideal for making recommendations, interpreting data, discovering trends, problem solving, data mining, quantitive analysis, and data visualization.

Advertisements

Report Subscriptions

July 5, 2012 Leave a comment
Suppose a user wants to “subscribe” to a report such that the report will be emailed to the user on a periodic basis (i.e. daily, weekly, etc).  The process is very easy to setup.   First add the report to the Queue at the time the user wants the report.   Then open the Calendar view of the Queue and find the report just added.  By double clicking on the report or right mouse clicking on the report and selecting “Open”, you have the ability to change the time and also set the Recurrence of the report.   This is the way you can set reports to recur on specific days and times repeatedly.

Cache Reports

July 3, 2012 Leave a comment
If you have a report that takes a long time to process and multiple people may request it, why not cache the report?   You might also have a report based on some data range like last year and you only need to run it once since it will not change.   Setup Sunset Reports to run the report and either manually save it to a location as a PDF (or other format) or queue it up to run as often as necessary.   Then create a different Report Definition that is based on that pre-run file.   The option exists with Report Definitions to use an external file.   Create the report definition but do not assign a report design.  Instead go to the parameters tab and select the text tab.   You will find a button on the bottom labeled “Add Filename parameter”.   Click the button, browse to the file (you will have to at least run the report once to select the file), and the parameter will be added.   Now running this report definition through the report queue will send the file via Email or FTP without rerunning it.   Of course if the location of the file is made available as a local share, the file is available to anyone who has access and the second step is not required.