Re: [sqr-users] HTML in SQR (PeopleSoft)

[Betty DeMatto <dematto@tcnj.edu>]

Thanks so much.  I'll check it out.
Betty

jwillson@dssltd.com wrote:

>Hi Betty, not directly related to PeopleSoft is Darrin Millar's book see 
>http://www.sqrevangelism.com/.  The book has a discussion on Table of 
>Contents and bursting in SQR.  When reading it, replace sqc s with incs.  As 
>long as the SQR is generating the html and not PeopleSoft you have complete 
>control.
>
>John Willson
>
>
>Betty DeMatto <dematto@tcnj.edu> said:
>
>  
>
>>I am using HTML in an SQR for the first time and have a few questions 
>>about what can and cannot be done in PeopleSoft.  We have a web 
>>reporting system that uses Oracle Reports that resides outside of 
>>PeopleSoft.  Some our reports are written so that you can drill-down on 
>>a column value and have a new report called (for detail).  We would like 
>>to do the same within PeopleSoft and I've found 2 ways to possibly do 
>>it.  I've written an SQR using HTML with hyperlinks to the run control 
>>page of what would be the drill-down report.  Unfortunately this 
>>approach requires the user to actually run the next report using the run 
>>control, etc.  The other approach I've attempted is creating all of the 
>>reports (the main report and the 'drill-down' reports) within the same 
>>SQR and then use anchors to find the spot in the drill-downs that 
>>corresponds to the main report link.  The problem I had here was that 
>>the main report is written to our webserver (PSREPORTS directory) but 
>>the drill-downs are written to the Unix SQR directory where they will be 
>>overwritten as soon as another user runs the same report.
>>
>>We are using SQR for PeopleSoft 8.44.10 on /Sun/SunOS 5.6/Oracle 8.0.6.
>>
>>Has anyone accomplished what I am trying to accomplish and if so can you 
>>give me any insight on what I need to do to make it happen?  Any 
>>information (especially if I'm wasting my time trying to do this) would 
>>be greatly appreciated.  I've been using SQR in PeopleSoft and Other 
>>Applications for reference.  If you can recommend any other reference 
>>material I'd appreciate that as well.
>>
>>Thanks in advance,
>>Betty
>>
>>    
>>
>
>
>
>  
>
Here was a non admissible message part of 'text/x-vcard' MIME type. It
has been automatically discarded before sending the message to the
list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users