Eclipse Community Forums: BIRT

Home » Archived » BIRT » sort by code

Fri, 19 May 2006 09:43

Eclipse User

Originally posted by: barrerager.delsatgroup.com

I'm modifying the webviewer servlet I want the user select the sort colums
for the report at runtime, can someone help me with an example or/and
documentation on how to achieve this.
Thank you in advance.
Barrera, German.

Re: sort by code [message #163561 is a reply to message #162922]

Mon, 22 May 2006 15:43

Eclipse User

Can you give an example scenario.
It may be possible to do this without changing the servlet.

Jason

"Barrera, German" <barrerager@delsatgroup.com> wrote in message
news:e4khu1$llb$1@utils.eclipse.org...
> I'm modifying the webviewer servlet I want the user select the sort colums
> for the report at runtime, can someone help me with an example or/and
> documentation on how to achieve this.
> Thank you in advance.
> Barrera, German.
>
>

Re: sort by code [message #163569 is a reply to message #163561]

Mon, 22 May 2006 16:37

Eclipse User

Originally posted by: barrerager.delsatgroup.com

What I'm trying to achieve is to add a dialog like parameters dialog to give
the end user the ability to select which columns of the tables of the report
are visible.

Barrera, German.

"Jason Weathersby" <jweathersby@actuate.com> escribi

Re: sort by code [message #163576 is a reply to message #163569]

Mon, 22 May 2006 17:46

Eclipse User

Here is an example of using a parameter to hide a column.
Look at the visibilty property for the column.
This was done in RC3.

Jason

<?xml version="1.0" encoding="UTF-8"?>



<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2"
id="1">

<property name="createdBy">Eclipse BIRT Designer Version
2.1.0.N20060519-1616 Build <20060519-1616></property>

<property name="units">in</property>

<property name="comments">Copyright (c) 2006 Actuate Corporation.</property>

<parameters>

<scalar-parameter name="custname" id="28">

<property name="valueType">static</property>

<property name="dataType">string</property>

<property name="controlType">text-box</property>

<property name="defaultValue">Atelier graphique</property>

<structure name="format">

<property name="category">Unformatted</property>

</structure>

</scalar-parameter>

<scalar-parameter name="hidecredit" id="29">

<property name="valueType">static</property>

<property name="dataType">boolean</property>

<property name="controlType">check-box</property>

<property name="defaultValue">true</property>

<structure name="format"/>

</scalar-parameter>

</parameters>

<data-sources>

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="Data Source" id="4">

<text-property name="displayName">Data Source</text-property>

<property
name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>

<property name="odaURL">jdbc:classicmodels:sampledb</property>

<property name="odaUser">ClassicModels</property>

</oda-data-source>

</data-sources>

<data-sets>

<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="5">

<text-property name="displayName">Data Set</text-property>

<list-property name="parameters">

<structure>

<property name="name">custname</property>

<property name="dataType">string</property>

<property name="nativeDataType">12</property>

<property name="position">1</property>

<expression name="defaultValue">"Atelier graphique"</expression>

<property name="isInput">true</property>

</structure>

</list-property>

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">CUSTOMERNUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">2</property>

<property name="name">CUSTOMERNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">CONTACTLASTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">CONTACTFIRSTNAME</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">PHONE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">6</property>

<property name="name">ADDRESSLINE1</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">7</property>

<property name="name">ADDRESSLINE2</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">8</property>

<property name="name">CITY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">9</property>

<property name="name">STATE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">10</property>

<property name="name">POSTALCODE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">11</property>

<property name="name">COUNTRY</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">12</property>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">13</property>

<property name="name">CREDITLIMIT</property>

<property name="dataType">float</property>

</structure>

</list-property>

</structure>

<property name="dataSource">Data Source</property>

<property name="queryText">select *

from CLASSICMODELS.CUSTOMERS

where CUSTOMERNAME = ?</property>

</oda-data-set>

</data-sets>

<page-setup>

<simple-master-page name="Simple MasterPage" id="2">

<page-footer>

<text id="3">

<property name="contentType">html</property>

<text-property name="content"><![CDATA[<value-of>new
Date()</value-of>]]></text-property>

</text>

</page-footer>

</simple-master-page>

</page-setup>

<body>

<table id="6">

<property name="width">100%</property>

<property name="dataSet">Data Set</property>

<list-property name="paramBindings">

<structure>

<property name="paramName">custname</property>

<expression name="expression">params["custname"]</expression>

</structure>

</list-property>

<list-property name="boundDataColumns">

<structure>

<property name="name">CUSTOMERNAME</property>

<expression name="expression">dataSetRow["CUSTOMERNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CUSTOMERNUMBER</property>

<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CONTACTLASTNAME</property>

<expression name="expression">dataSetRow["CONTACTLASTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CONTACTFIRSTNAME</property>

<expression name="expression">dataSetRow["CONTACTFIRSTNAME"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">PHONE</property>

<expression name="expression">dataSetRow["PHONE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE1</property>

<expression name="expression">dataSetRow["ADDRESSLINE1"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">ADDRESSLINE2</property>

<expression name="expression">dataSetRow["ADDRESSLINE2"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">CITY</property>

<expression name="expression">dataSetRow["CITY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">STATE</property>

<expression name="expression">dataSetRow["STATE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">POSTALCODE</property>

<expression name="expression">dataSetRow["POSTALCODE"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">COUNTRY</property>

<expression name="expression">dataSetRow["COUNTRY"]</expression>

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">SALESREPEMPLOYEENUMBER</property>

<expression
name="expression">dataSetRow["SALESREPEMPLOYEENUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">CREDITLIMIT</property>

<expression name="expression">dataSetRow["CREDITLIMIT"]</expression >

<property name="dataType">float</property>

</structure>

</list-property>

<column id="19"/>

<column id="20"/>

<column id="21">

<list-property name="visibility">

<structure>

<property name="format">all</property>

<expression name="valueExpr">params["hidecredit"]</expression>

</structure>

</list-property>

</column>

<header>

<row id="7">

<cell id="8">

<label id="22">

<text-property name="text">CUSTOMERNAME</text-property>

</label>

</cell>

<cell id="9">

<label id="24">

<text-property name="text">CONTACTFIRSTNAME</text-property>

</label>

</cell>

<cell id="10">

<label id="26">

<text-property name="text">CREDITLIMIT</text-property>

</label>

</cell>

</row>

</header>

<detail>

<row id="11">

<cell id="12">

<data id="23">

<property name="dataSet">Data Set</property>

<property name="resultSetColumn">CUSTOMERNAME</property>

</data>

</cell>

<cell id="13">

<data id="25">

<property name="resultSetColumn">CONTACTFIRSTNAME</property>

</data>

</cell>

<cell id="14">

<data id="27">

<property name="resultSetColumn">CREDITLIMIT</property>

</data>

</cell>

</row>

</detail>

<footer>

<row id="15">

<cell id="16"/>

<cell id="17"/>

<cell id="18"/>

</row>

</footer>

</table>

</body>

</report>

"Barrera, German" <barrerager@delsatgroup.com> wrote in message
news:e4t78q$qn1$1@utils.eclipse.org...
> What I'm trying to achieve is to add a dialog like parameters dialog to
> give
> the end user the ability to select which columns of the tables of the
> report
> are visible.
>
> Barrera, German.
>
> "Jason Weathersby" <jweathersby@actuate.com> escribi

Re: sort by code [message #163812 is a reply to message #163576]

Tue, 23 May 2006 10:35

Eclipse User

Originally posted by: barrerager.delsatgroup.com

This works fine but I want to do this for every column in every report, thus
i want to do this by code automatically. Also in my previous post I've
confussed the requirement. I'v started asking how to include sorts
dinamically an later I've asked how to hide columns, sorry for this
confussion.
We're planning to do several improvements to the web viewer so we need
documentation and examples on how to modify the report design at runtime.
We're having problems trying to figure out how to access and modify the
diferent parts of the report design, such as filters, orders, colums,
groups, totals, etc.
Thank you.

Barrera, German.

"Jason Weathersby" <jweathersby@actuate.com> escribi

Re: sort by code [message #163902 is a reply to message #163812]

Tue, 23 May 2006 17:30

Eclipse User

Here is an example of how to modify the first visibility rule on a column.
This will change the example I posted earlier.

Jason

import java.io.IOException;

import java.util.Iterator;

import org.eclipse.birt.report.model.api.ColumnHandle;

import org.eclipse.birt.report.model.api.DesignConfig;

import org.eclipse.birt.report.model.api.DesignEngine;

import org.eclipse.birt.report.model.api.DesignFileException;

import org.eclipse.birt.report.model.api.HideRuleHandle;

import org.eclipse.birt.report.model.api.ReportDesignHandle;

import org.eclipse.birt.report.model.api.SessionHandle;

import org.eclipse.birt.report.model.api.TableHandle;

import org.eclipse.birt.report.model.api.activity.SemanticException ;

import org.eclipse.birt.report.model.api.elements.DesignChoiceConst ants;

import org.eclipse.birt.report.model.elements.ReportDesign;

import com.ibm.icu.util.ULocale;

public class ModifyReport {

static void modifyReport()throws IOException, SemanticException,
DesignFileException

{

ReportDesignHandle designHandle = null;

SessionHandle sessionHandle = null;

ReportDesign design = null;

DesignConfig dc = new DesignConfig();

dc.setConfigurationVariable("BIRT_HOME",
"C:\\birt-runtime-2.1RC2\\birt-runtime-2_1_0\\ReportEngine");

sessionHandle = new DesignEngine( dc ).newSessionHandle( ULocale.ENGLISH );

designHandle = sessionHandle.openDesign(
"c:\\test\\modifyreport\\customerdetail.rptdesign" );

design = (ReportDesign)designHandle.getModule( );

TableHandle table = (TableHandle) designHandle.findElement( "myTable" );

ColumnHandle column = (ColumnHandle)table.getColumns().get(2);

Iterator visibilities = column.visibilityRulesIterator( );

//only change the first

if ( visibilities.hasNext( ) )

{

HideRuleHandle ruleHandle = (HideRuleHandle) visibilities.next( );

ruleHandle.setFormat( DesignChoiceConstants.FORMAT_TYPE_ALL );

String expression = "true";

ruleHandle.setExpression(expression );

}

designHandle.save();

design.close( );

sessionHandle.closeAll(true);

System.out.println("Finished!");

}

public static void main(String[] args) {

try

{

modifyReport( );

}

catch ( Exception e )

{

e.printStackTrace();

}

}

}

"Barrera, German" <barrerager@delsatgroup.com> wrote in message
news:e4v6fm$tku$1@utils.eclipse.org...
> This works fine but I want to do this for every column in every report,
> thus
> i want to do this by code automatically. Also in my previous post I've
> confussed the requirement. I'v started asking how to include sorts
> dinamically an later I've asked how to hide columns, sorry for this
> confussion.
> We're planning to do several improvements to the web viewer so we need
> documentation and examples on how to modify the report design at runtime.
> We're having problems trying to figure out how to access and modify the
> diferent parts of the report design, such as filters, orders, colums,
> groups, totals, etc.
> Thank you.
>
> Barrera, German.
>
> "Jason Weathersby" <jweathersby@actuate.com> escribi

Previous Topic:	Fonts in PDF
Next Topic:	build BIRT from the command line

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 16 09:40:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter