Hyperlinked Results

James_Schardt_(LMGTUser1_(Delete)_2167537)

Is there a way to hyperlink results from a LiveReport? I am creating a LiveReport for RFS (Request for Service) requests. The manager wants a LiveReport to show all "Open" requests and have a mechanism to click on each request to see the associated data.Is this possible?

Find more posts tagged with

Comments

BSandUser4_(Delete)_567006

You can try: select dtree.* from dtree where...

TestDeleteDocument.ipp

Bernhard_Schoen_(bschoen_-_(deleted))

What I observed is that the SQL has to have"SELECT * FROM dtree" or "SELECT * FROM kuaf" when you want the Report to display Links to the objects.If you want additional Information from other tables, it seems that you have to specify the fields individually, like"SELECT dtree.*, othertable.fieldname_1, othertable.fieldname_n FROM dtree, othertable" (and then an appropriate WHERE-clause , of course)

Chad Latka

I had this issue before and found that hyperlinked items worked when adding the following Dtree fields:Dtree.PermID fieldDtree.GIF field