Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PLACE LINKS TO COMPOUND DOCUMENTS IN A LIVEREPORT

Status
Not open for further replies.

alexsandro9

Programmer
Jul 13, 2013
20
IT
Hi experts,

i'm trying to insert links to a compound document in my livereport.
My report shows all the documents that need to be signed in a week but the report is still missing those clickable links
Do you know if there is a place (field) in the schema where this informations is stored and hence can be retrieved
or the only way to get this link would be with a custom functionality that "builds" it with url concatenations?

Thanks in advance,

Best regards
 
Hi,

LiveReports can mimic the Livelink GUI a little bit.for this to work certain data is needed from DTREE based on DataIDs you want to show and optionally some information from the DVersData Table. ( size FileNane etc.)

in this case the LR has the structure of:

select DTree.* from DTree where Name = 'Single CD' and SubType = 136 /* i have one Compound Document in the system with that name */

also set the Report Format to LiveReport and not AutoLiveReport.



Everybody can manage the Deliverables from a Statement of Work. It takes a special talent to Deliver Quality. It takes endurance. Endurance creates distinction between true professionals and amateurs.
 
 https://jhp8nq.bn1304.livefilestore.com/y2powxnSGmU0FKhfRsuYboHX-37SHj_BkBgrnPqI4MJ5lNv7wYrSeaVgbjghJOhdGdYtv9cMrT6-2t2iZ-k5b98qTb1Cf8iKz98f0ZrDzpjcqc/LivReportResult.jpg
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top