[rt-users] question on reporting

Ken Crocker KFCrocker at lbl.gov
Fri Dec 16 15:32:33 EST 2005


    WE have the same problem. Many of our users can deal with the 
spreadsheet to Excell then modify scenerio but we also have some users 
that feel the query tool is inadequate AND SLOW. We are creating a 
Report Link for the home page that will give our users the option of 
writing a COGNOS report or using a more powerful SQL tool. We are on 
Oracle 9. Developing this as a link allows us to add the link to any 
upgrades we download from RT without a lot of fuss.


Stephen Turner wrote:

> At Thursday 12/15/2005 10:49 AM, Jonathan Jesse wrote:
>> What do you use for reports out of RT? For reports out of our banking 
>> system, I can write queries and other reports with a product we have 
>> (Cognos Impromptu) and assume thru an ODBC connection or something I 
>> could connect to the database and generate the information I need and 
>> make the reports a little prettier and easier to read then doing just 
>> printing a query result from the RT web page.
>> So how do you all generate reports for the boss? Or people interested?
>> Thanks,
>> Jonathan
> Hello Jonathan
> You can certainly point a reporting tool at the database, but the 
> schema is a little hard to understand (as it is with many 
> transactional DBs) and so you'd need to do quite a bit of studying 
> before you could be certain your reports were showing what you wanted.
> You could move some RT data to a data warehouse but that would 
> probably be a sizeable project and would again require you to learn 
> the RT schema fairly well.
> A quick alternative is to use the spreadsheet download link that 
> appears on the bottom of the search results page - you can get data 
> into Excel and perhaps use Impromptu or whatever to make reports from 
> that.
> I'd be interested to hear what you decide.
> Steve
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> Download a free sample chapter of RT Essentials from O'Reilly Media at 
> http://rtbook.bestpractical.com
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html

More information about the rt-users mailing list