Archive
Window View – The Next BIG thing in Sunset Reports
Coming in the next version of Sunset Reports is “Window View”. Currently you can print, export, and print preview a report. With “Window View”, your report becomes a window for viewing on the screen only. The features of this new view include:
- Display your report as a window on the screen
- The window can be interactive using the scripts you design in the report designer. There are numerous possibilities here. Drilldown reports, menus, etc. This can be your user interface to the reports you want to give to a user. Users don’t even have to see the functions of Sunset Reports to see the reports they want or you want to give them. You can launch other reports in Window View or Print Preview.
- The window is automatically sized to the page size of the report design so you can control the window size. Make it as small or large as you want. Include any of the report objects. Use a Label with a OnClick script to create a button.
- You can set a time for the window to refresh. This means your report will be updated periodically automatically. The update time can be as little as 1 second. So now your report will update in real time showing real time data.
- If your report has more than one page, and if you set an window refresh time, the pages of the report will cycle to that time, and when the first page comes back up, the report will be refreshed with new data. This feature can be used for slide shows with real time data.
The following figure shows a Window View of a report design. This design is intended to work as a menu system. It has a clock that is updated every second. The five items on the right are labels with click events to perform functions. This example is included in the sample reports file included with the product. You can actually create your own application with this feature.
Updated Documentation
The Sunset Reports User Manual has been updated to the latest version and includes 229 pages of detail information for reference on all the aspects of the product. This includes: Installation, Starting the Program, Setup, Data Sources, Report Design, Report Definitions, Report Distribution, a Tutorial, and Technical Support.Preview it Here
Poster – Large Format Pictures
If you have ever wanted to take a picture, image, or photo and blow it up and print it on a large format paper, or multiple sheets of paper and tape it together, you might have a hard time finding the right tools. Sunset Reports can be easily used to print posters, or simpye your picture or photo on multiple sheets of paper. Choose as many sheets wide and tall you want, and print them out. This concept works well too for signs. For a sign, you can use the label or rich text control. And you can also use any other combination of controls for both text and images.
Here are the steps to follow to print a picture across multiple pages:
1 – Create a new report design
2 – Select the paper size you want to print to and the orientation (Landscape or Portrait)
3 – Add a picture box control.
4 – Select your picture using the Image URL Property
5 – Size your picture by changing the size properties of the Picture Box control. The size is set usually by hundreds of an inch(or tenths of a millimeter). For example 2000 = 20 inches.
6 – Change the sizing property to “Stretch Image”
7 – Size the TopMargin and BottomMargin to something compatible with your printer. (50 works good in most cases)
8 – Go to Print Preview to see your result. Then either print it, or go back to Report Design to tweak your document.
Here is a print preview of an image that was stretched to 3 pages wide by 4 pages high.
Stored Procedures
Sunset Reports provides many options for connecting to data. This includes:
- Direct Connection to Microsoft Access Tables and Queries
- Direct Connection to DSN defined ODBC Connections
- Direct Connection to Microsoft SQL Server
- Direct Connection to Oracle
- Direct Connection to MySQL
- 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.
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.
QODBC
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:
- Create your own custom reports
- Create reports not provided by QuickBooks
- Connect to more than one QuickBooks file and create reports for multiple companies
- Show multicompany data on the same report
- Use the tools available in Sunset Reports to create reports you could not create in QuickBooks (Charts, Gauges, Pivot Tables, Images, etc.)
- 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