Interesting about Crystal. That's where I started. It was when I discovered the very high costs for licensing this technology -and for the expertise to configure and maintain it- that I began looking for alternatives. That search led to Jetspeed.
When you looked at Crystal did you find any Open Source alternatives? Bill > -----Original Message----- > From: Moore, Richard [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 20, 2002 3:21 AM > To: 'Jetspeed Users List' > Subject: RE: 1600 users (was Is anyone REALLY using Jetspeed?) > > > All of our reports are generated on a second server using Crystal Reports. > We use the Crystal ActiveX viewer within an slightly modified > IFramePortlet > (Jetspeed passes the crystal report authentication information) > or fired up > into a separate window, so we don't really run any large queries on the > server running Jetspeed. > > This approach seems to work fine for our needs - I didn't want to slow the > Jetspeed server down with anything other than user and content management. > > Access to each set of reports is controlled using roles, users > can apply for > access to these online and we have a number of people accepting > or rejecting > them. As soon as they are accepted the options become available. > > As for users downloading data, the Crystal viewer has an export > option that > can be used with excel or word - In the past we have also generated CSV > files when the report is run and linked to them on the bottom of > the page - > this seems to launch excel in most cases. Apart from one or two stability > issues, we have found Crystal to be a great reporting solution - we would > like to upgrade to Crystal Enterprise, but the costs are rather high. > > Richard. > > > -----Original Message----- > From: Bill Weir [mailto:[EMAIL PROTECTED]] > Sent: 20 December 2002 05:18 > To: Jetspeed Users List > Subject: RE: 1600 users (was Is anyone REALLY using Jetspeed?) > > > Richard, > > Your screen shots are very, very impressive. You have clearly delivered > something of real worth with Jetspeed. > > As it happens, I'm trying to do something alot like one part of your web > page; namely to provide a reporting facility from an external Oracle > database. Can you tell me anything about your approach to generating > reports? I'm starting with the DatabaseBrowser portlet and > configuring it to > my own needs. Amongst other things, I need to keep the query volumes down > because the entire result set is read into memory (documentation comments > that this will be addressed in a future version). > > Have you developed your own report portlet? Do you let users > configure their > own reports? > > I also want to add a button to allow people to inline download the results > of any query into a local spreadsheet so they can manipulate data locally. > This is something my customers are constantly asking for. > > Again, your work is very impressive. > > Bill Weir > > > -----Original Message----- > > From: Moore, Richard [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, December 17, 2002 12:31 AM > > To: 'Jetspeed Users List' > > Subject: RE: 1600 users (was Is anyone REALLY using Jetspeed?) > > > ... > > our homegrown content management system. I've posted a few > screenshots at > > http://www.webtronic.d2g.biz/logisticsnet/ to give you an idea of the > > layout. > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > This e-mail and any attachments hereto are: > > -strictly confidential and intended solely for the addressee. If you are > not the intended addressee, you must not disclose, forward, copy, > or take any > action in reliance on this e-mail or attachments. If you have > received this > e-mail in error, please notify NHS Logistics sender as soon as possible. > > -not intended to create contractual relations or legal obligations binding > on NHS Logistics and no action may be taken in reliance on this e-mail and > any attachments hereto unless the contents are confirmed by letter. > > Addressees should check all attachments for viruses. NHS > Logistics makes no > representations as regards the absence of viruses in attachments to this > e-mail. > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
