Whether Drill through report work in we based application

hi,

Whether Drill through report work in web based application.

drill through report is working fine in the designer but its not working when deployed .

My project is a web application .

Thanks ,
Glassy

Find more posts tagged with

Comments

JasonW

Drill through should work in the web. How did you define the drill through? Is the target report in the same folder as the master report?

Jason

Glassy

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="76606" data-time="1304524059" data-date="04 May 2011 - 08:47 AM"><p>
Drill through should work in the web. How did you define the drill through? Is the target report in the same folder as the master report?<br />
<br />
Jason<br /></p></blockquote>
<br />
<br />
hai Jason , <br />
<br />
Thanks for your reply . <br />
<br />
yes i am having both the report in the same folder . <br />
<br />
The master report is integrated with the a jsf page .<br />
<br />
I am new to Drill report . I am working in a web based project . In that i am having a master report and a child report . when i am clicking the hyperlink in the master report its not showing the child report Or navigating to the child report .<br />
<br />
Its throwing a error .<br />
<br />
The requested resource (/joekidssample/pages/users/common/all/attendance/run) is not available.<br />
<br />
and the url will look like this <br />
<br />
<br />
<a class='bbc_url' href='http://localhost:8080/joekidssample/pages/users/common/all/attendance/run?__report=/D:/jboss-5.1.0.GA/bin/ChildTEmp.rptdesign&student_Id=2935&__overwrite=true'>http://localhost:8080/joekidssample/pages/users/common/all/attendance/run?__report=/D:/jboss-5.1.0.GA/bin/ChildTEmp.rptdesign&student_Id=2935&__overwrite=true</a> <br />
<br />
whether the problem lies because of master report can't found the child report Or with the jsf .<br />
<br />
Thanks in advance .<br />
<br />
Regards,<br />
Glassy

JasonW

can you post the master report design?

Jason

Glassy

Hi Jason ,

Thanks for your Reply .

I have attached the report design .

I hope this gives you some information .

Thanks in advance .

#########################################
Report Design :-

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208 Build <2.5.2.v20100210-0630></property>
<property name="units">in</property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">333</property>
</structure>
<structure>
<property name="name">queryTimeOut</property>
<property name="id">333</property>
</structure>
</list-property>
<method name="initialize"><![CDATA[function buildWhereClause(paramName, fieldName, addQuotes) {
var paramVal = reportContext.getParameterValue(paramName);
var allCustParam = reportContext.getParameterValue("AllCustomers");

if (paramVal == null || paramVal == "null" || paramVal == "") {
return "";
} else if (paramVal.length > 0) {
var paramValTmp = '';
for (j = 0; j < paramVal.length; j++) {
if (paramVal[j] != null && paramVal[j] != "null") {
if (j > 0) {
paramValTmp += ",";
}
if (addQuotes)
paramValTmp += "'" + paramVal[j] + "'";
else
paramValTmp += paramVal[j];
}
}
return " AND " + fieldName + " IN (" + paramValTmp + ") ";
} else {
if (addQuotes)
return " AND " + fieldName + " = '" + paramVal + "' ";
else
return " AND " + fieldName + " = " + paramVal + " ";
}
}]]></method>
<method name="beforeFactory"><![CDATA[importPackage(Packages.com.nayasoft.joekids.utils);
property = new BirtNJDIConstant()
ds = reportContext.getDesignHandle().getDesign().findDataSource("DataSource");
ds.setProperty( "odaJndiName", property.JNDINAME);]]></method>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">fixed layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="SCHOOL_ID" id="748">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">integer</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="FROM_DATE" id="996">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="SCHOOL_YEAR" id="1198">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="SCHOOL_NAME" id="2613">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="SelectedDate" id="2634">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Link" id="3035">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">/pages/users/common/all/attendance/Report/</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="DataSource" id="230">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://192.168.1.4:3306/test</property>
<property name="odaUser">mysqldb</property>
<encrypted-property name="odaPassword" encryptionID="base64">bXlzcWxkYg==</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="School_Dataset" id="333">
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">FROM_DATE</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">SCHOOL_YEAR</property>
<property name="dataType">string</property>
<property name="position">3</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_4</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">4</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_5</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">5</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_6</property>
<property name="paramName">FROM_DATE</property>
<property name="dataType">string</property>
<property name="position">6</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_7</property>
<property name="paramName">SCHOOL_YEAR</property>
<property name="dataType">string</property>
<property name="position">7</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_8</property>
<property name="paramName">SCHOOL_YEAR</property>
<property name="dataType">string</property>
<property name="position">8</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DOA</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">S_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SCH_YR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">STAFF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">STAT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">A</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">L</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">P</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">OD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">UTYPE</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">ID</property>
<property name="nativeName">ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">SES</property>
<property name="nativeName">SES</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DOA</property>
<property name="nativeName">DOA</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">S_ID</property>
<property name="nativeName">S_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">SCH_YR</property>
<property name="nativeName">SCH_YR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">STAFF_NAME</property>
<property name="nativeName">STAFF_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">STAT</property>
<property name="nativeName">STAT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">A</property>
<property name="nativeName">A</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">L</property>
<property name="nativeName">L</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">P</property>
<property name="nativeName">P</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">OD</property>
<property name="nativeName">OD</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">UTYPE</property>
<property name="nativeName">UTYPE</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT A.USER_ID AS ID,

CASE A.SESSION_ID

WHEN

1 THEN 'FN'

WHEN

2 THEN 'AN'

END AS SES,

DATE_FORMAT(A.ATT_DATE, " %d/%m/%Y") AS DOA,

A.SCHOOL_ID AS S_ID,

A.SCHOOL_YEAR AS SCH_YR,

NULL AS STAFF_NAME,

CASE A.ATT_DETAIL

WHEN

'AL' THEN 'L'

WHEN

'A' THEN 'A'

WHEN

'OD' THEN 'OD'

ELSE

'PR'

END AS STAT,

NULL AS A,

NULL AS L,

NULL AS P,

NULL AS OD ,

U.USER_TYPE AS UTYPE

FROM NS_SCHOOL_ATTENDANCE A JOIN NS_USERS U

ON A.USER_ID = U.USER_ID

AND A.CLASS_ID = 0

WHERE A.USER_ID!=1

AND A.USER_ID!=2

AND A.SCHOOL_ID= ?

AND A.ATT_DATE = ?

AND A.SCHOOL_YEAR = ?

UNION

SELECT A1.USER_ID AS ID,

NULL AS SES,

NULL AS DOA,

A1.SCHOOL_ID AS S_ID,

A1.SCHOOL_YEAR AS SCH_YR,

CASE

WHEN U1.LAST_NAME IS NULL THEN U1.FIRST_NAME

WHEN U1.LAST_NAME = '' THEN U1.FIRST_NAME

ELSE CONCAT(U1.FIRST_NAME,'',U1.LAST_NAME)

END AS STUDENT_NAME,

CASE A1.ATT_DETAIL

WHEN

'AL' THEN ""

WHEN

'A' THEN ""

WHEN

'OD' THEN ""

ELSE

""

END AS STAT,

format((SUM(IF(A1.ATT_DETAIL='A',1,0))/2),1) AS A,

format((SUM(IF(A1.ATT_DETAIL='AL',1,0))/2),1) AS L,

format((SUM(IF(A1.ATT_DETAIL='PR',1,0))/2),1) AS P,

format((SUM(IF(A1.ATT_DETAIL='OD',1,0))/2),1) AS OD,

U1.USER_TYPE AS UTYPE

FROM NS_SCHOOL_ATTENDANCE A1 JOIN NS_USERS U1

ON A1.USER_ID = U1.USER_ID

AND A1.CLASS_ID = 0

WHERE A1.USER_ID!=1

AND A1.USER_ID!=2

AND A1.SCHOOL_ID= ?

AND A1.USER_ID IN (SELECT DISTINCT A.USER_ID AS ID

FROM NS_SCHOOL_ATTENDANCE A

WHERE A.USER_ID NOT IN (1,2)

AND CLASS_ID =0

AND A.SCHOOL_ID= ?

AND A.ATT_DATE = ?

AND A.SCHOOL_YEAR = ?)

AND A1.SCHOOL_YEAR = ?

GROUP BY ID

ORDER BY ID,DOA,SES,UTYPE;]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>id</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>id</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>id</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GRADE_ID</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>11</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>GRADE_ID</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>GRADE_ID</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STUDENTNAME</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>201</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>STUDENTNAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STUDENTNAME</design:label>
<design:formattingHints>
<design:displaySize>201</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>GRADE</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>GRADE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>GRADE</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SECTION</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>SECTION</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>SECTION</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>STUDENT_ROLL_NUMBER</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>15</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>STUDENT_ROLL_NUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>STUDENT_ROLL_NUMBER</design:label>
<design:formattingHints>
<design:displaySize>15</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>status</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>7</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>status</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>status</design:label>
<design:formattingHints>
<design:displaySize>7</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="CHART_FN" id="1455">
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">3</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_4</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">4</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_5</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">5</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_6</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">6</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CLASS_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CLASSNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">TOTALCOUNT</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CLASS_ID</property>
<property name="nativeName">CLASS_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CLASSNAME</property>
<property name="nativeName">CLASSNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">TOTALCOUNT</property>
<property name="nativeName">TOTALCOUNT</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT C1.CLASS_ID AS CLASS_ID,CONCAT(G1.GRADE,'-',C1.SECTION) AS CLASSNAME,COUNT(A1.USER_ID) AS TOTALCOUNT
FROM NS_SCHOOL_ATTENDANCE A1
JOIN NS_CLASS C1 ON A1.CLASS_ID=C1.CLASS_ID
JOIN NS_GRADE G1 ON C1.GRADE_ID=G1.GRADE_ID
WHERE A1.USER_ID!=1
AND A1.USER_ID!=2
AND C1.SCHOOL_ID=?
AND A1.SESSION_ID=1
AND A1.ATT_DATE = ?
GROUP BY C1.CLASS_ID

UNION

SELECT C2.CLASS_ID AS CLASS_ID,CONCAT(G2.GRADE,'-',C2.SECTION) AS CLASSNAME,0 AS TOTALCOUNT
FROM NS_SCHOOL_ATTENDANCE A2
JOIN NS_CLASS C2 ON A2.CLASS_ID=C2.CLASS_ID
JOIN NS_GRADE G2 ON C2.GRADE_ID=G2.GRADE_ID
WHERE A2.USER_ID=1
AND C2.SCHOOL_ID=?
AND A2.SESSION_ID=1
AND A2.ATT_DATE = ?
AND C2.CLASS_ID NOT IN (
SELECT C3.CLASS_ID AS CLASS_ID
FROM NS_SCHOOL_ATTENDANCE A3
JOIN NS_CLASS C3 ON A3.CLASS_ID=C3.CLASS_ID
JOIN NS_GRADE G3 ON C3.GRADE_ID=G3.GRADE_ID
WHERE A3.USER_ID!=1
AND A3.USER_ID!=2
AND C3.SCHOOL_ID=?
AND A3.SESSION_ID=1
AND A3.ATT_DATE = ?
GROUP BY C3.CLASS_ID
)
ORDER BY CLASS_ID ;]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="CHART_AN" id="1774">
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_3</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">3</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_4</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">4</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_5</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">5</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_6</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">6</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CLASS_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CLASSNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">TOTALCOUNT</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CLASS_ID</property>
<property name="nativeName">CLASS_ID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CLASSNAME</property>
<property name="nativeName">CLASSNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">TOTALCOUNT</property>
<property name="nativeName">TOTALCOUNT</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT C1.CLASS_ID AS CLASS_ID,CONCAT(G1.GRADE,'-',C1.SECTION) AS CLASSNAME,COUNT(A1.USER_ID) AS TOTALCOUNT
FROM NS_SCHOOL_ATTENDANCE A1
JOIN NS_CLASS C1 ON A1.CLASS_ID=C1.CLASS_ID
JOIN NS_GRADE G1 ON C1.GRADE_ID=G1.GRADE_ID
WHERE A1.USER_ID!=1
AND A1.USER_ID!=2
AND C1.SCHOOL_ID=?
AND A1.SESSION_ID=2
AND A1.ATT_DATE = ?
GROUP BY C1.CLASS_ID

UNION

SELECT C2.CLASS_ID AS CLASS_ID,CONCAT(G2.GRADE,'-',C2.SECTION) AS CLASSNAME,0 AS TOTALCOUNT
FROM NS_SCHOOL_ATTENDANCE A2
JOIN NS_CLASS C2 ON A2.CLASS_ID=C2.CLASS_ID
JOIN NS_GRADE G2 ON C2.GRADE_ID=G2.GRADE_ID
WHERE A2.USER_ID=1
AND C2.SCHOOL_ID=?
AND A2.SESSION_ID=2
AND A2.ATT_DATE = ?
AND C2.CLASS_ID NOT IN (
SELECT C3.CLASS_ID AS CLASS_ID
FROM NS_SCHOOL_ATTENDANCE A3
JOIN NS_CLASS C3 ON A3.CLASS_ID=C3.CLASS_ID
JOIN NS_GRADE G3 ON C3.GRADE_ID=G3.GRADE_ID
WHERE A3.USER_ID!=1
AND A3.USER_ID!=2
AND C3.SCHOOL_ID=?
AND A3.SESSION_ID=2
AND A3.ATT_DATE = ?
GROUP BY C3.CLASS_ID
)
ORDER BY CLASS_ID ;]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Empty" id="1946">
<list-property name="columnHints">
<structure>
<property name="columnName">now()</property>
<text-property name="displayName">now()</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">now()</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">now()</property>
<property name="nativeName">now()</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select now();]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>now()</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>93</design:nativeDataTypeCode>
<design:precision>19</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>now()</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>now()</design:label>
<design:formattingHints>
<design:displaySize>19</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="NOT_FN" id="2027">
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">classAttlist</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">classAttlist</property>
<property name="nativeName">classAttlist</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT CONCAT(G1.GRADE,'-',C1.SECTION) AS classAttlist
FROM NS_CLASS C1,NS_GRADE G1
WHERE C1.GRADE_ID=G1.GRADE_ID
AND C1.SCHOOL_ID=?
AND C1.CLASS_ID NOT IN (SELECT N.CLASS_ID FROM NS_SCHOOL_ATTENDANCE N
WHERE N.ATT_DATE=?
AND N.USER_ID=1
AND N.SESSION_ID=1)
ORDER BY CLASS_ID;]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>classAttlist</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>41</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>classAttlist</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>classAttlist</design:label>
<design:formattingHints>
<design:displaySize>41</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="NOT_AN" id="2079">
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">SCHOOL_ID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param_2</property>
<property name="paramName">fromDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">classAttlist</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">classAttlist</property>
<property name="nativeName">classAttlist</property>
<property name="dataType">string</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT CONCAT(G1.GRADE,'-',C1.SECTION) AS classAttlist
FROM NS_CLASS C1,NS_GRADE G1
WHERE C1.GRADE_ID=G1.GRADE_ID
AND C1.SCHOOL_ID=?
AND C1.CLASS_ID NOT IN (SELECT N.CLASS_ID FROM NS_SCHOOL_ATTENDANCE N
WHERE N.ATT_DATE=?
AND N.USER_ID=1
AND N.SESSION_ID=2)
ORDER BY CLASS_ID;]]></xml-property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>classAttlist</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>41</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>classAttlist</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>classAttlist</design:label>
<design:formattingHints>
<design:displaySize>41</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="NewStyle" id="2612">
<property name="fontWeight">bold</property>
<property name="textAlign">left</property>
</style>
<style name="NewStyle1" id="2616">
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</style>
<style name="NewStyle2" id="2622">
<property name="fontWeight">bold</property>
<property name="textAlign">right</property>
</style>
<style name="NewStyle3" id="2631">
<property name="textAlign">left</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="topMargin">0.25in</property>
<property name="leftMargin">0.25in</property>
<property name="bottomMargin">0.25in</property>
<property name="rightMargin">0.13541666666666666in</property>
</simple-master-page>
</page-setup>
<body>
<grid id="1681">
<column id="1682"/>
<column id="1683"/>
<column id="1684"/>
<row id="1685">
<cell id="1686"/>
<cell id="1687"/>
<cell id="1688"/>
</row>
</grid>
<grid id="2271">
<property name="width">8.208333333333334in</property>
<column id="2272">
<property name="width">8.208333333333334in</property>
</column>
<row id="2273">
<cell id="2274">
<table name="sortable11" id="2275">
<property name="textAlign">center</property>
<property name="width">8.28125in</property>
<property name="dataSet">School_Dataset</property>
<list-property name="boundDataColumns">
<structure>
&

JasonW

Is your code similar to the code described in this thread?
http://www.birt-exchange.org/org/forum/index.php/topic/22240-drilldown-hyperlinks-are-broken-in-html-report/page__pid__76695__st__0&#entry76695

Jason

skv

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="76701" data-time="1304707222" data-date="06 May 2011 - 11:40 AM"><p>
Is your code similar to the code described in this thread?<br />
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/22240-drilldown-hyperlinks-are-broken-in-html-report/page__pid__76695__st__0&#entry76695'>http://www.birt-exchange.org/org/forum/index.php/topic/22240-drilldown-hyperlinks-are-broken-in-html-report/page__pid__76695__st__0&#entry76695</a><br />
<br />
Jason<br /></p></blockquote>
<br />
<br />
Hi, <br />
<br />
I am seeing similar issue. <br />
<br />
Scenario is: I have generated an HTML report and kept it in a directory named documents on server(apache tomcat) root. When I access this report through: <br />
<a class='bbc_url' href='http://localhost:8080/documents/ReportTmp_system_1149659057706496.html'>http://localhost:8080/documents/ReportTmp_system_1149659057706496.html</a> , the drill downs URL on this report generated are: <br />
<a class='bbc_url' href='http://localhost:8080/'>http://localhost:8080/</a><strong class='bbc'>documents</strong>/run?__report=report%2Freports%2FApplicationRTM_L2.rptdesign. This URL renders blank page. (I have used servlet mapping for <strong class='bbc'>documents</strong>/run).<br />
<br />
Now if I move my original HTML documents from documents directory to server root and access the HTML file <br />
as: <a class='bbc_url' href='http://localhost:8080/ReportTmp_system_1149659057706496.html'>http://localhost:8080/ReportTmp_system_1149659057706496.html</a> the drill down URLs generated are:<br />
<br />
<a class='bbc_url' href='http://localhost:8080/run?__report=report/reports/ApplicationRTM_L2.rptdesign.'>http://localhost:8080/run?__report=report/reports/ApplicationRTM_L2.rptdesign.</a><br />
Which renders the details report properly. <br />
<br />
Hence to get the drill down working properly I need to keep the HTML report in WEBROOT dir which is messy. <br />
I need to keep the HTML reports in a separate folder. Could anyone suggest a neat solution?<br />
<br />
<br />
Thanks, <br />
./SKV<br />
<br />
PS: All this trouble is because BIRT does not support report consolidation. I am combining multiple reports in to an HTML page but drill-down URLs are screwed up.

JasonW

Are you using the api to run the report? If so you can implement your own action handler that will allow you to build the link anyway you want. If you are using the viewer, use the URI builder instead of the drill through.

Jason

skv

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="76878" data-time="1305128836" data-date="11 May 2011 - 08:47 AM"><p>
Are you using the api to run the report? If so you can implement your own action handler that will allow you to build the link anyway you want. If you are using the viewer, use the URI builder instead of the drill through.<br />
<br />
Jason<br /></p></blockquote>
<br />
<br />
I have implemented IHTMLAction handler, but I do not want to hard code URL as master HTML report can be accessed by http as well as https and localhost as well as public IP address.

JasonW

I may be missing the point and if I am I apologize but could you not put this in your actionhandler?

protected String buildDrillAction( IAction action, Object context )
{
String baseURL = null;
if ( context != null )
{
if ( context instanceof HTMLRenderContext )
{
baseURL = ( (HTMLRenderContext) context ).getBaseURL( );
}
if ( context instanceof PDFRenderContext )
{
baseURL = ( (PDFRenderContext) context ).getBaseURL( );
}
}

//if ( baseURL == null )
//{
baseURL = "/myviewer/run";
//}
StringBuffer link = new StringBuffer( );
String reportName = getReportName( action );

if ( reportName != null && !reportName.equals( "" ) ) //$NON-NLS-1$
{
String format = action.getFormat( );
if ( !"html".equalsIgnoreCase( format ) )
{
link.append( baseURL.replaceFirst( "frameset", "run" ) ); //$NON-NLS-1$ //$NON-NLS-2$
}
else

Jason