Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Php Dynamic Query pass to birt report
Php Dynamic Query pass to birt report [message #642950] Fri, 03 December 2010 13:36 Go to next message
Shuja  is currently offline Shuja Friend
Messages: 3
Registered: December 2010
Junior Member
Hi All
I am wondering if any one can answer this simple question

I am new to birt reports and want to know that can we pass whole query to birt report from php?
e.g I have form in php where user selects different options and a dynamic query is built (Only where clause will be made).

select a,b from c where d=2, and e=4

now i want to pass this complete query to birt report using php as we can do it in.net.

Kindly let me know it if is possible

Thanks in advance
Shuja
Re: Php Dynamic Query pass to birt report [message #642976 is a reply to message #642950] Fri, 03 December 2010 15:01 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Yes this is possible, but first how do you have BIRT deployed and how
are you calling it from php currently?

Jason

On 12/3/2010 8:36 AM, Shuja wrote:
> Hi All
> I am wondering if any one can answer this simple question
>
> I am new to birt reports and want to know that can we pass whole query
> to birt report from php?
> e.g I have form in php where user selects different options and a
> dynamic query is built (Only where clause will be made).
> select a,b from c where d=2, and e=4
>
> now i want to pass this complete query to birt report using php as we
> can do it in.net.
>
> Kindly let me know it if is possible
>
> Thanks in advance Shuja
Re: Php Dynamic Query pass to birt report [message #642979 is a reply to message #642976] Fri, 03 December 2010 15:10 Go to previous messageGo to next message
Shuja  is currently offline Shuja Friend
Messages: 3
Registered: December 2010
Junior Member
Yes this is possible, but first how do you have BIRT deployed and how
are you calling it from php currently?

I have deployed according to following link

http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php

today is my first day with birt reports and i just make the report and deploy it. I did not still called it from php. I am searching the appropriate method to call it from php.

Kindly share your thoughts

Thanks
Shuja
Re: Php Dynamic Query pass to birt report [message #643042 is a reply to message #642979] Fri, 03 December 2010 17:32 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you want to use the viewer with all its AJAX functionality you will
need to forward from php or use an iframe. If you want to use the
Engine you can access it using the open source Java Bridge
http://www.theserverside.com/news/1363642/Intergrating-BIRT- with-PHP

inside a BIRT report you can get access to the request object( if sql is
a request parameter) and in the beforeOpen of the dataset set the query
to whatever you want.

Jason

On 12/3/2010 10:10 AM, Shuja wrote:
> Yes this is possible, but first how do you have BIRT deployed and how
> are you calling it from php currently?
>
> I have deployed according to following link
>
> http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php
>
> today is my first day with birt reports and i just make the report and
> deploy it. I did not still called it from php. I am searching the
> appropriate method to call it from php.
> Kindly share your thoughts
>
> Thanks
> Shuja
Previous Topic:XLS export & cell format
Next Topic:OC4J 10.1.3 + Report Engine API
Goto Forum:
  


Current Time: Sun Nov 23 12:32:11 GMT 2014

Powered by FUDForum. Page generated in 0.01700 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software