Chart Hyperlink in BIRT Maximo 7.6

<p>Hello Folks ,</p>
<p> </p>
<p>Hyperlink(drill through) from Chart is not working when I upload the report in Maximo . It is working in Designer though.It gives me error </p>
<p> </p>
<p><strong>Error 401: SRVE0295E: Error reported: 401</strong></p>
<p> </p>
<p>Interestingly, hyperlink is working on the table row (using the same data set as chart and every thing remains the same). </p>
<p>Has anyone encountered something like this ?</p>
<p> </p>
<p>Thanks </p>
<p> </p>
<p>Vineet</p>

Find more posts tagged with

Comments

Vineet Joshi

<p>An update on this , the __requestid is not passing through the chart leading to that error but is passing through the table.</p>

Vineet Joshi

<p>Any update any one . </p>
<p> </p>
<p>In the mean time Please have a look at the attachment the report hyperlink is working fine from inside table but not from CHart (in maximo)</p>
<p> </p>
<p>Let me know if anyone comes up with something. </p>

Vineet Joshi

<div>Other report in XML format because of Upload issue </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><?xml version="1.0" encoding="UTF-8"?></div>
<div><report xmlns="<a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a>version="3.2.23" id="1"> </div>
<div> <property name="comments">Copyright (c) 2006 <<Your Company Name here>></property></div>
<div> <property name="createdBy">Eclipse BIRT Designer Version 4.3.1.v201309091055 Build <4.3.1.v20130917-1035></property></div>
<div> <html-property name="description">This template will create a report with one or more groups, each having identical data fields.</html-property></div>
<div> <simple-property-list name="includeResource"></div>
<div> <value>routes</value></div>
<div> </simple-property-list></div>
<div> <property name="units">in</property></div>
<div> <method name="initialize"><![CDATA[importPackage(Packages.com.ibm.tivoli.maximo.report.script);</div>
<div> </div>
<div>mxReportScriptContext = MXReportScriptContext.initialize(reportContext);</div>
<div> </div>
<div>mxReportScriptContext.setDefaultLogLevel("DEBUG");</div>
<div>mxReportScriptContext.setDefaultLogFile("C:/temp/hypertest2.log");]]></method></div>
<div> <method name="afterFactory"><![CDATA[MXReportScriptContext.close();]]></method></div>
<div> <property name="theme">MaximoSystemLibrary.maximoTheme</property></div>
<div> <text-property name="displayName">Tivoli Maximo Grouped Template</text-property></div>
<div> <property name="layoutPreference">auto layout</property></div>
<div> <list-property name="libraries"></div>
<div> <structure></div>
<div> <property name="fileName">MaximoSystemLibrary.rptlibrary</property></div>
<div> <property name="namespace">MaximoSystemLibrary</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <parameters></div>
<div> <scalar-parameter name="where" id="25"></div>
<div> <property name="valueType">static</property></div>
<div> <property name="isRequired">false</property></div>
<div> <property name="dataType">string</property></div>
<div> <property name="distinct">true</property></div>
<div> <simple-property-list name="defaultValue"></div>
<div> <value type="constant">1=1</value></div>
<div> </simple-property-list></div>
<div> <list-property name="selectionList"/></div>
<div> <property name="paramType">simple</property></div>
<div> <property name="controlType">text-box</property></div>
<div> <structure name="format"></div>
<div> <property name="category">Unformatted</property></div>
<div> </structure></div>
<div> </scalar-parameter></div>
<div> <scalar-parameter name="appname" id="240"></div>
<div> <property name="valueType">static</property></div>
<div> <property name="isRequired">false</property></div>
<div> <property name="dataType">string</property></div>
<div> <property name="controlType">text-box</property></div>
<div> <structure name="format"></div>
<div> <property name="category">Unformatted</property></div>
<div> </structure></div>
<div> </scalar-parameter></div>
<div> <scalar-parameter name="paramdelimiter" id="241"></div>
<div> <property name="hidden">true</property></div>
<div> <property name="valueType">static</property></div>
<div> <property name="isRequired">false</property></div>
<div> <property name="dataType">string</property></div>
<div> <property name="controlType">text-box</property></div>
<div> <structure name="format"></div>
<div> <property name="category">Unformatted</property></div>
<div> </structure></div>
<div> </scalar-parameter></div>
<div> <scalar-parameter name="paramstring" id="242"></div>
<div> <property name="hidden">true</property></div>
<div> <property name="valueType">static</property></div>
<div> <property name="isRequired">false</property></div>
<div> <property name="dataType">string</property></div>
<div> <property name="controlType">text-box</property></div>
<div> <structure name="format"></div>
<div> <property name="category">Unformatted</property></div>
<div> </structure></div>
<div> </scalar-parameter></div>
<div> <scalar-parameter name="p_worktp" id="3491"></div>
<div> <property name="valueType">static</property></div>
<div> <property name="dataType">string</property></div>
<div> <property name="distinct">true</property></div>
<div> <simple-property-list name="defaultValue"></div>
<div> <value type="constant">PM</value></div>
<div> </simple-property-list></div>
<div> <list-property name="selectionList"/></div>
<div> <property name="paramType">simple</property></div>
<div> <property name="controlType">text-box</property></div>
<div> <structure name="format"></div>
<div> <property name="category">Unformatted</property></div>
<div> </structure></div>
<div> </scalar-parameter></div>
<div> </parameters></div>
<div> <data-sources></div>
<div> <script-data-source name="maximoDataSource" id="64" extends="MaximoSystemLibrary.maximoDataSource"/></div>
<div> </data-sources></div>
<div> <data-sets></div>
<div> <script-data-set name="dataSet" id="5"></div>
<div> <list-property name="resultSetHints"></div>
<div> <structure></div>
<div> <property name="position">1</property></div>
<div> <property name="name">worktype</property></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> <structure></div>
<div> <property name="position">2</property></div>
<div> <property name="name">wonum</property></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <list-property name="columnHints"></div>
<div> <structure></div>
<div> <property name="columnName">worktype</property></div>
<div> </structure></div>
<div> <structure></div>
<div> <property name="columnName">wonum</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <structure name="cachedMetaData"></div>
<div> <list-property name="resultSet"></div>
<div> <structure></div>
<div> <property name="position">1</property></div>
<div> <property name="name">worktype</property></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> <structure></div>
<div> <property name="position">2</property></div>
<div> <property name="name">wonum</property></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> </structure></div>
<div> <property name="dataSource">maximoDataSource</property></div>
<div> <method name="open"><![CDATA[maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());</div>
<div>maximoDataSet.open();</div>
<div> </div>
<div>var sqlText = new String();</div>
<div> </div>
<div>if (BirtStr.toUpper(params["p_worktp"].value) !='ALL' ) {</div>
<div> params["p_worktp"]= BirtStr.toUpper(params["p_worktp"].value.replace(/=/g , ""));</div>
<div> params["p_worktp"] =params["p_worktp"].value.replace(/,/g , "','");</div>
<div> p_worktp = " and workorder.worktype in ('" + params["p_worktp"]+"') ";</div>
<div> params["p_worktp"]= params["p_worktp"].value.replace(/','/g , ", ");</div>
<div>}</div>
<div>else{</div>
<div>params["p_worktp"]= BirtStr.toUpper(params["p_worktp"].value.replace(/=/g , ""));</div>
<div>p_worktp= " and 1=1 "</div>
<div>}</div>
<div> </div>
<div> </div>
<div> </div>
<div>sqlText = " Select wonum, worktype from workorder where " + params["where"] </div>
<div>+ p_worktp </div>
<div>;</div>
<div> </div>
<div>maximoDataSet.setQuery(sqlText);]]></method></div>
<div> <method name="fetch"><![CDATA[if (!maximoDataSet.fetch())</div>
<div>return (false);</div>
<div> </div>
<div> </div>
<div>row["worktype"] = maximoDataSet.getString("worktype");</div>
<div>row["wonum"] = maximoDataSet.getString("wonum");</div>
<div> </div>
<div> </div>
<div> </div>
<div>return (true);]]></method></div>
<div> </script-data-set></div>
<div> </data-sets></div>
<div> <page-setup></div>
<div> <simple-master-page name="NewSimpleMasterPage" id="381"></div>
<div> <property name="orientation">portrait</property></div>
<div> <property name="topMargin">0in</property></div>
<div> <page-header></div>
<div> <grid id="3240"></div>
<div> <property name="borderBottomStyle">solid</property></div>
<div> <property name="borderBottomWidth">thin</property></div>
<div> <property name="marginTop">0%</property></div>
<div> <property name="marginLeft">0%</property></div>
<div> <property name="marginBottom">0%</property></div>
<div> <property name="marginRight">0%</property></div>
<div> <property name="verticalAlign">top</property></div>
<div> <property name="width">100%</property></div>
<div> <list-property name="boundDataColumns"></div>
<div> <structure></div>
<div> <property name="name">Column Binding</property></div>
<div> <expression name="expression">BirtDateTime.now()</expression></div>
<div> <property name="dataType">date-time</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <column id="3241"></div>
<div> <property name="fontSize">20%</property></div>
<div> <property name="width">21%</property></div>
<div> </column></div>
<div> <column id="3242"></div>
<div> <property name="width">57%</property></div>
<div> </column></div>
<div> <column id="3243"></div>
<div> <property name="width">22%</property></div>
<div> </column></div>
<div> <row id="3244"></div>
<div> <cell id="3245"></div>
<div> <property name="colSpan">1</property></div>
<div> <property name="rowSpan">1</property></div>
<div> <property name="fontSize">20%</property></div>
<div> <property name="paddingLeft">1pt</property></div>
<div> <property name="paddingBottom">1pt</property></div>
<div> <property name="verticalAlign">bottom</property></div>
<div> </cell></div>
<div> <cell id="3247"></div>
<div> <property name="paddingTop">1pt</property></div>
<div> <property name="paddingBottom">1pt</property></div>
<div> <property name="verticalAlign">middle</property></div>
<div> </cell></div>
<div> <cell id="3259"></div>
<div> <property name="paddingBottom">1pt</property></div>
<div> <property name="verticalAlign">bottom</property></div>
<div> <text id="3267"></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="color">#000000</property></div>
<div> <property name="textAlign">right</property></div>
<div> <property name="contentType">html</property></div>
<div> <text-property name="content"><![CDATA[<value-of>MXReportScriptContext.get().getUserDate()</value-of>]]></text-property></div>
<div> </text></div>
<div> </cell></div>
<div> </row></div>
<div> </grid></div>
<div> </page-header></div>
<div> <page-footer></div>
<div> <grid id="1182"></div>
<div> <property name="width">100%</property></div>
<div> <column id="448"></div>
<div> <property name="width">50%</property></div>
<div> </column></div>
<div> <column id="472"></div>
<div> <property name="width">30%</property></div>
<div> </column></div>
<div> <column id="474"></div>
<div> <property name="width">20%</property></div>
<div> </column></div>
<div> <row id="452"></div>
<div> <cell id="453"></div>
<div> <property name="colSpan">1</property></div>
<div> <property name="rowSpan">1</property></div>
<div> <property name="borderTopColor">#000000</property></div>
<div> <property name="borderTopStyle">solid</property></div>
<div> <property name="borderTopWidth">thin</property></div>
<div> <property name="paddingLeft">4pt</property></div>
<div> </cell></div>
<div> <cell id="471"></div>
<div> <property name="borderTopColor">#000000</property></div>
<div> <property name="borderTopStyle">solid</property></div>
<div> <property name="borderTopWidth">thin</property></div>
<div> </cell></div>
<div> <cell id="473"></div>
<div> <property name="colSpan">1</property></div>
<div> <property name="rowSpan">1</property></div>
<div> <property name="borderTopColor">#000000</property></div>
<div> <property name="borderTopStyle">solid</property></div>
<div> <property name="borderTopWidth">thin</property></div>
<div> <property name="textAlign">right</property></div>
<div> <grid id="1979"></div>
<div> <property name="fontSize">7pt</property></div>
<div> <property name="fontStyle">italic</property></div>
<div> <property name="verticalAlign">top</property></div>
<div> <property name="width">100%</property></div>
<div> <column id="1993"></div>
<div> <property name="textAlign">right</property></div>
<div> <property name="width">70%</property></div>
<div> </column></div>
<div> <column id="1980"></div>
<div> <property name="textAlign">center</property></div>
<div> <property name="verticalAlign">top</property></div>
<div> <property name="width">10%</property></div>
<div> </column></div>
<div> <column id="1981"></div>
<div> <property name="textAlign">center</property></div>
<div> <property name="verticalAlign">top</property></div>
<div> <property name="width">10%</property></div>
<div> </column></div>
<div> <column id="1982"></div>
<div> <property name="textAlign">right</property></div>
<div> <property name="verticalAlign">top</property></div>
<div> <property name="width">10%</property></div>
<div> </column></div>
<div> <row id="1983"></div>
<div> <property name="verticalAlign">top</property></div>
<div> <cell id="1992"></div>
<div> <property name="verticalAlign">top</property></div>
<div> <label id="1994"></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="fontSize">7pt</property></div>
<div> <property name="color">#003466</property></div>
<div> <property name="textAlign">right</property></div>
<div> <text-property name="text">Page</text-property></div>
<div> </label></div>
<div> </cell></div>
<div> <cell id="1984"></div>
<div> <auto-text id="1985"></div>
<div> <property name="backgroundAttachment">scroll</property></div>
<div> <property name="backgroundPositionX">0%</property></div>
<div> <property name="backgroundPositionY">0%</property></div>
<div> <property name="backgroundRepeat">repeat</property></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="fontSize">7pt</property></div>
<div> <property name="fontWeight">normal</property></div>
<div> <property name="fontStyle">italic</property></div>
<div> <property name="fontVariant">normal</property></div>
<div> <property name="color">#003466</property></div>
<div> <property name="textLineThrough">none</property></div>
<div> <property name="textOverline">none</property></div>
<div> <property name="textUnderline">none</property></div>
<div> <property name="borderBottomColor">black</property></div>
<div> <property name="borderBottomStyle">none</property></div>
<div> <property name="borderBottomWidth">medium</property></div>
<div> <property name="borderLeftColor">black</property></div>
<div> <property name="borderLeftStyle">none</property></div>
<div> <property name="borderLeftWidth">medium</property></div>
<div> <property name="borderRightColor">black</property></div>
<div> <property name="borderRightStyle">none</property></div>
<div> <property name="borderRightWidth">medium</property></div>
<div> <property name="borderTopColor">black</property></div>
<div> <property name="borderTopStyle">none</property></div>
<div> <property name="borderTopWidth">medium</property></div>
<div> <property name="marginTop">0pt</property></div>
<div> <property name="marginLeft">0pt</property></div>
<div> <property name="marginBottom">0pt</property></div>
<div> <property name="marginRight">0pt</property></div>
<div> <property name="paddingTop">1pt</property></div>
<div> <property name="paddingLeft">1pt</property></div>
<div> <property name="paddingBottom">1pt</property></div>
<div> <property name="paddingRight">1pt</property></div>
<div> <property name="textAlign">right</property></div>
<div> <property name="letterSpacing">normal</property></div>
<div> <property name="lineHeight">normal</property></div>
<div> <property name="textTransform">none</property></div>
<div> <property name="whiteSpace">normal</property></div>
<div> <property name="wordSpacing">normal</property></div>
<div> <property name="display">block</property></div>
<div> <property name="pageBreakAfter">auto</property></div>
<div> <property name="pageBreakBefore">auto</property></div>
<div> <property name="pageBreakInside">auto</property></div>
<div> <property name="showIfBlank">false</property></div>
<div> <property name="canShrink">false</property></div>
<div> <property name="overflow">hidden</property></div>
<div> <property name="type">page-number</property></div>
<div> </auto-text></div>
<div> </cell></div>
<div> <cell id="1986"></div>
<div> <property name="textAlign">center</property></div>
<div> <text id="1987"></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="fontSize">7pt</property></div>
<div> <property name="color">#003466</property></div>
<div> <property name="textAlign">center</property></div>
<div> <property name="contentType">plain</property></div>
<div> <text-property name="content"><![CDATA[of]]></text-property></div>
<div> </text></div>
<div> </cell></div>
<div> <cell id="1988"></div>
<div> <property name="textAlign">right</property></div>
<div> <auto-text id="1989"></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="fontSize">7pt</property></div>
<div> <property name="color">#003466</property></div>
<div> <property name="paddingRight">1pt</property></div>
<div> <property name="textAlign">right</property></div>
<div> <property name="type">total-page</property></div>
<div> </auto-text></div>
<div> </cell></div>
<div> </row></div>
<div> </grid></div>
<div> </cell></div>
<div> </row></div>
<div> </grid></div>
<div> </page-footer></div>
<div> </simple-master-page></div>
<div> </page-setup></div>
<div> <body></div>
<div> <table id="3492"></div>
<div> <property name="fontFamily">"Verdana"</property></div>
<div> <property name="dataSet">dataSet</property></div>
<div> <list-property name="boundDataColumns"></div>
<div> <structure></div>
<div> <property name="name">worktype</property></div>
<div> <text-property name="displayName">worktype</text-property></div>
<div> <expression name="expression" type="javascript">dataSetRow["worktype"]</expression></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> <structure></div>
<div> <property name="name">wonum</property></div>
<div> <text-property name="displayName">wonum</text-property></div>
<div> <expression name="expression" type="javascript">dataSetRow["wonum"]</expression></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> <structure></div>
<div> <property name="name">Aggregation</property></div>
<div> <property name="dataType">integer</property></div>
<div> <property name="aggregateFunction">COUNT</property></div>
<div> <list-property name="arguments"></div>
<div> <structure></div>
<div> <property name="name">Expression</property></div>
<div> <expression name="value" type="javascript">row["wonum"]</expression></div>
<div> </structure></div>
<div> </list-property></div>
<div> <property name="allowExport">true</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <column id="3506"/></div>
<div> <column id="3507"/></div>
<div> <header></div>
<div> <row id="3493"></div>
<div> <cell id="3494"></div>
<div> <label id="3495"></div>
<div> <text-property name="text">worktype</text-property></div>
<div> </label></div>
<div> </cell></div>
<div> <cell id="3496"></div>
<div> <label id="3497"></div>
<div> <text-property name="text">wonum</text-property></div>
<div> </label></div>
<div> </cell></div>
<div> </row></div>
<div> </header></div>
<div> <detail></div>
<div> <row id="3498"></div>
<div> <cell id="3499"></div>
<div> <data id="3500"></div>
<div> <property name="resultSetColumn">worktype</property></div>
<div> </data></div>
<div> </cell></div>
<div> <cell id="3501"></div>
<div> <data id="3502"></div>
<div> <property name="resultSetColumn">wonum</property></div>
<div> </data></div>
<div> </cell></div>
<div> </row></div>
<div> </detail></div>
<div> <footer></div>
<div> <row id="3503"></div>
<div> <cell id="3504"></div>
<div> <data id="3508"></div>
<div> <property name="resultSetColumn">Aggregation</property></div>
<div> </data></div>
<div> </cell></div>
<div> <cell id="3505"/></div>
<div> </row></div>
<div> </footer></div>
<div> </table></div>
<div> </body></div>
<div></report></div>
<div> </div>

Latif_Patel08

hi Vineet ,
Still this is open ?

Hariskhan.cs

Hi ,

Any one have update on above issue, i am facing the same

regards