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.