6 Replies Latest reply: Aug 29, 2011 10:33 AM by Carlos Celis Osorio RSS

    Error with the URL generating a BIRT drill through report [solved]

    Carlos Celis Osorio Newbie

      Hi there.

       

      I have a problem when I try to generate a linked report from a column located in other report.

      The problem is that URL is not valid because BIRT puts stranger characters on it and relative path isn't correct.

      In addition, the parameters are in brackets [] when they should not be among them.

       

       

      Following is the source report:

       

       

      Fecha

      Zona

      Cantidad

      Porcentaje

      2011/08/01

      00440500

      2

      100%

      2011/08/05

      00440500

      1

      100%

      2011/08/08

      00440500

      1

      100%





      17/08/2011 12:07

       

       

      As you can see, in column "Cantidad" there are 2 units for the date 2011/08/01 in column "Fecha".

      When I do click on 2011/08/01, I should view the next report:

       

       

      Fecha

      Zona

      Nombre

      Ciudad

      Direccion

      Descripcion

      Novedad

      Telefono

      17:05:11

      00440500

      XXX  XXX

      BOGO

      STREET xxx - xx

      Tiempo 12 M Cortesia

       

      xxxxxxx

      17:46:26

      00440500

      YYY YYY

      BOGO

      STREET xxx xx - xx

      Tiempo 12 M

       

      xxxxxxx









      Aug 17, 2011 12:06 PM

       

       

      In fact, I manage to view the report in report viewer in Eclipse but not in the website.

      I am using Drill-through in Hyperlink options for column "Fecha" in detail row of the table.

       

       

      The following is the generated URL in the web browser by the system:

       

      http://localhost:8080/ElTiempo/distribution/report/run?__report=%2FC%3A%2FUsers%2Fdesktopins8%2Fworkspace%2F.metadata%2F.plugins%2Forg.jboss.ide.eclipse.as.core%2FJBoss_6.0_Runtime_Server1312301217418%2Fdeploy%2FElTiempo.war%2Fdistribution%2Fdesign%2FreporteConDetalle.rptdesign&TipoReporte=[D]&FechaInicioString=[2011%2F08%2F01]&FechaFinString=[2011%2F08%2F01]&Zona=[00440500]&__overwrite=true
      

       

       

      When, the correct URL should be this:

       

      http://localhost:8080/ElTiempo/run?__report=/C:/Users/desktopins8/workspace/.metadata/.plugins/org.jboss.ide.eclipse.as.core/JBoss_6.0_Runtime_Server1312301217418/deploy/ElTiempo.war/distribution/design/reporteConDetalle.rptdesign&__format=html&TipoReporte=D&FechaInicioString=2011/08/01&FechaFinString=2011/08/01&Zona=00440500&__overwrite=true
      

       

       

      Can you help me?

      In advance, thanks for your help.