----------------------------------------
From: "Bart Berning (Contractor)" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2008 3:24 AM
To: [EMAIL PROTECTED]>, <[EMAIL PROTECTED]>,
<[email protected]
Subject: RE: [Mifos-developer] REPORT GENERATING ERROR.
Hi Sunday,
I understand what you mean. Yes, a BIRT table can
only contain data from one Data Set. Logically, that limitation makes
sense, because two Data Sets will not have the same number of
rows, and the table would not be able to display properly.
If you want your table to contain data from two Data Sets, then you
should try to create a Joint Data Set from the two Data Sets first, and then
bind that Joint Data Set to the table.
If you are just displaying data but it is NOT suitable
for a table - for example, it is just a collection of results from
many different Data Sets - then I'd suggest using a Grid. You can
drag fields from many different Data Sets into one Grid, with no
problems.
Hope that helps!
Bart
----------------------------------------
From: OWOEYE SUNDAY LAURENCE
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 4:41
PM
To: Bart Berning (Contractor);
[EMAIL PROTECTED];
[email protected]
Subject: RE: [Mifos-developer]
REPORT GENERATING ERROR.
Hello all,
Thanks for your
response to my request.
I have implemented it and it worked.
But the
challenge am having now is
how I can use two tables in mifos database to
generate
a report in birt reporting engine. That is, if a
report contain some informations that are not in the data set1 table of
mifos database, the second table in mifos database that contain
the
rest informations, which is the data set2, is what am having challenge of
dragging the information of the data set2, into a report template table which
does not stay is the column provide for it, in a template table.
It only the data set1 that am able to drag into
the position I provide in a template table.
My question now is how
I can join two tables together in a single report, in the birt reporting
engine using two data set in a single template table.
Thanks.
Remain
Bless.
----------------------------------------
From: "Bart Berning (Contractor)"
<[EMAIL PROTECTED]>
Sent: Tuesday, June
17, 2008 2:25 AM
To: [EMAIL PROTECTED]>, "Developer"
<[EMAIL PROTECTED]>,
<[email protected]
Subject: RE:
[Mifos-developer] REPORT GENERATING ERROR.
Hi SUNDAY,
That is caused by a version mis-match. The BIRT
Report Engine that we've embedded into Mifos supports up to version
3.2.6. You can see the version number in the XML;
your file is 3.2.15. If
you use the BIRT RCP version 2.1.2 , it will produce reports in version
3.2.6.
You can also see this issue described
here: https://mifos.dev.java.net/issues/show_bug.cgi?id=1835
Hope that helps!
Bart
----------------------------------------
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
OWOEYE SUNDAY LAURENCE
Sent: Tuesday, June 17, 2008
2:53 PM
To: [EMAIL PROTECTED];
[email protected]
Subject:
[Mifos-developer] REPORT GENERATING ERROR.
HELLO ALL,
AFTER I CREATED REPORT TEMPLATE FROM BIRT REPORT
ENGINE.
I USE D JDBC AS A CONNECTOR TO THE MIFOS DATABASE.
THEN I UPLOADED
IT TO THE MIFOS APPLICATION THROUGH ADMIN
MODULE AREA, NOW GOING TO THE
REPORT MODULE TO VIEW THE
REPORT AS PDF THE FOLLOWING ERROR DISPLAY ON
MIFOS
APPLICATION.
/usr/local/apache-tomcat/webapps/mifos/report/new.rptdesign has
error and can not be run.
I MAKE MY REPORT SCRIPT AS AN ATTACH FILE IF
THE IS AN ERROR THE PLEASE
I NEED CORRECTION.
THANKS YOU ALL.
REMAIN
BLESS.
Hello All,
Am having problem in creating report parameters so
as to generate the result been required..i really an assistance to this
problem and challenges am facing which i believe a solution can be
render..
i created this date set and report parameter
Data Set
1.branch office
2.loan officer
report parameter
branch office id
loan officer id
under the data set for Business unit i created a parameter which i used this
following datas
Name: business unit
Data Type:any
Direction:input
Default Value:N/A
link to report:business unit id
when i previewed to see the result this are the following error been generated
This are the Errors that are been generated ..
Cannot set the string value for parameter:1
cannot
set prepared statement parameter string value SQL error £1: parameter
index out of range (1>number of parameters, which is 0).
Reason: A birt exception occurred.
So the report I want to general we base on the transaction that a loan officer
perform for one day either deposit or withdrawal.
thanks
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Mifos-functional mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-functional
