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

[<jwillson@dssltd.com>]

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
> 



-- 




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users