I just provide the .rpt filename,'user0' and 'password0' parameters and any other report specific paramters, the modified IFramePortlet then just puts the URL together and loads up the ActiveX viewer. Not very advanced but it does the trick.
Richard. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 December 2002 12:28 To: [EMAIL PROTECTED] Subject: RE: 1600 users (was Is anyone REALLY using Jetspeed?) What kinds of changes did you have to make to IFramePortlet? We use Crystal as well, and currently are evaluating Jetspeed and Citrix NFuse portals.. One of the nice things about NFuse is the easy integration with Crystal, but it sounds like you may have solved some of the Java -> Crystal ActiveX auth issues...? Eric -----Original Message----- From: Moore, Richard [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 6: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]> 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]>
