LiveReport Parameter restrictions .... ( Posted by >> Shashank Ambekar)

Support_Lloyds_Register

Dear Friends,We seem to be facing an issue with live reports. We have a SQL query for a live report working perfectly fine on our Toad system on oracle. But when the same query is taken back to livelink report after substituting the variables with the input parameters say %1,% 2,.. etc. as required in livelink. We get an error on executing. We have around 14 variable (often repeating) substitutions in our query, but livelink does not seem to recognize the variable substitutions after the seventh variable in the query. The variable are seen to be named properly as :A1, :A2,:A3 ,.....till :A6 in the error query message, but then after that the variables show a junk character in them.Is this something to do with number of parameters acceptable limit for livelink. Is there anyway of a work-around for this issue.Also let us know the feasibility of writing a request handler ?& module for executing this query via a script, and showing the results in a customized weblingo output file. Would appreciate your opinion on both the issues above.Regards,Shashank AmbekarEmail : shashank.ambekar@capgemini.comTel: 91-22-5555 7056

Steven_Osborn_(sosborn_(Delete)_2694748)

Message from Steven Osborn via eLinkShashank,LiveReports imposes a limit on the number of % parameters you may havein a LiveReport. I think you can have up to 7 or 8 substitutions. There are ways to optimize the use of % parms in LiveReports - e.g. on aDTREE report you could replace a filter for folders with "wheresubtype=0". If this isn't going to help you I know that some customershave patched LiveReports to allow more substitutions.You could certainly write custom request handler to execute your SQL andoutput the results in a custom weblingo. However you might want toconsider the WebReports module which provides a way to implement anynumber of "custom" reports giving total freedom in the output format(including HTML, XML, CSV; any text format in fact). There are lots ofother features such as scheduling reports, storing report results asdocuments in Livelink, or sending them by email. This module removesthe need to write a new custom module for each report that can't be donewith a standard LiveReport. WebReports provides unlimited parameters for filtering in the WebReportitself which may help your situation. In addition, LiveReportExtensions (a module bundled with WebReports) allows full stringsubstitution parameters in the LiveReport which can be used to pass morethan one clause (or indeed the whole SQL query if so desired). I'veused this before to avoid the LiveReport parameter limit.Cheers,Steve. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 19 July 2004 09:18To: eLink RecipientSubject: LiveReport Parameter restrictions .... ( Posted by >> ShashankAmbekar)LiveReport Parameter restrictions .... ( Posted by >> Shashank Ambekar)   Posted by LloydsUser2 (Campbell, Philip) on 07/19/2004 04:14 AM  Dear Friends,We seem to be facing an issue with live reports. We have a SQL query fora live report working perfectly fine on our Toad system on oracle. Butwhen the same query is taken back to livelink report after substitutingthe variables with the input parameters say %1,% 2,.. etc. as requiredin livelink. We get an error on executing. We have around 14 variable (often repeating) substitutions in our query,but livelink does not seem to recognize the variable substitutions afterthe seventh variable in the query. The variable are seen to be namedproperly as :A1, :A2,:A3 ,.....till :A6 in the error query message, butthen after that the variables show a junk character in them.Is this something to do with number of parameters acceptable limit forlivelink. Is there anyway of a work-around for this issue.Also let us know the feasibility of writing a request handler ?& modulefor executing this query via a script, and showing the results in acustomized weblingo output file. Would appreciate your opinion on boththe issues above.Regards,Shashank AmbekarEmail : shashank.ambekar@capgemini.comTel: 91-22-5555 7056[To reply to this thread, use your normal E-mail reply function.] Discussion: Livelink LiveReports Discussion Livelink Server: Knowledge Center __________ NOD32 1.814 (20040716) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.com