Date:         Thu, 12 Jun 2003 13:35:13 -0400
Reply-To:     "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>
Subject:      Re: Report web link
Content-Type: text/plain; charset="iso-8859-1"

David,

The easiest way is to preprocess the data into another variable.  I have the
following line of code in one of my reports I generate, I'm sure you can
adapt it to your own needs.

        dlrlink="<a href=http://10.102.8.83/mandash/dealer_reports/mtd/" ||
                compress(dealrid)||".html>"||dealrid||"</a>";

Then simply reference dlrlink in the report.

Brad

> >I have a report on the web created with ODS.  What I want is
> to be able to
> >have a cell contents act as a link to another report.  In the example
> >below, I would click on DAY2 and be presented with the DAY2 detail
> >report.  Ideally I would generate the SAS code, but since
> the data resides
> >on the mainframe I will have already created the reports.
> Basically I
> >want the cell contents to be an HREF with variable data.
> >
> >DATE         TOTAL USERS    TOTAL CPU
> >DAY1              1,980                 478.9
> >DAY2              1,786                 456.9