Eclipse Community Forums: BIRT » Php Dynamic Query pass to birt report

Home » Archived » BIRT » Php Dynamic Query pass to birt report

Php Dynamic Query pass to birt report [message #642950]

Fri, 03 December 2010 08:36

Eclipse User

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 10:01

Eclipse User

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 10:10

Eclipse User

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 12:32

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 03:48:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter