Archive

Posts Tagged ‘Zip Code’

Compare Toolbars with Crystal Reports

March 9, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between Crystal Reports and Sunset Reports.

Crystal Reports vs Sunset Reports Toolbar

Crystal Reports vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.  Crystal Reports only has a rectangle as a shape while Sunset Reports provides 23 shapes.

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and Crystal Reports does not have.

For the items on the top toolbar with a green callout:

1 – Insert Group (This is handled differently in Sunset Reports)

Compare Toolbars with SQL Server

March 8, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between SQl Server Report Builder and Sunset Reports.

SQL Server vs Sunset Reports Toolbar

SQL Server vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.  SQL Server only a rectangle as a shape while Sunset Reports provides 23 shapes.

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and SQL Server does not have.

For the items on the top toolbar with a green callout:

1 – List (This is the default report format in Sunset Reports and does not need a button)

2 – Data Bar (This is a new control coming in an upcoming release of Sunset Reports.  In the meantime, you can use a horizontal bar chart or a horizontal bar gauge)

3 – Sparkline (This is a new control coming in an upcoming release of Sunset Reports.  In the meantime, you can use a line chart)

Compare Toolbars with MS Access

March 1, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between Access 2010 and Sunset Reports.

MS Access vs Sunset Reports Toolbar

MS Access vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.   The dotted red line shows an approximate match.  Access provides only a rectangle as a shape while Sunset Reports provides 23 shapes.  (Ever try to put a circle or an arrow on an Access report?).  Those items on the Access toolbar with a question mark are for items that really do not belong on a report.  (Why would you put tab controls, buttons, drop down lists, etc. on a report?)

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and Access does not have.  Although one might argue that the “Unbound Object Frame” (2) or the “Bound Object Frame” (4) can provide this missing functionality.  If you can accomplish something similar, it is far more difficult and more restrictive than the native Sunset Reports controls.   The “Hyperlink” control on the Access Toolbar is actually available on all the controls in Sunset Reports.  And finally, Access has a control called “Attachment” (3).  This is an attempt to provide a link to an external file or an database object.  If the object is an image, use the Sunset Reports picture box.  If the object is text, use the Sunset Reports Rich Text control.