Eclipse Community Forums: BIRT

Home » Archived » BIRT » configurable url

configurable url [message #200235]

Fri, 10 November 2006 08:56

Eclipse User

i'm new of birt...
I create a xml data source.
I insert my url in datasource. For example:
http://127.0.0.1:8080/Project/3450/readDocument
I create a data set and i can see the table map and all it's all right.
I see the document with id = 3450.
Now i want create a paramiter so that the user can insert the id and i can
create report that user want.

but, how can i do?
i try
http://127.0.0.1:8080/Project/&reportparamitername/readD ocument
but isn't correct...
someone can help me?

Re: configurable url [message #200269 is a reply to message #200235]

Fri, 10 November 2006 10:34

Eclipse User

Where are you setting this?
It should have syntax like
"http://127.0.0.1:8080/Project/" + params["reportparamitername"] +
"/readDocument"

Jason

"Paolo" <pbellani@hotmail.com> wrote in message
news:b346804f547b5b218bbc08af7dfe65c2$1@www.eclipse.org...
> i'm new of birt...
> I create a xml data source.
> I insert my url in datasource. For example:
> http://127.0.0.1:8080/Project/3450/readDocument
> I create a data set and i can see the table map and all it's all right.
> I see the document with id = 3450.
> Now i want create a paramiter so that the user can insert the id and i can
> create report that user want.
>
> but, how can i do?
> i try http://127.0.0.1:8080/Project/&reportparamitername/readD ocument
> but isn't correct...
> someone can help me?
>

Re: configurable url [message #200470 is a reply to message #200269]

Mon, 13 November 2006 05:34

Eclipse User

I try but i receive this message...

Data (id = 358):
+ Cannot open the connection for the driver:
org.eclipse.birt.report.data.oda.xml
no protocol: "http://127.0.0.1:8080/Project/" +
params["reportparamitername"] + "/readDocument"

someone can help me?
tnx

Re: configurable url [message #200543 is a reply to message #200470]

Mon, 13 November 2006 11:20

Eclipse User

Can you post the report?

Jason

"Paolo" <pbellani@hotmail.com> wrote in message
news:3b61db2e401de31b0d5bd90a58dd3a1c$1@www.eclipse.org...
>I try but i receive this message...
>
> Data (id = 358): + Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.xml
> no protocol: "http://127.0.0.1:8080/Project/" +
> params["reportparamitername"] + "/readDocument"
>
> someone can help me?
> tnx
>

Re: configurable url [message #200723 is a reply to message #200543]

Tue, 14 November 2006 05:35

Eclipse User

can you send me an email so i can send you report?
tnx

Jason Weathersby wrote:

> Can you post the report?

> Jason

> "Paolo" <pbellani@hotmail.com> wrote in message
> news:3b61db2e401de31b0d5bd90a58dd3a1c$1@www.eclipse.org...
>>I try but i receive this message...
>>
>> Data (id = 358): + Cannot open the connection for the driver:
>> org.eclipse.birt.report.data.oda.xml
>> no protocol: "http://127.0.0.1:8080/Project/" +
>> params["reportparamitername"] + "/readDocument"
>>
>> someone can help me?
>> tnx
>>

Re: configurable url [message #200753 is a reply to message #200543]

Tue, 14 November 2006 10:21

Eclipse User

<?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.N20060628-1351 Build <20060628-1537></property>
<property name="units">mm</property>
<text-property name="title">Papela</text-property>
<property name="comments">Ciao mamma</property>
<parameters>
<scalar-parameter name="rp_idproto" id="342">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="concealValue">false</property>
<property name="allowBlank">false</property>
<property name="allowNull">false</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.xml"
name="datasourcesprotocolloxml" id="213">
<property
name="FILELIST">"http://127.0.0.1:8080/EdmaWeb/service/Proto/"+
params["rp_idproto"] + "/caricaDocumento"</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.xml.dataSet"
name="datasetspapelaxml" id="214">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">identificatore</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">datasourcesprotocolloxml</property>
<property
name="queryText"> table0#-TNAME-#table0#:#[/it.lispa.edma.telemaco.po.Protocol lo]#:#{identificatore;String;/identificatore} </property>
<property name="MAX_ROW">-1</property>
</oda-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="leftMargin">22.86mm</property>
<property name="bottomMargin">17.991mm</property>
<property name="rightMargin">34.925mm</property>
<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>
<data id="359">
<property name="dataSet">datasetspapelaxml</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">identificatore</property>
<expression
name="expression">dataSetRow["identificatore"]</expression >
<property name="dataType">string</property>
</structure>
</list-property>
<property name="resultSetColumn">identificatore</property>
</data>
</body>
</report>

Re: configurable url [message #200785 is a reply to message #200753]

Tue, 14 November 2006 11:36

Eclipse User

You are not building the url in the property binding for the xml data
source.
In the datasource hard code to an existing location and then change it in
the data binding property.

Take a look at this example:

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.N20060628-1351 Build <20060628-1537></property>

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

<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>

<list-property name="propertyBindings">

<structure>

<property name="name">FILELIST</property>

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

<expression name="value">"http://localhost/" + params["xmllocation"]
+"/test.xml"</expression>

</structure>

<structure>

<property name="name">SCHEMAFILELIST</property>

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

</structure>

</list-property>

<parameters>

<scalar-parameter name="xmllocation" id="22">

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

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

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

<property name="defaultValue">xml1</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.xml"
name="Data Source" id="4">

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

<property name="FILELIST">http://localhost/xml1/test.xml</property>

</oda-data-source>

</data-sources>

<data-sets>

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

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

<list-property name="resultSet">

<structure>

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

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

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

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

</structure>

<structure>

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

<property name="name">nickname</property>

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

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

</structure>

</list-property>

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

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

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

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

</structure>

<structure>

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

<property name="name">nickname</property>

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

</structure>

</list-property>

</structure>

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

<property
name="queryText"> table0#-TNAME-#table0#:#[/people/person/nicknames/nickname]# :#{name;String;../../name},{nickname;String;} </property>

<property name="MAX_ROW">-1</property>

<property name="XML_FILE">http://localhost/xml1/test.xml</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="boundDataColumns">

<structure>

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

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

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

</structure>

<structure>

<property name="name">nickname</property>

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

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

</structure>

</list-property>

<column id="20"/>

<column id="21"/>

<header>

<row id="7">

<cell id="8">

<label id="9">

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

</label>

</cell>

<cell id="10">

<label id="11">

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

</label>

</cell>

</row>

</header>

<detail>

<row id="12">

<cell id="13">

<data id="14">

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

</data>

</cell>

<cell id="15">

<data id="16">

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

</data>

</cell>

</row>

</detail>

<footer>

<row id="17">

<cell id="18"/>

<cell id="19"/>

</row>

</footer>

</table>

</body>

</report>

"Paolo" <pbellani@hotmail.com> wrote in message
news:c93e17f7e3953ebc1330c24fc594e59b$1@www.eclipse.org...
> <?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.N20060628-1351 Build <20060628-1537></property>
> <property name="units">mm</property>
> <text-property name="title">Papela</text-property>
> <property name="comments">Ciao mamma</property>
> <parameters>
> <scalar-parameter name="rp_idproto" id="342">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="concealValue">false</property>
> <property name="allowBlank">false</property>
> <property name="allowNull">false</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.xml"
> name="datasourcesprotocolloxml" id="213">
> <property
> name="FILELIST">"http://127.0.0.1:8080/EdmaWeb/service/Proto/"+
> params["rp_idproto"] + "/caricaDocumento"</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.xml.dataSet"
> name="datasetspapelaxml" id="214">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">identificatore</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">datasourcesprotocolloxml</property>
> <property
> name="queryText"> table0#-TNAME-#table0#:#[/it.lispa.edma.telemaco.po.Protocol lo]#:#{identificatore;String;/identificatore} </property>
> <property name="MAX_ROW">-1</property>
> </oda-data-set>
> </data-sets>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="leftMargin">22.86mm</property>
> <property name="bottomMargin">17.991mm</property>
> <property name="rightMargin">34.925mm</property>
> <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>
> <data id="359">
> <property name="dataSet">datasetspapelaxml</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">identificatore</property>
> <expression
> name="expression">dataSetRow["identificatore"]</expression >
> <property name="dataType">string</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">identificatore</property>
> </data>
> </body>
> </report>
>

Re: configurable url [message #200947 is a reply to message #200785]

Wed, 15 November 2006 05:34

Eclipse User

tnx a lot!
i've only another question...
now i build the url in the property binding for the xml data
source.
but also if i enter the default in the paramiter i can't (in data set)
choose the table in table mapping... i see
"/it.lispa.rsi3.service.SystemException".
If i cut in datasource the binding i can map the table in dataset...
Not is a big problem but.. why it happen?

Re: configurable url [message #201001 is a reply to message #200947]

Wed, 15 November 2006 12:45

Eclipse User

I am not sure I understand the problem.
Hardcode the default for design purposes.
Property binding replaces it at run time.

Jason

"Paolo" <pbellani@hotmail.com> wrote in message
news:c31dc5192a0fc683c0834c52d1da7dbb$1@www.eclipse.org...
> tnx a lot!
> i've only another question...
> now i build the url in the property binding for the xml data source.
> but also if i enter the default in the paramiter i can't (in data set)
> choose the table in table mapping... i see
> "/it.lispa.rsi3.service.SystemException".
> If i cut in datasource the binding i can map the table in dataset...
> Not is a big problem but.. why it happen?
>

Previous Topic:	How can i change dynamically a dataset ?
Next Topic:	How to switch GUI language of BIRT Designer 2.1.1?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jun 03 10:14:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter