Re: How to choose a reporting tool (to connect to a SQL Server Database)



justin_brookman@xxxxxxxxxxx wrote:


>I am an experienced Access user who has worked as an Access Developer
>at a Junior level.
>I work for a small charter airline which has recently bought a bespoke
>SQL Server database to manage all aspects of the business: Sales,
>Flight Operations, Engineering, Stores, Personnel etc.


You didn't just buy a database, you brought some sort of airline MIS
product, yes? Care to mention which one? In the past I worked for a
charter airline as a programmer, so I'm interested.


>Could somebody reccommend or provide a rational for how to choose a
>good reporting product? I Currently use Access to connect to the
>database but am not familiar with Crystal Reports and others that have
>been mentioned. Am I right in thinking that another product other than
>Access will provide an advantage?


There are a truckload of reporting tools out there. You could look at
Brio which is one I've used and is good.

Or you may wish to go a step further and use a development environment
which points at your database - I use Delphi, which has its own report
writers, which is good, because there's always someone who wants the
data in a format which off-the-shelf products can't always provide.


Paul...


>Justin

--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
.

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL ... where I cannot leave MV behind unless I can find a better data model. ... screen to be identical to the logical data model of the database. ...
    (comp.databases.theory)
  • Re: Freezing Over Start Menu.... Again
    ... James, thanks for reporting back to the group, it often helps others. ... I suspect that MSE keeps a database of what's where and things like file versions and sizes, perhaps in order to replace things that get damaged by malware or crashes, so it maybe has MSSQL Lite or something running. ...
    (microsoft.public.windows.vista.general)
  • Re: New Computwer with "Office with Access"
    ... Alpha 4 I found interesting at the time, ... Filemaker was a pretty good database from a user standpoint. ... Reporting was easy too, and one of it's ... Perhaps more familiarity with it would help. ...
    (misc.news.internet.discuss)
  • Re: Reporing service failure
    ... I understand that when you tried to configure your database for your SQL ... Server Reporting Services, you encountered the logon failure error. ... And then configure your SSRS databases via Reporting Services Configuration ...
    (microsoft.public.sqlserver.security)
  • RE: Reporing service failure
    ... I understand that when you tried to configure your database for your SQL ... Server Reporting Services, you encountered the logon failure error. ... it was strange that the audit failure was for another user account NT ... And then configure your SSRS databases via Reporting Services Configuration ...
    (microsoft.public.sqlserver.security)