fxliagre

Hi all, I'm using jasperreports / iReport for several years, but recently tried to use the "HTML markup" capability. I worked perfectly in iReport (I'm using 4.0.1, configured to save in 3.0.0 compatable version, because of installed software constrainst) but at runtime, the markup is ignored (I mean the <b> </b> or <i> </i> tags are not displayed, but the enclosed text is NOT printed as bold... The use of this markup is in $P{} fields, we are running on JRE 1.6.0_06-b02. The problem exists with PDF and HTML output. The problem exists in two configuration I am using : webapp (Tomcat 6.0.16) and plain java app I did not - for now - succeed in finding similar thread / replies about this specific problem... Thanks for helping

Additional info : I forgot to mention : TOS Version: 2.3.2 Build id: r12707-20080331-1117 And the reason of the error seems to be a improper code generation (lookup links are called BEFORE the tFileList component is executed !) : tFileInputXML_3Process(); tFileInputXML_4Process(); tFileInputXML_5Process(); use the global map, which one is filled by the tFileList execution which occurs... only later ! Code: public void tFileList_1Process() throws TalendException { try { tFileInputXML_3Process(); tFileInputXML_4Process(); tFileInputXML_5Process(); row1Struct row1 = new row1Struct(); row1Struct row3 = row1; row2Struct row2 = new row2Struct(); setsStruct sets = new setsStruct(); logStruct log = new logStruct(); logSetsStruct logSets = new logSetsStruct(); /** * [tFileList_1 begin ] start */ ok_Hash.put("tFileList_1", false); start_Hash.put("tFileList_1", System.currentTimeMillis()); currentComponent = "tFileList_1"; // tFileList_Begin String directory_tFileList_1 = "C:/Program Files/Apache Software Foundation/Tomcat 5.0/webapps/promotion/export"; String filemask_tFileList_1 = "*.xml" + "$"; // etc... But everything I tried always produce this generation... Post edited by: fxliagre, at: 2008/04/11 15:44

I'm currently building a job parsing and loading an XML file in several DB tables. I have one tFileInputXML "main", and 3 others "lookup", each of them defining and processing the same file. Then I try to add, as an entry, a tFileListComponent looking and iterating on xml files in a directory (for the test, only one file in the directory). I replaced in my 4 tFileInputXML the absolute file name by the variable ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) The first (main) tFileInputXML works perfectly, but the 3 others fails saying "null pointer exception" The generated source shows the error line as : org.dom4j.Document doc_tFileInputXML_3 = reader_tFileInputXML_3 .read(new java.io.FileInputStream(((String) globalMap .get("tFileList_1_CURRENT_FILEPATH")))); Any idea to help ?

In other terms, why am I not able to do the same things using the OLAP navigator and MDX query tool of then view itself, and the MDX query tool of the workbench, or the MDX query definition in jasperserver ?

I have a simple schema : Code:<Schema name="testTXN" measuresCaption="Sales Results"> <Dimension type="TimeDimension" name="Time" caption="By time"> <Hierarchy name="timeHier" hasAll="true" allMemberName="All time" allMemberCaption="All time day" allLevelName="All time" primaryKey="tradingdate"> <Table name="calendar"> </Table> <Level name="Year" column="calendaryear" type="Numeric" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" column="calendarmonth" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="DayDate" column="tradingdate" type="Date" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> </Level> </Hierarchy> <Hierarchy name="timeHierWeekly" hasAll="true" allMemberName="All time" allMemberCaption="All time week" allLevelName="All time" primaryKey="tradingdate"> <Table name="calendar"> </Table> <Level name="Year" column="calendaryear" type="Numeric" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" column="calendarmonth" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="Week" column="calendarweek" type="Numeric" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" name="Transactiontype" caption="By transaction type"> <Hierarchy name="transactiontypeHier" hasAll="true" allMemberName="All transactions" allMemberCaption="All transactions" allLevelName="All transactions" primaryKey="transactiontype" primaryKeyTable="transactiontype"> <Table name="transactiontype"> </Table> <Level name="transLevel" column="transactiontype" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" caption="Transaction types"> </Level> </Hierarchy> </Dimension> <Cube name="Sales" cache="true" enabled="true"> <Table name="txnheader" schema="public"> </Table> <DimensionUsage source="Time" name="Time" foreignKey="tradingdate"> </DimensionUsage> <DimensionUsage source="Transactiontype" name="Transactiontype" foreignKey="transactiontype"> </DimensionUsage> <Measure name="SUMQTY" column="totalqty" datatype="Numeric" formatString="#,##0" aggregator="sum" caption="Qty sold"> </Measure> <Measure name="SUMDUE" datatype="Numeric" formatString="#,###.##" aggregator="sum" caption="Net Amount"> <MeasureExpression> <SQL dialect="generic"> cast(valuedue as numeric) </SQL> </MeasureExpression> </Measure> </Cube> </Schema> I also defined a simple analysis view : Code:[code]select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY Hierarchize({[Time.timeHier].[All time].Members}) ON ROWS from [sales] When I display the view, I am able to add the "transactiontype" dimension to the result. Then, if I display the MDX query, it looks like : Code:[code]select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] But... :( When I try to replace to initial MDX view definition by this request, either in the jasperserver or using the MDX query tool, I obtain the following error : Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] ' Mondrian Error:Error while parsing MDX statement 'select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] ' Mondrian Error:No function matches signature '(<Level>, <Level>)' What do I miss ?