Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How Do I Integrate Birt Report with PHP Web Application (Birth Report integration with PHP Web Application)
How Do I Integrate Birt Report with PHP Web Application [message #632919] Thu, 14 October 2010 12:23 Go to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hello Community,

I have a big issue that I truely need help resolving. If this has already been answered, please forgive me. I can't seem to find what I am looking for doing a search.

I need to demo a PHP application that contains reports that a user can dynamically pass parameters too. I have the Zend Community Edition server installed. I have Eclipse with BIRT Reports installed. I can preview the report using the web viewer within Eclipse. However, how do I put it all together in my PHP application?

I have a form with a dropdown box the user selects. I need to pass their selection as a parameter to the BIRT report. However, I have no idea how this is all accomplished. I am able to connect to the database, create a query passing in the user parameter. Obviously, there is a way to pass the results to the BIRT template which I am unclear in how to do. Any help is greatly appreciated.

Regards,

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #632940 is a reply to message #632919] Thu, 14 October 2010 13:39 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Zend has a commercial java bridge you can use to call the BIRT engine to
run reports or you can look at the open source java bridge. I wrote an
article on this approach a while back:
http://www.theserverside.com/news/1363642/Intergrating-BIRT- with-PHP
The bridge should already be updated and you can also get it here:
http://www.birt-exchange.org/org/devshare/deploying-birt-rep orts/743-calling-birt-from-php/

Jason

On 10/14/2010 12:23 PM, Kellylee wrote:
> Hello Community,
>
> I have a big issue that I truely need help resolving. If this has
> already been answered, please forgive me. I can't seem to find what I am
> looking for doing a search.
>
> I need to demo a PHP application that contains reports that a user can
> dynamically pass parameters too. I have the Zend Community Edition
> server installed. I have Eclipse with BIRT Reports installed. I can
> preview the report using the web viewer within Eclipse. However, how do
> I put it all together in my PHP application?
>
> I have a form with a dropdown box the user selects. I need to pass their
> selection as a parameter to the BIRT report. However, I have no idea how
> this is all accomplished. I am able to connect to the database, create a
> query passing in the user parameter. Obviously, there is a way to pass
> the results to the BIRT template which I am unclear in how to do. Any
> help is greatly appreciated.
>
> Regards,
>
> Kellylee


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #632941 is a reply to message #632940] Thu, 14 October 2010 13:53 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
This is very helpful Jason. Thank you so much!

Best Regards,

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #632962 is a reply to message #632941] Thu, 14 October 2010 15:58 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hi Jason,

It appears the JavaBridge is already installed on the Zend Server Community Edition. Do I redownload php-java-bridge_5.4.3.3 that contains the Birt integration? If so, the link you provided contains newer versions but not 5.4.3.3.

I am confused in how to set this on the Zend Server Community Edition. I truely appreciate your expertise in this area. Thank you for taking time out to help me.

Best Regards,

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #633225 is a reply to message #632962] Fri, 15 October 2010 14:22 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Kellylee,

Are you sure the Zend Server does not contain the Zend Java Bridge and
not the the php-java-bridge?

Jason

On 10/14/2010 3:58 PM, Kellylee wrote:
> Hi Jason,
>
> It appears the JavaBridge is already installed on the Zend Server
> Community Edition. Do I redownload php-java-bridge_5.4.3.3 that contains
> the Birt integration? If so, the link you provided contains newer
> versions but not 5.4.3.3.
>
> I am confused in how to set this on the Zend Server Community Edition. I
> truely appreciate your expertise in this area. Thank you for taking time
> out to help me.
>
> Best Regards,
>
> Kellylee


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #633236 is a reply to message #633225] Fri, 15 October 2010 15:09 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hi Jason,

I am not sure. I tried to follow your instructions but they are for TOMCAT.

"The main step is to copy the JavaBridge.war file to the J2EE containers deployment directory. When using Tomcat, this directory is located at TomcatInstallDirectory/webapps."

Do you know the steps I need to follow to get this working on the Zend Server Community Edition?

When I try to run the following Test Script:

<?php
require_once("http://localhost/JavaBridge/java/Java.inc");

echo java("java.lang.System")->getProperties();
?>

I get this error:

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Best Regards,

Kelly




Re: How Do I Integrate Birt Report with PHP Web Application [message #633242 is a reply to message #633236] Fri, 15 October 2010 15:41 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I thought the Zend Community server had its own Java Bridge. Do you see
any BIRT reports in the Community edition?

Jason

On 10/15/2010 3:09 PM, Kellylee wrote:
> Hi Jason,
>
> I am not sure. I tried to follow your instructions but they are for TOMCAT.
>
> "The main step is to copy the JavaBridge.war file to the J2EE containers
> deployment directory. When using Tomcat, this directory is located at
> TomcatInstallDirectory/webapps."
>
> Do you know the steps I need to follow to get this working on the Zend
> Server Community Edition?
>
> When I try to run the following Test Script:
>
> <?php require_once("http://localhost/JavaBridge/java/Java.inc");
>
> echo java("java.lang.System")->getProperties();
> ?>
>
> I get this error:
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
>
> Please contact the server administrator, mailto:admin@example.com and
> inform them of the time the error occurred, and anything you might have
> done that may have caused the error.
>
> More information about this error may be available in the server error log.
>
> Best Regards,
>
> Kelly
>
>
>
>
>


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #633243 is a reply to message #633242] Fri, 15 October 2010 15:48 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Zend server does have a Java Bridge. I just don't think it supports BIRT reporting. I probably need to install the JavaBridge that supports BIRT reporting, which I do not know how to do.

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #633250 is a reply to message #633243] Fri, 15 October 2010 16:07 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I worked with the Zend team on building an integration a while back. I
thought it was included:
http://files.zend.com/help/Zend-Platform-i5/birt_apis.htm

http://forums.zend.com/viewtopic.php?f=52&t=3501

Jason

On 10/15/2010 3:48 PM, Kellylee wrote:
> Zend server does have a Java Bridge. I just don't think it supports
> BIRT reporting. I probably need to install the JavaBridge that supports
> BIRT reporting, which I do not know how to do.
>
> Kellylee


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #635175 is a reply to message #633250] Mon, 25 October 2010 16:47 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hello Jason,

Ok, I was told the Zend CE edition does not work with BIRT reports unless I setup a Tomcat server. However, the Enterprise Zend server is suppose to do this without needing to download Tomcat.

I downloaded the Windows version Zend Server 5.0.3 trial. The Java Bridge is installed. I installed Zend Studio 7.2 and installed the Birt Plugins. I created a report in Zend Studio. How do I deploy this report? This is where I am confused.

Best Regards,

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #635350 is a reply to message #635175] Tue, 26 October 2010 10:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Kellylee,

I though they had a menu item for this, but I do not remember where.
Can you search the install for *birt*?

Jason

On 10/25/2010 4:47 PM, Kellylee wrote:
> Hello Jason,
>
> Ok, I was told the Zend CE edition does not work with BIRT reports
> unless I setup a Tomcat server. However, the Enterprise Zend server is
> suppose to do this without needing to download Tomcat.
>
> I downloaded the Windows version Zend Server 5.0.3 trial. The Java
> Bridge is installed. I installed Zend Studio 7.2 and installed the Birt
> Plugins. I created a report in Zend Studio. How do I deploy this report?
> This is where I am confused.
>
> Best Regards,
>
> Kellylee


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #635358 is a reply to message #635350] Tue, 26 October 2010 10:52 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hi Jason,

I can not find a BIRT folder; however, when I run a BIRT report in Zend Studio the URL it is pointing to is http://localhost:63374/viewer/webcontent/birt

Best Regards,

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #635382 is a reply to message #635358] Tue, 26 October 2010 11:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Kellylee,

That url is the BIRT Viewer and does not use the JavaBridge at all.
Zend used to have the BIRT engine integrated much like the open source
JavaBridge article I wrote which uses the Birt Engine not the Viewer.
If you want to use the viewer you could always just add iframes to the
php page that include the url to the birt viewer deployed on tomcat.

Jason

On 10/26/2010 10:52 AM, Kellylee wrote:
> Hi Jason,
>
> I can not find a BIRT folder; however, when I run a BIRT report in Zend
> Studio the URL it is pointing to is
> http://localhost:63374/viewer/webcontent/birt
>
> Best Regards,
>
> Kellylee


Jason Weathersby

BIRT Exchange
Re: How Do I Integrate Birt Report with PHP Web Application [message #635387 is a reply to message #635382] Tue, 26 October 2010 11:55 Go to previous messageGo to next message
Kellylee  is currently offline Kellylee
Messages: 8
Registered: October 2010
Junior Member
Hi Jason,

I tried to follow your instructions by downloading the Tomcat server. I followed your instructions completely. I could view the report only on Tomcat. I was never able to view the BIRT report using the JavaBridge on the Apache Sever, which is why I decided to try the Zend server and Zend studio.

I truely am at a lost in what to do at this point. I need to provide a demo to some high level executives but have no way at this point to accomplish this task. Is there any way I can contact you for some help? Maybe, if I follow your instructions while talking to you, I can determine what is going wrong.

Again, thank you for your help.

Kellylee
Re: How Do I Integrate Birt Report with PHP Web Application [message #635404 is a reply to message #635387] Tue, 26 October 2010 12:19 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Kellylee,

My email is jasonweathersby at windstream dot net. Send me an email.

Jason

On 10/26/2010 11:55 AM, Kellylee wrote:
> Hi Jason,
>
> I tried to follow your instructions by downloading the Tomcat server. I
> followed your instructions completely. I could view the report only on
> Tomcat. I was never able to view the BIRT report using the JavaBridge on
> the Apache Sever, which is why I decided to try the Zend server and Zend
> studio.
> I truely am at a lost in what to do at this point. I need to provide a
> demo to some high level executives but have no way at this point to
> accomplish this task. Is there any way I can contact you for some help?
> Maybe, if I follow your instructions while talking to you, I can
> determine what is going wrong.
>
> Again, thank you for your help.
>
> Kellylee


Jason Weathersby

BIRT Exchange
Previous Topic:Reset Chart's preview image
Next Topic:Images in Excel output
Goto Forum:
  


Current Time: Wed Apr 16 12:11:39 EDT 2014

Powered by FUDForum. Page generated in 0.02691 seconds