[sqr-users] HTML in SQR (PeopleSoft)

[Betty DeMatto <dematto@tcnj.edu>]

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