[rt-users] Crystal Reports

[Roy El-Hames]

Well kind of No, as Todd suggested the relationship within the RT tables 
are n't straight forward to do joins/Sql queries easily you'll need some 
sort of Perl api at the top, I know little about CR , can it talk to/via 
Perl  ??..
Another approach (One I have been pondering) is to create new tables 
within RT to collect Stats type data , the tables get populated via 
croned perl scripts, then get the reporting tool (CR or any other to 
query these Stats table).

Regards;
Roy   

Mathew Snyder wrote:
> Or simply have CR connect directly to the database and run the reports itself, yes?
>
> Mathew
>
> Todd Chapman wrote:
>   
>> The problem is that you would have to build the intelligence
>> of the RT API into Crystal. The relations between some of
>> the RT tables and not straightforward. Also crytsal would
>> not enforce RT's permissions. You would be better off to
>> do the reporting in Perl and output to HTML, PDF, or
>> something understood by a preferred formatting tool.
>>
>> -Todd
>>
>> On Thu, Jan 04, 2007 at 11:05:51PM -0500, Mathew Snyder wrote:
>>     
>>> Has anyone successfully used Crystal Reports with their RT installation?  I
>>> don't know much about it myself so I'm curious about how it would interface.
>>> Would it have to be run separately or is there a way to include it in the
>>> reports interface?
>>>
>>> We have a new license here at work and I've been asked to find out about its
>>> interaction with RT.
>>>
>>> Mathew
>>> _______________________________________________
>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>
>>> Community help: http://wiki.bestpractical.com
>>> Commercial support: sales at bestpractical.com
>>>
>>>
>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>>> Buy a copy at http://rtbook.bestpractical.com
>>>       
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>