Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
List Item Parameter giving error in Web Browser
skumar16jan
<p>Dear All,</p><p> </p><p>Request you to advice how to show list item while selecting parameter in BIRT Report.</p><p> </p><p>I checked with all option of Preview Preferences compatibility but still same error.</p><p> </p><p>For example.</p><p> </p><p>Parameter window: Plan Type : <list item> 'ALL'</p><p> 'PLAN1'</p><p> 'PLAN2'</p><p> 'PLAN3'</p><p> </p><p>Giving error in browser:</p><p>"Object Expected</p><p>Frameset Line:85</p><p>Code:0 Char:1'</p><p> </p><p>where in xmlsource at line:85 code is used as below:</p><p> </p><div> <scalar-parameter name="P_LOB" id="830"></div><div> <text-property name="promptText">Lines Of Business</text-property></div><div> <property name="valueType">dynamic</property></div><div> <property name="dataSetName">DS_LOB</property></div><div> <expression name="valueExpr" type="javascript">dataSetRow["LOB"]</expression></div><div> <expression name="labelExpr" type="javascript">dataSetRow["LOB"]</expression></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">ALL</value></div><div> </simple-property-list></div><div> <list-property name="selectionList"/></div><div> <property name="paramType">simple</property></div><div> <property name="controlType">list-box</property></div><div> <property name="mustMatch">true</property></div><div> <property name="fixedOrder">true</property></div><div> <structure name="format"></div><div> <property name="category">Unformatted</property></div><div> </structure></div><div> </scalar-parameter></div>
Find more posts tagged with
Comments
kclark
<p>Can you post your rptdesign please?</p>
skumar16jan
<p>Dear Clark,</p><p> </p><p>Kindly refer the attachment and do the needful help.</p><p> </p><p>Regards,</p><p>SK</p>
skumar16jan
<div>Hi, </div><div> </div><div>Please refer the attachment and below sample table and function:</div><div> </div><div>CREATE TABLE SK_EMP</div><div>(</div><div> EMPNO VARCHAR2(20 BYTE) NOT NULL,</div><div> EMPNAME VARCHAR2(100 BYTE),</div><div> ADDRESS VARCHAR2(300 BYTE),</div><div> DEPTNO NUMBER</div><div>)</div><div>LOGGING </div><div>NOCOMPRESS </div><div>NOCACHE</div><div>NOPARALLEL</div><div>MONITORING;</div><div> </div><div> </div><div><span class='bbc_underline'><strong>FUnction USED:(Optional):</strong></span></div><div> </div><div><div>FUNCTION BFN_GET_EMPNO(P_EMPNO VARCHAR2) RETURN VARCHAR2 IS</div><div>CURSOR cr_empno IS</div><div> SELECT EMPNAME FROM SK_EMP WHERE EMPNAME = P_EMPNO;</div><div> lv_emp VARCHAR2(200);</div><div> </div><div>BEGIN</div><div> OPEN cr_empno;</div><div> FETCH cr_empno INTO lv_emp;</div><div> IF cr_empno%notfound AND ((P_EMPNO = 'ALL' OR P_EMPNO IS NULL OR P_EMPNO = '%') ) THEN</div><div> lv_emp := 'ALL POLICIES';</div><div> END IF; </div><div> CLOSE cr_empno;</div><div> </div><div> RETURN lv_emp;</div><div> </div><div> </div><div>END; </div><div> </div></div><p> </p>
skumar16jan
<p>Hi,</p><p> </p><p>Please advice on this.</p><p> </p><p>Regards,</p><p>Satinder kumar</p>