Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » drill-through hyperlinks contain unwanted ../../..
drill-through hyperlinks contain unwanted ../../.. [message #640071] Thu, 18 November 2010 17:21 Go to next message
No real name is currently offline No real name
Messages: 5
Registered: November 2010
Junior Member
I created a pie chart and a detail chart. I configured the pie chart to drill through to the detail chart. I saved them both as .rptdocument in the project directory.

When I run this under eclipse it works correctly.

When I copy both .rptdocument files to the

$TOMCAT_HOME/webapps/WebViewerExample file, they work indendently, but the drill through is broken.

The message I get is:

org.eclipse.birt.report.exception.ViewerException: Cannot access the document file : C:\Apache Software Foundation\Tomcat 6.0\webapps\WebViewerExample/../../../detail.rptdocument.

I do not know where the "../../.." is coming from. Without the "../../.." it works, but I can't figure out how to prevent "../../.." from getting inserted into my hyperlink.

Does anyone have any idea what might be causing this?

Thanks!!


Re: drill-through hyperlinks contain unwanted ../../.. [message #640207 is a reply to message #640071] Fri, 19 November 2010 10:07 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

What version of BIRT are you using and can you post the report?

Jason


On 11/18/2010 5:21 PM, rhinmass@yahoo.com wrote:
> I created a pie chart and a detail chart. I configured the pie chart to


> drill through to the detail chart. I saved them both as .rptdocument in
> the project directory.
> When I run this under eclipse it works correctly.
>
> When I copy both .rptdocument files to the
> $TOMCAT_HOME/webapps/WebViewerExample file, they work indendently, but
> the drill through is broken.
> The message I get is:
>
> org.eclipse.birt.report.exception.ViewerException: Cannot access the
> document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../detail.rptdocument.
>
> I do not know where the "../../.." is coming from. Without the
> "../../.." it works, but I can't figure out how to prevent "../../.."
> from getting inserted into my hyperlink.
>
> Does anyone have any idea what might be causing this?
>
> Thanks!!
>
>
>


Jason Weathersby

BIRT Exchange
Re: drill-through hyperlinks contain unwanted ../../.. [message #640246 is a reply to message #640207] Fri, 19 November 2010 13:22 Go to previous messageGo to next message
No real name is currently offline No real name
Messages: 5
Registered: November 2010
Junior Member
I am using 2.6.1

I'm new to this group and can't seem to figure out how to upload my files.

Here are the recreate steps.

1. For dataset use flat csv file:
item,color
apple,red
fire truck,red
sky,blue
sun,yellow
banana,yellow
grass,green
money,green
envy,green
rash,red
violet,blue
rose,red
smurf,blue
lime,green
avocado,green


2. Create color_detail.rptdesign, from this data set. I just dragged the dataset onto the layout; previewed and saved.

3. Under Run menu, click on generate document and save it in the project folder alongside the rptdesign file.

4. Create new report pie.rptdesign with same data set above.

5. Create pie chart. For slice size definition use COUNT row["item"]. For category use row["color"]

6. Click "Finish" ; save report .

7. Edit the pie chart and go to Format Chart; Series; Value Series; Interactivity

8. Choose Action Hyperlink, then add "color detail"; Edit Base URL; drill-through; Choose Report Document and navigate to the document file generated in step 3.

9. click OK; save the report and test it to make sure the drill-through works (ie when click on pie chart , the detail report pops up.)

10. Generate the pie.rptdocument as done in step 3.

11. Copy both pie.rptdocument and color_detail.rptdocument to the $TOMCATHOME/webapps/WebViewerExample folder

12. View the pie in webbrowser:
http://localhost:8080/WebViewerExample/frameset?__document=p ie.rptdocument

13. Click on the pie chart. The error message appears:

Cannot access the document file : C:\Apache Software Foundation\Tomcat 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.

org.eclipse.birt.report.exception.ViewerException: Cannot access the document file : C:\Apache Software Foundation\Tomcat 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.


Note that removing the "../../../" in the above link yields the detail chart.

14. Also I noticed that if I copy pie.rptdesign into the webapps/WebViewerExample folder and view it using the URL:

http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign, the drill-through does work correctly.

Re: drill-through hyperlinks contain unwanted ../../.. [message #640261 is a reply to message #640246] Fri, 19 November 2010 14:02 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you either select the xml view and cut and paste report to the forum
or just email the files to me at jasonweathersby at windstream dot net.

Thanks

Jason

On 11/19/2010 1:22 PM, rhinmass@yahoo.com wrote:
> I am using 2.6.1
>
> I'm new to this group and can't seem to figure out how to upload my files.
> Here are the recreate steps.
>
> 1. For dataset use flat csv file:
> item,color
> apple,red
> fire truck,red
> sky,blue
> sun,yellow
> banana,yellow
> grass,green
> money,green
> envy,green
> rash,red
> violet,blue
> rose,red
> smurf,blue
> lime,green
> avocado,green
>
>
> 2. Create color_detail.rptdesign, from this data set. I just dragged the
> dataset onto the layout; previewed and saved.
>
> 3. Under Run menu, click on generate document and save it in the project
> folder alongside the rptdesign file.
>
> 4. Create new report pie.rptdesign with same data set above.
>
> 5. Create pie chart. For slice size definition use COUNT row["item"].
> For category use row["color"]
>
> 6. Click "Finish" ; save report .
>
> 7. Edit the pie chart and go to Format Chart; Series; Value Series;
> Interactivity
>
> 8. Choose Action Hyperlink, then add "color detail"; Edit Base URL;
> drill-through; Choose Report Document and navigate to the document file
> generated in step 3.
>
> 9. click OK; save the report and test it to make sure the drill-through
> works (ie when click on pie chart , the detail report pops up.)
>
> 10. Generate the pie.rptdocument as done in step 3.
>
> 11. Copy both pie.rptdocument and color_detail.rptdocument to the
> $TOMCATHOME/webapps/WebViewerExample folder
>
> 12. View the pie in webbrowser:
> http://localhost:8080/WebViewerExample/frameset?__document=p ie.rptdocument
>
> 13. Click on the pie chart. The error message appears:
>
> Cannot access the document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.
>
> org.eclipse.birt.report.exception.ViewerException: Cannot access the
> document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.
>
>
> Note that removing the "../../../" in the above link yields the detail
> chart.
>
> 14. Also I noticed that if I copy pie.rptdesign into the
> webapps/WebViewerExample folder and view it using the URL:
>
> http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign,
> the drill-through does work correctly.
>


Jason Weathersby

BIRT Exchange
Re: drill-through hyperlinks contain unwanted ../../.. [message #640264 is a reply to message #640246] Fri, 19 November 2010 14:23 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you try deploying both reports and then use the
__document=c:/temp/myrptdocument to generate the documents?

Jason

On 11/19/2010 1:22 PM, rhinmass@yahoo.com wrote:
> I am using 2.6.1
>
> I'm new to this group and can't seem to figure out how to upload my files.
> Here are the recreate steps.
>
> 1. For dataset use flat csv file:
> item,color
> apple,red
> fire truck,red
> sky,blue
> sun,yellow
> banana,yellow
> grass,green
> money,green
> envy,green
> rash,red
> violet,blue
> rose,red
> smurf,blue
> lime,green
> avocado,green
>
>
> 2. Create color_detail.rptdesign, from this data set. I just dragged the
> dataset onto the layout; previewed and saved.
>
> 3. Under Run menu, click on generate document and save it in the project
> folder alongside the rptdesign file.
>
> 4. Create new report pie.rptdesign with same data set above.
>
> 5. Create pie chart. For slice size definition use COUNT row["item"].
> For category use row["color"]
>
> 6. Click "Finish" ; save report .
>
> 7. Edit the pie chart and go to Format Chart; Series; Value Series;
> Interactivity
>
> 8. Choose Action Hyperlink, then add "color detail"; Edit Base URL;
> drill-through; Choose Report Document and navigate to the document file
> generated in step 3.
>
> 9. click OK; save the report and test it to make sure the drill-through
> works (ie when click on pie chart , the detail report pops up.)
>
> 10. Generate the pie.rptdocument as done in step 3.
>
> 11. Copy both pie.rptdocument and color_detail.rptdocument to the
> $TOMCATHOME/webapps/WebViewerExample folder
>
> 12. View the pie in webbrowser:
> http://localhost:8080/WebViewerExample/frameset?__document=p ie.rptdocument
>
> 13. Click on the pie chart. The error message appears:
>
> Cannot access the document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.
>
> org.eclipse.birt.report.exception.ViewerException: Cannot access the
> document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.
>
>
> Note that removing the "../../../" in the above link yields the detail
> chart.
>
> 14. Also I noticed that if I copy pie.rptdesign into the
> webapps/WebViewerExample folder and view it using the URL:
>
> http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign,
> the drill-through does work correctly.
>


Jason Weathersby

BIRT Exchange
Re: drill-through hyperlinks contain unwanted ../../.. [message #640277 is a reply to message #640264] Fri, 19 November 2010 16:12 Go to previous messageGo to next message
No real name is currently offline No real name
Messages: 5
Registered: November 2010
Junior Member
Hi Jason,

I'm not sure I understand what this is supposed to do. I added &__document=c:/temp/myrptdocument to the URL:

http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign&__document=c:/temp/myrptdocument

and got:

Cannot access the document file : c:/temp/myrptdocument.

org.eclipse.birt.report.exception.ViewerException: Cannot access the document file : c:/temp/myrptdocument.


I do have a C:\temp folder , but rptdocument files in it.
[quote title=Jason Weathersby wrote on Fri, 19 November 2010 14:23]Can you try deploying both reports and then use the
__document=c:/temp/myrptdocument to generate the documents?

Jason

Re: drill-through hyperlinks contain unwanted ../../.. [message #640281 is a reply to message #640277] Fri, 19 November 2010 16:43 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I believe the hyperlinks are baked into the rptdocument. So when you
generate the rptdocument in the designer it is using the hyperlink that
was created there. Using __document in the viewer url should create the
rptdocument in the viewer. Just make sure to specify a __report and a
__document. You can then re-run your previous test with the newly
created documents.

Jason

On 11/19/2010 4:12 PM, rhinmass@yahoo.com wrote:
> Hi Jason,
> I'm not sure I understand what this is supposed to do. I added
> &__document=c:/temp/myrptdocument to the URL:
>
> http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign&__document=c:/temp/myrptdocument
>
>
> and got:
>
> Cannot access the document file : c:/temp/myrptdocument.
>
> org.eclipse.birt.report.exception.ViewerException: Cannot access the
> document file : c:/temp/myrptdocument.
>
>
> I do have a C:\temp folder , but rptdocument files in it.
> [quote title=Jason Weathersby wrote on Fri, 19 November 2010 14:23]Can
> you try deploying both reports and then use the
> __document=c:/temp/myrptdocument to generate the documents?
>
> Jason
>
>


Jason Weathersby

BIRT Exchange
Re: drill-through hyperlinks contain unwanted ../../.. [message #640287 is a reply to message #640281] Fri, 19 November 2010 19:50 Go to previous messageGo to next message
No real name is currently offline No real name
Messages: 5
Registered: November 2010
Junior Member
OK, I think I see what is going on. The intermediate report is under WebViewerExample/documents/long-dir-name/long-dir-name/WebVi ewerExample/pie.rptdocument.

hmm... My goal is to be able to pregenerate the pie chart and detail reports corresponding to each sector each night from a cron job, because the real detail queries have several seconds latency. However, as it is I don't think it will work. Even if I manually place the pie report three levels down:

http://localhost:8080/WebViewerExample/frameset?__document=d ocuments\A\B\WebViewerExample\pie.rptdocument

I get the same error when I click on the pie:

Cannot access the document file : C:\Apache Software Foundation\Tomcat 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.

Do you know of anyway to pregenerate the documents and have them link correctly?

Thanks for any help.
Re: drill-through hyperlinks contain unwanted ../../.. [message #640617 is a reply to message #640287] Mon, 22 November 2010 10:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you try something like:

http://localhost:8080/WebViewerExample/frameset?__report=pie .rptdesign&__document=pie.rptdocument&__overwrite=fa lse

Where pie.rptdocument is pregenerated and deployed with the design?

Jason


On 11/19/2010 7:50 PM, rhinmass@yahoo.com wrote:
> OK, I think I see what is going on. The intermediate report is under
> WebViewerExample/documents/long-dir-name/long-dir-name/WebVi
> ewerExample/pie.rptdocument.
>
> hmm... My goal is to be able to pregenerate the pie chart and detail
> reports corresponding to each sector each night from a cron job, because
> the real detail queries have several seconds latency. However, as it is
> I don't think it will work. Even if I manually place the pie report
> three levels down:
>
> http://localhost:8080/WebViewerExample/frameset?__document=d ocuments\A\B\WebViewerExample\pie.rptdocument
>
>
> I get the same error when I click on the pie:
>
> Cannot access the document file : C:\Apache Software Foundation\Tomcat
> 6.0\webapps\WebViewerExample/../../../color_detail.rptdocume nt.
>
> Do you know of anyway to pregenerate the documents and have them link
> correctly?
>
> Thanks for any help.


Jason Weathersby

BIRT Exchange
Re: drill-through hyperlinks contain unwanted ../../.. [message #640645 is a reply to message #640617] Mon, 22 November 2010 11:53 Go to previous message
No real name is currently offline No real name
Messages: 5
Registered: November 2010
Junior Member
Thank you, Jason. That works.

Previous Topic:Hide Excel Gridlines
Next Topic:Birt 2.5.2 - JNDI not used after application reload under tomcat--> Missing properties in Connect
Goto Forum:
  


Current Time: Fri Apr 18 01:41:03 EDT 2014

Powered by FUDForum. Page generated in 0.03603 seconds