Eclipse Community Forums: BIRT » Need help with XML Data source parametrized report

Home » Archived » BIRT » Need help with XML Data source parametrized report

Need help with XML Data source parametrized report [message #717339]

Fri, 19 August 2011 23:04

Eclipse User

Hi,
I am trying something.
I need to parametrize this report so it can filter the Start and End Dates. I am unable to map the parameters.
How do I achieve run time parameter filtering for an XML datasource report?

Also how do I get data from a second XML file into the report ( for calculation) when I cannot create a join data set ( no data in common)? Please see attached pdf for calculation of the Utilization % column.
Dont worry about the graph.

Please also find attached the report and source XML files.
Please advise.

Attachment: LicenseActivity.rptdesign
(Size: 78.74KB, Downloaded 958 times)
Attachment: LicenseActivityReport.zip
(Size: 66.36KB, Downloaded 245 times)

Re: Need help with XML Data source parametrized report [message #717885 is a reply to message #717339]

Mon, 22 August 2011 11:44

Eclipse User

You could use the filter in the xml datasource to filter in the rows you
want. Take a look at your example that I modified. Essentially in the
filter I convert the start date parameter to millis and then use that in
the filter. I only did the start parameter but the end parameter could
be used as well and the filter could be a between statement.

I tried to use the xpath predicate with an xml data source parameter but
it appears to have an issue with the syntax needed. If you want to know
how to use xml datasource parameters have a look at this page:
http://www.eclipse.org/birt/phoenix/project/notable2.5.php#jump_10

In your second question what field from the other dataset are you
wanting to use in the calculation? You can always add the other dataset
to the report above the existing table and use the visibility expression
to hide it. This will cause the dataset to run. You can then set a
global variable on the field that you need from it. For example on the
data item you need from the hidden table, if it were total. Put an
onCreate event for the data item with script like:

reportContext.setGlobalVariable("mytotal", this.getValue());

Then in the expression for the second table where you need it just add:

val ttl = parseFloat(reportContext.getGlobalVariable("mytotal"));
row["util"]/ttl;

Jason
On 8/19/2011 11:04 PM, KK wrote:
> Hi,
> I am trying something.
> I need to parametrize this report so it can filter the Start and End Dates. I am unable to map the parameters.
> How do I achieve run time parameter filtering for an XML datasource report?
>
> Also how do I get data from a second XML file into the report ( for calculation) when I cannot create a join data set ( no data in common)? Please see attached pdf for calculation of the Utilization % column.
> Dont worry about the graph.
>
> Please also find attached the report and source XML files.
> Please advise.

Attachment: xmlfilter.zip
(Size: 6.38KB, Downloaded 297 times)

Re: Need help with XML Data source parametrized report [message #718231 is a reply to message #717885]

Tue, 23 August 2011 12:46

Eclipse User

Hi Jason,
I ran into different issues...take a look at the rptdesign and the attached xml files. The issues are:
1) I am getting a cartesian join and I cant seem to get rid of it.
2) I cant get the Utilization% Calculation right since there are a bunch of blank rows ( due to Point 1?) and also it should be a straight percentage calculation based on the pdf I sent in this thread earlier ( Unique users/[Total]). The Total column is per feature.
Let me know what you think.
Thanks

Attachment: LicenseServerInfo2.xml
(Size: 2.21KB, Downloaded 161 times)
Attachment: UserUsage2.xml
(Size: 7.30KB, Downloaded 182 times)
Attachment: LicenseActvty.rptdesign
(Size: 150.05KB, Downloaded 334 times)

Re: Need help with XML Data source parametrized report [message #718265 is a reply to message #718231]

Tue, 23 August 2011 14:27

Eclipse User

If you have the aggregation element in a detail row, it is going to be
calculated for every row. In your example I would have expected to see
the aggregation in the group header or footer. If you do not want all
the detail rows, move your fields to the group header and delete the
detail row.

Jason

On 8/23/2011 12:46 PM, KK wrote:
> Hi Jason,
> I ran into different issues...take a look at the rptdesign and the attached xml files. The issues are:
> 1) I am getting a cartesian join and I cant seem to get rid of it.
> 2) I cant get the Utilization% Calculation right since there are a bunch of blank rows ( due to Point 1?) and also it should be a straight percentage calculation based on the pdf I sent in this thread earlier ( Unique users/[Total]). The Total column is per feature.
> Let me know what you think.
> Thanks
>

Re: Need help with XML Data source parametrized report [message #718276 is a reply to message #718265]

Tue, 23 August 2011 15:54

Eclipse User

Hi Jason,
Thanks...your tip did help me get rid of the blank detail rows.
But my point 2 from earlier email is still an issue...I just cant get the calculation going.
It should be number of unique users/[total] for that feature.
Any ideas?

Re: Need help with XML Data source parametrized report [message #718514 is a reply to message #718276]

Wed, 24 August 2011 10:41

Eclipse User

Is the unique users field correct in the report? Why not group by
feature and put two aggregations on the table that aggregate on the
group. One for total users and one for unique users and then add a data
element to the report that divides the two. Note that the aggregation
element does not need to appear in the report, just select the binding
tab and and add it there.

Jason

On 8/23/2011 3:54 PM, KK wrote:
> Hi Jason,
> Thanks...your tip did help me get rid of the blank detail rows.
> But my point 2 from earlier email is still an issue...I just cant get
> the calculation going. It should be number of unique users/[total] for
> that feature.
> Any ideas?

Re: Need help with XML Data source parametrized report [message #718620 is a reply to message #718514]

Wed, 24 August 2011 17:12

Eclipse User

Jason,
I see what you mean...I rectified the Unique users count...you are correct.
Overall, I have managed to solve this issue.
I found a trick with joint datasets(probably this was already known). In my earlier post I mentioned I was getting a Cartesian join due to the way the data was and Joint datasets do not let you join on multiple fields.
How I solved this was in the final joint dataset...I used the filter tab to join multiple fields to get the correct count and eliminate the multiple rows.
For ex: ds::vendor Equals ds1::vendor
ds::product Equals ds1::product
...and so on. This could be the equivalent of multiple joins in a sql. This helps especially in XML datasource reports.

Re: Need help with XML Data source parametrized report [message #726855 is a reply to message #718620]

Mon, 19 September 2011 13:55

Eclipse User

Hi Jason,
Please take a look at the attached XML. How can I get the AggUtilPCT field as the Y-axis of the chart and unique dates on X-axis. In other words I want the same grouping as the detail report in the chart. I tried basing the chart on both the table and the final dataset...but I cant get the right values.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="author">Kumar Krishnan</property>
<property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602 Build <3.7.0.v20110607-1526></property>
<text-property name="title">New Report</text-property>
<property name="units">in</property>
<method name="initialize"><![CDATA[// INSTRUCTIONS:
// If you use one of the date parameters listed below you need to:
// - uncomment the two lines below that correspond to the parameter you're using
// - add the required parameters from the library

//NOTE: use this code when setting the date parameter to current date
//var d = new Date();
//var curr_date = d.getDate();
//var curr_month = d.getMonth();
//curr_month++;
//var curr_year = d.getFullYear();

//set the Start Date parameter
//params["strMilliFrom"].value = (params["pStartDate"].value).toString();
//if (params["strStartDate"].value == "1900-01-01" || params["strStartDate"].value == "01/01/1900")
//{
// params["strStartDate"].value =(curr_month + "/" + curr_date + "/" + curr_year);
// params["pStartDate"].value = (params["strStartDate"].value).toString();
//}

//set the End Date parameter
//params["strEndDate"].value = (params["pEndDate"].value).toString();
//if (params["strEndDate"].value == "1900-01-01" || params["strEndDate"].value == "01/01/1900")
//{
// params["strEndDate"].value =(curr_month + "/" + curr_date + "/" + curr_year);
// params["pEndDate"].value = (params["strEndDate"].value).toString();
//}

//set the Transaction Date parameter
//params["strTransactionDate"].value = (params["pTransactionDate"].value).toString();
//if (params["strTransactionDate"].value == "1900-01-01" || params["strTransactionDate"].value == "01/01/1900")
//{
// params["strTransactionDate"].value =(curr_month + "/" + curr_date + "/" + curr_year);
// params["pTransactionDate"].value = (params["strTransactionDate"].value).toString();
//}

//set the Run Date parameter
//params["strMilliFrom"].value = (params["prmStartDate"].value).toString();
//params["strMilliFrom"].value = params["strMilliFrom"].value * (24 * 60 * 60 * 1000)

//if (params["strDate"].value == "1900-01-01" || params["strDate"].value == "01/01/1900")
//{
// params["strDate"].value =(curr_month + "/" + curr_date + "/" + curr_year);
// params["pDate"].value = (params["strDate"].value).toString();
//}
]]></method>
<text-property name="displayName">Report Name</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="prmStartDate" id="642">
<property name="hidden">false</property>
<text-property name="promptText">Start Date</text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">1970-01-15</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Custom</property>
<property name="pattern">dd/MM/yyyy</property>
</structure>
</scalar-parameter>
<scalar-parameter name="prmEndDate" id="643">
<property name="hidden">false</property>
<text-property name="promptText">End Date</text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">date</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">1970-01-15 12:30:00</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Custom</property>
<property name="pattern">dd/MM/yyyy</property>
</structure>
</scalar-parameter>
<scalar-parameter name="strMilliFrom" id="644">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<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="strMilliTo" id="645">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList"/>
<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.datatools.enablement.oda.xml" name="UserUsage DataSource" id="7">
<method name="beforeOpen"><![CDATA[//filelist = this.getExtensionProperty("FILELIST");
//filelisturl = filelist.substring(0,filelist.indexOf("=")+1);
//this.setExtensionProperty("FILELIST", filelisturl + params["prmStartDate"]);]]></method>
<property name="FILELIST">D:\My Documents\Kumar\Proj\Odesk\GlobalMaps -Efrat\1st Report\UserUsage2.xml</property>
</oda-data-source>
<oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="LicenseServer Data Source" id="8">
<property name="FILELIST">D:\My Documents\Kumar\Proj\Odesk\GlobalMaps -Efrat\1st Report\LicenseServerInfo2.xml</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="UserUsage Data Set" id="9">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="computedColumns">
<structure>
<property name="name">StartTime_DATE</property>
<expression name="expression">var df = new Date( row["start_time"] *1000);
df.toGMTString();
df</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">EndTime_Date</property>
<expression name="expression">var df = new Date( row["end_time"]*1000);
df.toGMTString();
df</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">Start_DATE</property>
<expression name="expression">row["StartTime_DATE"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">END_DATE</property>
<expression name="expression">row["EndTime_Date"]</expression>
<property name="dataType">date</property>
</structure>
<structure>
<property name="name">Cnt_user</property>
<property name="dataType">integer</property>
<property name="aggregateFunction">COUNTDISTINCT</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">row["user_name"]</expression>
</structure>
</list-property>
</structure>
<structure>
<property name="name">UsageHours</property>
<expression name="expression">(row["end_time"]-row["start_time"])/(60*60)</expression>
<property name="dataType">float</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">(row["end_time"]-row["start_time"])/(60*60*1000)</expression>
</structure>
</list-property>
<expression name="filterExpr">row["start_time"]</expression>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">user_name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">user_name</text-property>
<property name="analysisColumn">user_name</property>
</structure>
<structure>
<property name="columnName">hostname</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">hostname</text-property>
<property name="analysisColumn">hostname</property>
</structure>
<structure>
<property name="columnName">start_time</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">start_time</text-property>
<property name="analysisColumn">start_time</property>
</structure>
<structure>
<property name="columnName">end_time</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">end_time</text-property>
<property name="analysisColumn">end_time</property>
</structure>
<structure>
<property name="columnName">vendor</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">vendor</text-property>
<property name="analysisColumn">vendor</property>
</structure>
<structure>
<property name="columnName">server</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">server</text-property>
<property name="analysisColumn">server</property>
</structure>
<structure>
<property name="columnName">name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">name</text-property>
<property name="analysisColumn">name</property>
</structure>
<structure>
<property name="columnName">product_name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">product_name</text-property>
<property name="analysisColumn">product_name</property>
</structure>
<structure>
<property name="columnName">usagetime</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">usagetime</text-property>
<property name="analysisColumn">usagetime</property>
</structure>
<structure>
<property name="columnName">projectname</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">projectname</text-property>
<property name="analysisColumn">projectname</property>
</structure>
<structure>
<property name="columnName">groupname</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">groupname</text-property>
<property name="analysisColumn">groupname</property>
</structure>
<structure>
<property name="columnName">ip</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">ip</text-property>
<property name="analysisColumn">ip</property>
</structure>
</list-property>
<list-property name="filter"/>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">user_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">hostname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">start_time</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">end_time</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">vendor</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">server</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">product_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">usagetime</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">projectname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">groupname</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">ip</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">StartTime_DATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">EndTime_Date</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">Start_DATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">END_DATE</property>
<property name="dataType">date</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">Cnt_user</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">UsageHours</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[//this.queryText = this.queryText + " and CAST(payments.payment_date AS DATE ) between '" + params["prmFromDate"].value +"' and '" + params["prmToDate"].value + "'";]]></method>
<property name="dataSource">UserUsage DataSource</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">user_name</property>
<property name="nativeName">user_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">hostname</property>
<property name="nativeName">hostname</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">start_time</property>
<property name="nativeName">start_time</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">end_time</property>
<property name="nativeName">end_time</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">vendor</property>
<property name="nativeName">vendor</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">server</property>
<property name="nativeName">server</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">product_name</property>
<property name="nativeName">product_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">usagetime</property>
<property name="nativeName">usagetime</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">projectname</property>
<property name="nativeName">projectname</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">groupname</property>
<property name="nativeName">groupname</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">ip</property>
<property name="nativeName">ip</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[table0#-TNAME-#table0#:#[/ULM/PRODUCTS/PRODUCT]#:#{user_name;STRING;/@user_name},{hostname;STRING;/@hostname},{start_time;STRING;/@start_time},{end_time;STRING;/@end_time},{vendor;STRING;/@vendor},{server;STRING;/@server},{name;STRING;/@name},{product_name;STRING;/@product_name},{usagetime;STRING;/@usagetime},{projectname;STRING;/@projectname},{groupname;STRING;/@groupname},{ip;STRING;/@ip}]]></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>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>user_name</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>user_name</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>hostname</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>hostname</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>start_time</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>start_time</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>end_time</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>end_time</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>vendor</design:name>
<design:position>5</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>vendor</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>server</design:name>
<design:position>6</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>server</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>name</design:name>
<design:position>7</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>name</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>product_name</design:name>
<design:position>8</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>product_name</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>usagetime</design:name>
<design:position>9</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>usagetime</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>projectname</design:name>
<design:position>10</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>projectname</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>groupname</design:name>
<design:position>11</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>groupname</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>ip</design:name>
<design:position>12</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>-1</design:precision>
<design:scale>-1</design:scale>
<design:nullability>Unknown</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>ip</design:label>
<design:formattingHints/>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>MAX_ROW</name>
<value>-1</value>
</ex-property>
<ex-property>
<name>XML_FILE</name>
</ex-property>
</list-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet" name="LicenseServer Data Set" id="10">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">version</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">version</text-property>
<property name="analysisColumn">version</property>
</structure>
<structure>
<property name="columnName">vendor</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">vendor</text-property>
<property name="analysisColumn">vendor</property>
</structure>
<structure>
<property name="columnName">name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">name</text-property>
<property name="analysisColumn">name</property>
</structure>
<structure>
<property name="columnName">product_name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">product_name</text-property>
<property name="analysisColumn">product_name</property>
</structure>
<structure>
<property name="columnName">total</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">total</text-property>
<property name="analysisColumn">total</property>
</structure>
<structure>
<property name="columnName">used</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">used</text-property>
<property name="analysisColumn">used</property>
</structure>
<structure>
<property name="columnName">borrowed</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">borrowed</text-property>
<property name="analysisColumn">borrowed</property>
</structure>
<structure>
<property name="columnName">available</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">available</text-property>
<property name="analysisColumn">available</property>
</structure>
<structure>
<property name="columnName">server_name</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">server_name</text-property>
<property name="analysisColumn">server_name</property>
</structure>
<structure>
<property name="columnName">expiration_date</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">expiration_date</text-property>
<property name="analysisColumn">expiration_date</property>
</structure>
<structure>
<property name="columnName">package_no</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">package_no</text-property>
<property name="analysisColumn">package_no</property>
</structure>
<structure>
<property name="columnName">forecolor</property>
<property name="analysis">attribute</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">forecolor</text-property>
<property name="analysisColumn">forecolor</property>
</structure>
<structure>
<property name="columnName">hasp_key</property>
<property name="analysis">dimension</property>
<property name="onColumnLayout">false</property>
<text-property name="heading">hasp_key</text-property>
<property name="analysisColumn">hasp_key</property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">version</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">vendor</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">product_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">total</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">used</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">borrowed</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">available</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">server_name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">expiration_date</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">package_no</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">forecolor</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">hasp_key</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">LicenseServer Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">version</property>
<property name="nativeName">version</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">vendor</property>
<property name="nativeName">vendor</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">name</property>
<property name="nativeName">name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">product_name</property>
<property name="nativeName">product_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">total</property>
<property name="nativeName">total</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">used</property>
<property name="nativeName">used</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">borrowed</property>
<property name="nativeName">borrowed</property>
<property name="dataType">string</property>

Re: Need help with XML Data source parametrized report [message #727151 is a reply to message #726855]

Tue, 20 September 2011 10:26

Eclipse User

Can you attach the report? The post did not have the complete report?

Jason

On 9/19/2011 1:55 PM, KK wrote:
> Hi Jason,
> Please take a look at the attached XML. How can I get the AggUtilPCT
> field as the Y-axis of the chart and unique dates on X-axis. In other
> words I want the same grouping as the detail report in the chart. I
> tried basing the chart on both the table and the final dataset...but I
> cant get the right values.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22"
> id="1">
> <property name="author">Kumar Krishnan</property>
> <property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602
> Build <3.7.0.v20110607-1526></property>
> <text-property name="title">New Report</text-property>
> <property name="units">in</property>
> <method name="initialize"><![CDATA[// INSTRUCTIONS:
> // If you use one of the date parameters listed below you need to:
> // - uncomment the two lines below that correspond to the parameter
> you're using
> // - add the required parameters from the library
>
> //NOTE: use this code when setting the date parameter to current date
> //var d = new Date();
> //var curr_date = d.getDate();
> //var curr_month = d.getMonth();
> //curr_month++;
> //var curr_year = d.getFullYear();
>
> //set the Start Date parameter
> //params["strMilliFrom"].value = (params["pStartDate"].value).toString();
> //if (params["strStartDate"].value == "1900-01-01" ||
> params["strStartDate"].value == "01/01/1900")
> //{
> // params["strStartDate"].value =(curr_month + "/" + curr_date + "/" +
> curr_year);
> // params["pStartDate"].value = (params["strStartDate"].value).toString();
> //}
>
> //set the End Date parameter
> //params["strEndDate"].value = (params["pEndDate"].value).toString();
> //if (params["strEndDate"].value == "1900-01-01" ||
> params["strEndDate"].value == "01/01/1900")
> //{
> // params["strEndDate"].value =(curr_month + "/" + curr_date + "/" +
> curr_year);
> // params["pEndDate"].value = (params["strEndDate"].value).toString();
> //}
>
> //set the Transaction Date parameter
> //params["strTransactionDate"].value =
> (params["pTransactionDate"].value).toString();
> //if (params["strTransactionDate"].value == "1900-01-01" ||
> params["strTransactionDate"].value == "01/01/1900")
> //{
> // params["strTransactionDate"].value =(curr_month + "/" + curr_date +
> "/" + curr_year);
> // params["pTransactionDate"].value =
> (params["strTransactionDate"].value).toString();
> //}
>
> //set the Run Date parameter
> //params["strMilliFrom"].value = (params["prmStartDate"].value).toString();
> //params["strMilliFrom"].value = params["strMilliFrom"].value * (24 * 60
> * 60 * 1000)
>
> //if (params["strDate"].value == "1900-01-01" || params["strDate"].value
> == "01/01/1900")
> //{
> // params["strDate"].value =(curr_month + "/" + curr_date + "/" +
> curr_year);
> // params["pDate"].value = (params["strDate"].value).toString();
> //}
> ]]></method>
> <text-property name="displayName">Report Name</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <parameters>
> <scalar-parameter name="prmStartDate" id="642">
> <property name="hidden">false</property>
> <text-property name="promptText">Start Date</text-property>
> <property name="valueType">static</property>
> <property name="isRequired">true</property>
> <property name="dataType">date</property>
> <property name="distinct">true</property>
> <simple-property-list name="defaultValue">
> <value type="constant">1970-01-15</value>
> </simple-property-list>
> <list-property name="selectionList"/>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Custom</property>
> <property name="pattern">dd/MM/yyyy</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="prmEndDate" id="643">
> <property name="hidden">false</property>
> <text-property name="promptText">End Date</text-property>
> <property name="valueType">static</property>
> <property name="isRequired">true</property>
> <property name="dataType">date</property>
> <property name="distinct">true</property>
> <simple-property-list name="defaultValue">
> <value type="constant">1970-01-15 12:30:00</value>
> </simple-property-list>
> <list-property name="selectionList"/>
> <property name="paramType">simple</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Custom</property>
> <property name="pattern">dd/MM/yyyy</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="strMilliFrom" id="644">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="distinct">true</property>
> <list-property name="selectionList"/>
> <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="strMilliTo" id="645">
> <property name="hidden">true</property>
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="distinct">true</property>
> <list-property name="selectionList"/>
> <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.datatools.enablement.oda.xml"
> name="UserUsage DataSource" id="7">
> <method name="beforeOpen"><![CDATA[//filelist =
> this.getExtensionProperty("FILELIST");
> //filelisturl = filelist.substring(0,filelist.indexOf("=")+1);
> //this.setExtensionProperty("FILELIST", filelisturl +
> params["prmStartDate"]);]]></method>
> <property name="FILELIST">D:\My Documents\Kumar\Proj\Odesk\GlobalMaps
> -Efrat\1st Report\UserUsage2.xml</property>
> </oda-data-source>
> <oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml"
> name="LicenseServer Data Source" id="8">
> <property name="FILELIST">D:\My Documents\Kumar\Proj\Odesk\GlobalMaps
> -Efrat\1st Report\LicenseServerInfo2.xml</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet"
> name="UserUsage Data Set" id="9">
> <property name="nullsOrdering">nulls lowest</property>
> <list-property name="computedColumns">
> <structure>
> <property name="name">StartTime_DATE</property>
> <expression name="expression">var df = new Date( row["start_time"] *1000);
>
> df.toGMTString();
>
> df</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">EndTime_Date</property>
> <expression name="expression">var df = new Date( row["end_time"]*1000);
>
> df.toGMTString();
>
> df</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">Start_DATE</property>
> <expression name="expression">row["StartTime_DATE"]</expression>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="name">END_DATE</property>
> <expression name="expression">row["EndTime_Date"]</expression>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="name">Cnt_user</property>
> <property name="dataType">integer</property>
> <property name="aggregateFunction">COUNTDISTINCT</property>
> <list-property name="arguments">
> <structure>
> <property name="name">Expression</property>
> <expression name="value">row["user_name"]</expression>
> </structure>
> </list-property>
> </structure>
> <structure>
> <property name="name">UsageHours</property>
> <expression
> name="expression">(row["end_time"]-row["start_time"])/(60*60)</expression>
> <property name="dataType">float</property>
> <list-property name="arguments">
> <structure>
> <property name="name">Expression</property>
> <expression
> name="value">(row["end_time"]-row["start_time"])/(60*60*1000)</expression>
> </structure>
> </list-property>
> <expression name="filterExpr">row["start_time"]</expression>
> </structure>
> </list-property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">user_name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">user_name</text-property>
> <property name="analysisColumn">user_name</property>
> </structure>
> <structure>
> <property name="columnName">hostname</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">hostname</text-property>
> <property name="analysisColumn">hostname</property>
> </structure>
> <structure>
> <property name="columnName">start_time</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">start_time</text-property>
> <property name="analysisColumn">start_time</property>
> </structure>
> <structure>
> <property name="columnName">end_time</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">end_time</text-property>
> <property name="analysisColumn">end_time</property>
> </structure>
> <structure>
> <property name="columnName">vendor</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">vendor</text-property>
> <property name="analysisColumn">vendor</property>
> </structure>
> <structure>
> <property name="columnName">server</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">server</text-property>
> <property name="analysisColumn">server</property>
> </structure>
> <structure>
> <property name="columnName">name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">name</text-property>
> <property name="analysisColumn">name</property>
> </structure>
> <structure>
> <property name="columnName">product_name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">product_name</text-property>
> <property name="analysisColumn">product_name</property>
> </structure>
> <structure>
> <property name="columnName">usagetime</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">usagetime</text-property>
> <property name="analysisColumn">usagetime</property>
> </structure>
> <structure>
> <property name="columnName">projectname</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">projectname</text-property>
> <property name="analysisColumn">projectname</property>
> </structure>
> <structure>
> <property name="columnName">groupname</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">groupname</text-property>
> <property name="analysisColumn">groupname</property>
> </structure>
> <structure>
> <property name="columnName">ip</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">ip</text-property>
> <property name="analysisColumn">ip</property>
> </structure>
> </list-property>
> <list-property name="filter"/>
> <list-property name="parameters"/>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">user_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">hostname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">start_time</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">end_time</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">vendor</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">server</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">product_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">usagetime</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">projectname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">groupname</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">ip</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">StartTime_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">EndTime_Date</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">Start_DATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">END_DATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">Cnt_user</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">18</property>
> <property name="name">UsageHours</property>
> <property name="dataType">float</property>
> </structure>
> </list-property>
> </structure>
> <method name="beforeOpen"><![CDATA[//this.queryText = this.queryText + "
> and CAST(payments.payment_date AS DATE ) between '" +
> params["prmFromDate"].value +"' and '" + params["prmToDate"].value +
> "'";]]></method>
> <property name="dataSource">UserUsage DataSource</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">user_name</property>
> <property name="nativeName">user_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">hostname</property>
> <property name="nativeName">hostname</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">start_time</property>
> <property name="nativeName">start_time</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">end_time</property>
> <property name="nativeName">end_time</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">vendor</property>
> <property name="nativeName">vendor</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">server</property>
> <property name="nativeName">server</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">name</property>
> <property name="nativeName">name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">product_name</property>
> <property name="nativeName">product_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">usagetime</property>
> <property name="nativeName">usagetime</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">projectname</property>
> <property name="nativeName">projectname</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">groupname</property>
> <property name="nativeName">groupname</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">ip</property>
> <property name="nativeName">ip</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <xml-property
> name="queryText"><![CDATA[table0#-TNAME-#table0#:#[/ULM/PRODUCTS/PRODUCT]#:#{user_name;STRING;/@user_name},{hostname;STRING;/@hostname},{start_time;STRING;/@start_time},{end_time;STRING;/@end_time},{vendor;STRING;/@vendor},{server;STRING;/@server},{name;STRING;/@name},{product_name;STRING;/@product_name},{usagetime;STRING;/@usagetime},{projectname;STRING;/@projectname},{groupname;STRING;/@groupname},{ip;STRING;/@ip}]]></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>2.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>user_name</design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>user_name</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>hostname</design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>hostname</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>start_time</design:name>
> <design:position>3</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>start_time</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>end_time</design:name>
> <design:position>4</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>end_time</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>vendor</design:name>
> <design:position>5</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>vendor</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>server</design:name>
> <design:position>6</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>server</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>name</design:name>
> <design:position>7</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>name</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>product_name</design:name>
> <design:position>8</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>product_name</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>usagetime</design:name>
> <design:position>9</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>usagetime</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>projectname</design:name>
> <design:position>10</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>projectname</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>groupname</design:name>
> <design:position>11</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>groupname</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>ip</design:name>
> <design:position>12</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>ip</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> <design:criteria/>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> <list-property name="privateDriverProperties">
> <ex-property>
> <name>MAX_ROW</name>
> <value>-1</value>
> </ex-property>
> <ex-property>
> <name>XML_FILE</name>
> </ex-property>
> </list-property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.datatools.enablement.oda.xml.dataSet"
> name="LicenseServer Data Set" id="10">
> <property name="nullsOrdering">nulls lowest</property>
> <list-property name="columnHints">
> <structure>
> <property name="columnName">version</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">version</text-property>
> <property name="analysisColumn">version</property>
> </structure>
> <structure>
> <property name="columnName">vendor</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">vendor</text-property>
> <property name="analysisColumn">vendor</property>
> </structure>
> <structure>
> <property name="columnName">name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">name</text-property>
> <property name="analysisColumn">name</property>
> </structure>
> <structure>
> <property name="columnName">product_name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">product_name</text-property>
> <property name="analysisColumn">product_name</property>
> </structure>
> <structure>
> <property name="columnName">total</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">total</text-property>
> <property name="analysisColumn">total</property>
> </structure>
> <structure>
> <property name="columnName">used</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">used</text-property>
> <property name="analysisColumn">used</property>
> </structure>
> <structure>
> <property name="columnName">borrowed</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">borrowed</text-property>
> <property name="analysisColumn">borrowed</property>
> </structure>
> <structure>
> <property name="columnName">available</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">available</text-property>
> <property name="analysisColumn">available</property>
> </structure>
> <structure>
> <property name="columnName">server_name</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">server_name</text-property>
> <property name="analysisColumn">server_name</property>
> </structure>
> <structure>
> <property name="columnName">expiration_date</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">expiration_date</text-property>
> <property name="analysisColumn">expiration_date</property>
> </structure>
> <structure>
> <property name="columnName">package_no</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">package_no</text-property>
> <property name="analysisColumn">package_no</property>
> </structure>
> <structure>
> <property name="columnName">forecolor</property>
> <property name="analysis">attribute</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">forecolor</text-property>
> <property name="analysisColumn">forecolor</property>
> </structure>
> <structure>
> <property name="columnName">hasp_key</property>
> <property name="analysis">dimension</property>
> <property name="onColumnLayout">false</property>
> <text-property name="heading">hasp_key</text-property>
> <property name="analysisColumn">hasp_key</property>
> </structure>
> </list-property>
> <list-property name="parameters"/>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">version</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">vendor</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">product_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">total</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">used</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">borrowed</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">available</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">server_name</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">expiration_date</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">package_no</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">forecolor</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">hasp_key</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">LicenseServer Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">version</property>
> <property name="nativeName">version</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">vendor</property>
> <property name="nativeName">vendor</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">name</property>
> <property name="nativeName">name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">product_name</property>
> <property name="nativeName">product_name</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">total</property>
> <property name="nativeName">total</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">used</property>
> <property name="nativeName">used</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">borrowed</property>
> <property name="nativeName">borrowed</property>
> <property name="dataType">string</property>

Re: Need help with XML Data source parametrized report [message #727161 is a reply to message #727151]

Tue, 20 September 2011 10:44

Eclipse User

Here you go.

Attachment: LicenseActivity.rptdesign
(Size: 183.24KB, Downloaded 311 times)

Re: Need help with XML Data source parametrized report [message #727162 is a reply to message #727161]

Tue, 20 September 2011 10:46

Eclipse User

basically, I am trying to chart between grouped days (x-axis) and the Utilization% for each day as calculated in the table.

Re: Need help with XML Data source parametrized report [message #727173 is a reply to message #727162]

Tue, 20 September 2011 10:57

Eclipse User

Are the xml data source files sensitive data? If not could you email
them to me at jasonweathersby at windstream dot net?

Jason

On 9/20/2011 10:46 AM, KK wrote:
> basically, I am trying to chart between grouped days (x-axis) and the
> Utilization% for each day as calculated in the table.

Previous Topic:	How Do I Access Data Set Parameters From Scripted Data Source?
Next Topic:	Cant create data engine.

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 19:25:02 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter