drill-through almost working

I have birt deployed and my reports are running, but drill through is not working on my server. I have it working on my eclipse in the web viewer. It works on my local box running tomcat 6 on windows. but on my centos server running tomcat6 the link to the next report is wrong.
This is the link the report generates:"http://reports.example.com:8080/example-reports/frameset?__report=../../../apache-tomcat-6.0.20/webapps/example-reports/report/test/drill_report.rptdesign&__format=html&startDate=2009-02&__overwrite=true&__locale=en_US&__svg=false&__designer=false&__pageoverflow=0&__masterpage=true"

if I remove the ../'s it works fine so I know the report is there but the generation of that link is incorrect. I can not find a setting to change how the path for this is set.

Find more posts tagged with

Comments

bigjireh

Can no one help with this?? I see two other posts with similar problems and no help. If this is a variable some where, please tell me where so I can change it.

mwilliams

Hi bigjireh,

In your web.xml file, try changing the value for BIRT_VIEWER_WORKING_FOLDER from true to false.

bigjireh

Thank you.

The variable to change to make this work is in the web.xml as stated above, the variable to change is "WORKING_FOLDER_ACCESS_ONLY".
Change it from true to false and presto life is good once again.

envision

We are having a similar problem where the URL on our servers is being created with __report=..%2F..%2F..%2F[working_dir]%2F[report_name] and on some local instances as simply __report=[report_name]. While changing the setting of WORKING_FOLDER_ACCESS_ONLY to false may solve this issue, we really do only want to be able to access reports in the working folder, and these reports are actually in the working folder. The above URL points to the working folder, but it does so using ../../../ etc, in some instances so BIRT doesn't recognize this as in the working folder. Does anyone know why BIRT sometimes creates URLS this way?

envision

OK, so I finally figured this out. Bottom line is to make sure that your working directory (defined in web.xml) is exactly the same case as the actual directory where your reports are located. Windows is not case-sensitive, but the code that tries to build a relative path when the WORKING_FOLDER_ACCESS_ONLY flag = true is. There is a method in org.eclipse.birt.report.model.api.util.URIUtil called createRelativePathFromString that walks through the actual location of the file and the working directory path character by character to try and find where they are different and build a relative path. This is the code that puts in the ../ characters. Because the case is different (such as c:Reports compared to c:reports) it says they are different and builds the path relative to where the difference occurred.