Hi guys.<br />
my report uses one csv file (BirtRelationsInfo.csv) as data for cascading parameters (relation,source,timeframe,fromdtae,todate);<br />
than calling a web service to generate another csv file according to these parameters where one of the parameters "source" is the xAxis column and the other is numOfsearches per that source field and relation and is the yAxis.<br />
<br />
The source value can be for example source.field.what ,source.field.where , etc<br />
<br />
so the result csv file is something like<br />
<br />
source.fields.what , numofsearches <br />
games , 20<br />
madonna, 40<br />
bmw , 100<br />
<br />
The rport should display a chart (simple chart tube with categories) according <br />
for that file;<br />
i build the query dynamically where i have 2 variables one is the csv file<br />
and the other is the xAxis column<br />
<br />
if i run the preview where i have defaults file i see the report o.k<br />
<br />
####problem####<br />
the problem :when running on tomcat even from within eclipse<br />
i get the chart but the xAxis are all null and i get the warning <br />
<br />
17/08/2009 20:11:04 org.eclipse.birt.chart.internal.datafeed.ResultSetWrapper initializeMeta<br />
WARNING: Unable to determine data types from resultset<br />
<br />
I print the query and it looks like <br />
<br />
select "search.fields.what" , "searchesNum" from BIRT.20090817201102.csv : {"search.fields.what","search.fields.what",STRING;"searchesNum","searchesNum",STRING}<br />
<br />
i populate some data in the chart in the beforefactory<br />
using variables declared in initialize <br />
<br />
attached are the csv and report rptdesign <br />
i am using the birt viewer as part of a webapp deployed to a tomcat server<br />
all my scripting is done in the rptdesign file <br />
2 java files are used for date manipulation and printing<br />
<br />
Thanks in advance<br />
Yuval<br />
<a href='mailto:' title='E-mail Link' class='bbc_email'>yuvyon@yahoo.com</a>
