Archive

Archive for June, 2012

End User Deployment by the IT Department

June 15, 2012 Leave a comment

A really great method of deploying Sunset Reports for end users and giving them the ability to create reports from corporate databases is to have the IT department create RDB files with all the connections to the databases already made.   This would give the end users a friendly way to choose the data sources for their reports.   Different RDB files could be prepared based on the department and permission level for the users.

Advertisements

End-User Reporting

June 13, 2012 Leave a comment

“End-user computing” as defined by Wikipedia refers to “systems in which non-programmers can create working applications”.   End-user reporting is similar in concept in which non-programmers can create working reports.   Report designing is an application type by itself so whether you call it End-user computing or End-user reporting, you can be talking about the same thing.

Sunset Reports puts the report design, development, and deployment in the hands of the end user.   And with so many features, there is very little the end user will find that they are missing.   In fact, all the features may seem a bit overwhelming at first.   So we highly recommend end users take advantage of the Help and Support page on our website when they get started.

Writing Reports for Users

June 11, 2012 Leave a comment

In the article “10 tasks IT should consider handing off to someone else” by Scott Lowe, he covers a very important topic, “7: Writing reports for users… to a point”.   We would like to add to that discussion, that accomplishing this requires the non IT person needs a tool that can use and master.   We created Sunset Reports to be just that tool.  Several posts have already covered this topic and if you have not tried Sunset Reports yet, we encourage you to see how well it works.

Search our blog for the term “user” and you will see several posts relating to this subject.

Federal Reserve System

June 10, 2012 Leave a comment

The Federal Reserve System has a Data Download program providing all kinds of information about

  • Principal economic indicators
  • Bank Assets & Liabilities
  • Business Finance
  • Exchange Rates and International Data
  • Flow of Funds Accounts
  • Household Finance
  • Industrial Activity
  • Interest Rates
  • Money Stock and Reserve Balances

And all this data is available for download and you can choose your format which includes CSV, Excel, and XML.  All formats are supported by Sunset Reports.   Search previous posts for details of how to connect using these formats.

US Census Data

June 9, 2012 Leave a comment

There are a number of datasets you can download and feed into Sunset Reports from the US Census Bureau.   The datasets are numerous and are downloaded as csv files.   Sunset Reports can directly link to these files using the Query Builder and connecting to a CSV Folder.   Each CSV file becomes a table object and you can actually create data sources linking multiple CSV files.   The reporting opportunities are endless.

iPad Database Sync

June 8, 2012 Leave a comment

In a recent article by Sam Laird titled “In a Relationship:  Mobile Apps and the Cloud“, the author points out the connection between mobile devices and the cloud. In recent posts we spoke about how this relationship works with our software. Getting reports from Sunset Reports is a simple process that we have spoke about several times and offered several methods to do it, from emails, texts, and cloud services.

Capturing data on a mobile device and getting that data into a database that Sunset Reports can connect to is a different topic. Client software on a mobile device exists to do just that. There are a few business database applications for the iPad, but here we want to focus on those that will “sync” to a cloud server in the true sense of the word.   The app needs to handle the situation where it is not online all the time. If you go to the app store and search for “database sync” you will only find one product in the “business” category, and that app is called “Cellica Database”. In future posts, we will explore this app and how to use it in conjuction with our product.

Cloud Server

June 7, 2012 Leave a comment

In some upcoming posts, the details of how to implement a Cloud Server with Sunset Reports will be discussed.   The following diagram shows the basis of this discussion.  This architecture has been used for projects where a database client was running on an iPad, and this client would synchronize with it’s server counterpart and keep a set of database tables up to date both on the iPad and the Server.   Then Sunset Reports was used to create the reports needed and pushed those reports to the client on a schedule and as requested.