← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #01022

Re: Providing another source table for reports

  Thread Previous • Date Previous • • Thread Next 
Hi Cintia,

This report does not have any Data Sorce and Data Set defined. Can you please send report with data set definitions please?

regards,
murod




________________________________
From: Cintia Marisa <cintia.banze@xxxxxxxxx>
To: Murodullo Latifov <murodlatifov@xxxxxxxxx>; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Sent: Monday, May 18, 2009 2:50:51 PM
Subject: Re: [Dhis2-devs] Providing another source table for reports

 Sure,
In attachment the design.


On Mon, May 18, 2009 at 9:19 AM, Murodullo Latifov <murodlatifov@xxxxxxxxx> wrote:

Hi Cintia,

Could you please send me your report file?

regards,
murod




________________________________
From: Cintia Marisa <cintia.banze@xxxxxxxxx>
To: Ola Hodne Titlestad <olati@xxxxxxxxxx>
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Sent: Friday, May 15, 2009 3:52:31 PM
Subject: Re: [Dhis2-devs] Providing another source table for reports


 Hi,

Sorry, about  the reply thing. I keep forgetting.

And no, that doesn't happen with report tables. The report work just fine, with a report table. the problem is when I use another source table.



On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:

Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it's not a BIRT viewer/designer incompatibility issue. 

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?


best regards,
Ola Hodne Titlestad
HISP
University of Oslo



On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa <cintia.banze@xxxxxxxxx> wrote:

I've checked, and it's not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.





On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa <cintia.banze@xxxxxxxxx> wrote:

Hi all,
1st 
Thank u guys for the help.


2nd 
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get "no report design available" error.

Here's the log: 

====================================================

* INFO  09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])
* INFO  09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])
* INFO  09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])
* INFO  09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])
org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
    at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
    at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)
    at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
    at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
    at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)
    at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
    at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)


====================================================


 The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod's deisgner (since he designed the report) are different versions.
Have you tried your BIRT viewer with reports designed with the same version? Try open Murod's report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola
---------


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




-- 
Cintia Marisa


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




-- 
Cintia Marisa




-- 
Cintia Marisa

Follow ups

References

  Thread Previous • Date Previous • • Thread Next