Archive

Posts Tagged ‘Web Page Designer’

Quick Introduction

May 26, 2017 Leave a comment

Sunset Reports is based on award winning components and proven technology, and provides users an alternative to such software as Crystal Reports, SSRS, and others.  The report designer handles all types of content.   And you can even import report designs from other software as well.  The report queue allows for scheduling of reports, file and document distribution including recurring schedules and provides easy to use list and calendar views.  Besides using Sunset Reports as a reporting tool, it is perfect for information management, data analysis, business analytics, visualizations, web site design, making labels, data conversion, document management, document distribution, and more.

This slideshow requires JavaScript.

Advertisements

Not Just Reports

December 1, 2013 Leave a comment

Yes, Sunset Reports is a great report writer, designer, etc. based on the general understanding of what a report writer is.   But the definition of a report in the software goes far beyond the general understanding.   A report can be a…

  • standard report usually based on some data source
  • document (you can do what most word processors can do)
  • presentation (create a slide presentation where each page is a slide)
  • web page (save to an HTML file and post on a website)
  • Windows form (using the new Windows View)
  • interactive interface (using the new Windows View, you can have the user interact with the window with buttons, etc., make a menu)
  • data converter (define an output format to export to based on an input data source)
  • a software program (using scripts, you can write software in VB.NET C#, JScript .net)

We will explore a couple of these in more detail in future posts.

All In One Software

April 23, 2013 Leave a comment

As we continue to see how people use Sunset Reports, we are amazed to find out that the product can do so much.   In surveying our current user base, we have found the functionality of the software going beyond what we originally intended.   Here is a small list of how the software has been used (The first few were obvious, but included here to make the list as complete as possible.)

  • Reporting Tool
  • Data Analysis
  • Business Analytics
  • Management Dashboards
  • Charting
  • Visualizations
  • Business Graphics
  • Web Site Design
  • Web Page Designer
  • Label Maker
  • Word Processor
  • Dunning Letters
  • Data Conversion Tool
  • Document Management
  • Document Distribution
  • FTP Client
  • File Backup Manager
  • Report Server
  • Report Subscriptions
  • Meeting Presentations
  • Report Scheduler
  • Model What-if Scenarios
  • Email Blasts

If you are using the product for something not on this list, drop us a line, we would love to hear from you.

Feature List

March 27, 2013 Leave a comment
Data Connectivity Data Sources MS Access (all versions), SQL Server, MS Excel, Oracle, OLEDB, ODBC, MS Outlook, MySQL, and more
Visual Query Builder Grouping, Sorting, Filtering, Sub-queries, derived tables, Union queriesAdvanced properties: Aliases, Virtual fields, Various SQL Dialects, Visual representation modes
Report Design Contents grouping, filters, sorting, bands, sub-reports, styles, summaries, calculated fields, watermarks, backgrounds, bookmarks, parameters
Controls text boxes, lines, shapes. barcodes, checkboxes, page info, panels, images, page breaks, tables, postal codes, rich text controls, cross-band controls, hyperlinks, multi-columns, cross-references, gauges, map control
Pivot Tables OLAP, Key Performance Indicators, (KPI) Graphics
Charts & Graphs 56 Types with many options2D, 3D, Regression and Trends
plus Parameters, scripts, wizards, labels, mail merge, Drilldown, Drillthrough, Document Map, Multiple reports within a single reportImport from Crystal Reports, Microsoft Excel, Microsoft Access, Data Dynamics Active Reports, and DevExpress
Report Definitions Parameters Select from a data sourceText, Numeric, Static Dates, Dynamic Dates, Fixed and Prompted
plus Multiple definitions using the same design, Descriptions, Titles, External files (treat a file from other software as a report), Print/Preview, Export, Email
Distribution & Delivery Report Processor Runs as a service in the background
Similar functionality to a Report Server
Has the functionality of a server without an operating system server, database server, or web server
Handles report subscriptions
Report Bursting, Report Exploding, Report Splitting, Email Blasts, Email Broadcasting
Report Queue Schedule one time, Schedule recurring, List and Calendar views
Email Requests Monitor email requests, Reply to emails with attached reports/documents
FTP Transfer reports to FTP Site
Website Semi-Static Website, Automatic Index page creation for reports including nested folders
File Formats Document: pdf, html, mht, rtf, txt
Data: txt, csv, xls, xlxs
Graphic: bmp, emf, gif, jpeg, png, tiff, wmf
PDF’s can be password protected

Web Page Designer

June 17, 2012 Leave a comment
Sunset Reports is not only a great report designer, but you can use it to create static web pages that do not connect to a data source and are not really reports.   To do this, you create a new report design.  When it prompts you for a data source or the wizard pops up, just cancel.   You will then have a blank report design.    You can now use a number of controls to build your webpage. Start with a table control to organize a page.   You can add rows, columns, and cells.   Deleting cells will provide a way to merge cells across columns.   The sizes of rows and columns can be controlled.   Once you have a rough layout, now start adding controls to the cells.   A label control will give you text, but if you want to mix up the fonts, sizes, or colors within a control, use the Rich Text control.   Add lines, shapes, and images.   You can even add a chart if you want to add the data manually.   Use the HTML View to see how it will look.   You can also do a lot with borders, and styles.   All objects have a Navigation Target and Navigation URL property, so adding hyperlinks is powerful and easy.   The Navigation Target will be one of these values: _blank, _parent, _search, _self, or _top.   The URL can point to an external page or a control on the current page.  To point to the control within the page, assigning the name of the target control to the Navigation URL property, and set the Navigation Target property to “_self”.
Categories: Web Tags: , , ,

Web Capabilities

April 25, 2012 Leave a comment

Sunset Reports has several capabilities for the web. These include:

  • Saving reports as HTML and MHT
  • Automatically creating index web pages for report folders
  • Sending files to web sites via FTP
  • Designing web pages using the report designer with tables, labels, images, rich text controls, lines, shapes, navigation targets and navigation urls.
  • Preview designs in HTML

Business Dashboard

April 17, 2012 Leave a comment

To create a webpage that has several charts on it like a dashboard do the following:

If you start with a blank report, add all the data sources you need by choosing the “Add Data Source” menu item on the report designer. Then add one or more chart controls onto the report. Click on the chart smart tag on the top right if each chart and select the Data Source, Data Member, and Data Adapter. Do this for each chart. Run the chart wizard now to setup the chart. Arrange the charts so the report appears like a dashboard. You are now ready to go.

Your dashboard can include pivot tables as well as subreports.   There is no limit to the formatting options.   Then set it up to output in all kinds of different file formats and be sent to a website, FTP site, emailed, or other output option.

Note:  For a even more powerful Dashboard solution, check out CleverQ.   This product actually includes a version of Sunset Reports built-in.