Home » Archived » BIRT » Report Parameter Combo Items
| Report Parameter Combo Items [message #33364] |
Tue, 03 May 2005 09:12  |
Eclipse User |
|
|
|
Originally posted by: Zohair.hasan.snstech.com
Hi,
While getting the parameter input from user,if its a Combo Box,can we
retrive the items from Database.Say i want to get the details of the
specefic department supplied by the user as input,can Combo list be
dynamically generated? for example from database,so that modifications in
database will reflect the Combo items of Report Parameters too.
Is there any possibility by which we can implement this in Birt.
Anyone got this working, please help!!
Using Birt M2 build .
Thanks in advance
|
|
|
| Re: Report Parameter Combo Items [message #33469 is a reply to message #33364] |
Tue, 03 May 2005 10:33  |
| Eclipse User |
|
|
|
Originally posted by: a14342.gmail.com
Zohair,
Just my looking at the screen, options,it doesnt look it is possible to
get the data from database to populate the list box..I also had a exact
question!!.
On a side note, do you know how to bind a report parameter and data set
parameter ?
-Naveen
Zohair wrote:
> Hi,
> While getting the parameter input from user,if its a Combo Box,can we
> retrive the items from Database.Say i want to get the details of the
> specefic department supplied by the user as input,can Combo list be
> dynamically generated? for example from database,so that modifications in
> database will reflect the Combo items of Report Parameters too.
> Is there any possibility by which we can implement this in Birt.
> Anyone got this working, please help!!
> Using Birt M2 build .
> Thanks in advance
|
|
|
| Re: Report Parameter Combo Items [message #33711 is a reply to message #33469] |
Tue, 03 May 2005 17:09 |
| Eclipse User |
|
|
|
Naveen & Zohair,
BIRT 1.0 won't provide dynamic parameters (lists that come from the
database), but it is proposed for a later release. The proposed design is
described in the ROM specs in the section that describes parameters.
Briefly, the idea is that you'll be able to declare a BIRT data set that
provides the data, and that data set will be used to obtain the list. Does
this feature sound like one that would solve your problem? Are there
specific requirements you can suggest?
In the mean time, you can create a custom parameter page using JSP or PHP.
You can use the Java or PHP techniques for accessing the database. The
custom parameter pages allow you to integrate these pages more closely with
your application, then delegate to BIRT the responsibility of running the
reports. Will this solution work for your app, or would you prefer to use
the BIRT parameter UI?
There was question about how to bind a report and data set parameter. See
this page for details:
http://www.eclipse.org/birt/index.php?page=faq/params.html
And, see the Data Set Parameters section of this page:
http://www.eclipse.org/birt/index.php?page=faq/data.html
Thanks,
- Paul
Paul Rogers
BIRT PMC
"Naveen" <a14342@gmail.com> wrote in message
news:f398b643d2202366a7426ffd66d89800$1@www.eclipse.org...
> Zohair,
> Just my looking at the screen, options,it doesnt look it is possible to
> get the data from database to populate the list box..I also had a exact
> question!!.
> On a side note, do you know how to bind a report parameter and data set
> parameter ?
>
> -Naveen
>
> Zohair wrote:
>
>> Hi,
>
>> While getting the parameter input from user,if its a Combo Box,can we
>> retrive the items from Database.Say i want to get the details of the
>> specefic department supplied by the user as input,can Combo list be
>> dynamically generated? for example from database,so that modifications in
>> database will reflect the Combo items of Report Parameters too.
>> Is there any possibility by which we can implement this in Birt.
>
>> Anyone got this working, please help!!
>
>> Using Birt M2 build .
>> Thanks in advance
>
>
|
|
| | | | | | |
| Re: Report Parameter Combo Items [message #34545 is a reply to message #33711] |
Thu, 05 May 2005 01:34 |
| Eclipse User |
|
|
|
Originally posted by: a14342.gmail.com
Paul,
I tried binding the Dataset and report parameter. After binding, data is
not getting retrieved from database dynamically based on what user
entered. Data retreived from datbase is based on the defaul value entered
in the Data set parameter only.
I also tried not giving any value in Data set parameter default. Still
data is not getting retreived from database based on user input.
I am using Tomcat 4.1.3 and M2 build.
-Naveen
Paul Rogers wrote:
> Naveen & Zohair,
> BIRT 1.0 won't provide dynamic parameters (lists that come from the
> database), but it is proposed for a later release. The proposed design is
> described in the ROM specs in the section that describes parameters.
> Briefly, the idea is that you'll be able to declare a BIRT data set that
> provides the data, and that data set will be used to obtain the list. Does
> this feature sound like one that would solve your problem? Are there
> specific requirements you can suggest?
> In the mean time, you can create a custom parameter page using JSP or PHP.
> You can use the Java or PHP techniques for accessing the database. The
> custom parameter pages allow you to integrate these pages more closely with
> your application, then delegate to BIRT the responsibility of running the
> reports. Will this solution work for your app, or would you prefer to use
> the BIRT parameter UI?
> There was question about how to bind a report and data set parameter. See
> this page for details:
> http://www.eclipse.org/birt/index.php?page=faq/params.html
> And, see the Data Set Parameters section of this page:
> http://www.eclipse.org/birt/index.php?page=faq/data.html
> Thanks,
> - Paul
> Paul Rogers
> BIRT PMC
> "Naveen" <a14342@gmail.com> wrote in message
> news:f398b643d2202366a7426ffd66d89800$1@www.eclipse.org...
>> Zohair,
>> Just my looking at the screen, options,it doesnt look it is possible to
>> get the data from database to populate the list box..I also had a exact
>> question!!.
>> On a side note, do you know how to bind a report parameter and data set
>> parameter ?
>>
>> -Naveen
>>
>> Zohair wrote:
>>
>>> Hi,
>>
>>> While getting the parameter input from user,if its a Combo Box,can we
>>> retrive the items from Database.Say i want to get the details of the
>>> specefic department supplied by the user as input,can Combo list be
>>> dynamically generated? for example from database,so that modifications in
>>> database will reflect the Combo items of Report Parameters too.
>>> Is there any possibility by which we can implement this in Birt.
>>
>>> Anyone got this working, please help!!
>>
>>> Using Birt M2 build .
>>> Thanks in advance
>>
>>
|
|
|
| Re: Report Parameter Combo Items [message #36036 is a reply to message #34545] |
Tue, 10 May 2005 17:18 |
| Eclipse User |
|
|
|
Naveen,
Sorry for the delay in responding. The parameter value passing should work
in M2 and M3. Here are some things to try:
1. Create a data item at the top of your report to display the report
parameter value. Does it look right?
2. Double-check that the data set parameter is bound to the report parameter
in the the Binding page of the property editor for your Table or List report
item.
3. When you test your data set in the Data Set editor, does it display only
those rows that match the default value of your data set parameter? If not,
then double-check that your query has a WHERE something = ? clause.
If all else fails, please e-mail me your design file and I'll see if I can
figure out what might be wrong.
- Paul
Paul Rogers
BIRT PMC
"Naveen" <a14342@gmail.com> wrote in message
news:f7472ca2c17357cb45e7b2d2e30d6599$1@www.eclipse.org...
> Paul,
>
> I tried binding the Dataset and report parameter. After binding, data is
> not getting retrieved from database dynamically based on what user
> entered. Data retreived from datbase is based on the defaul value entered
> in the Data set parameter only.
> I also tried not giving any value in Data set parameter default. Still
> data is not getting retreived from database based on user input.
>
> I am using Tomcat 4.1.3 and M2 build.
>
> -Naveen
>
> Paul Rogers wrote:
>
>> Naveen & Zohair,
>
>> BIRT 1.0 won't provide dynamic parameters (lists that come from the
>> database), but it is proposed for a later release. The proposed design is
>> described in the ROM specs in the section that describes parameters.
>> Briefly, the idea is that you'll be able to declare a BIRT data set that
>> provides the data, and that data set will be used to obtain the list.
>> Does this feature sound like one that would solve your problem? Are there
>> specific requirements you can suggest?
>
>> In the mean time, you can create a custom parameter page using JSP or
>> PHP. You can use the Java or PHP techniques for accessing the database.
>> The custom parameter pages allow you to integrate these pages more
>> closely with your application, then delegate to BIRT the responsibility
>> of running the reports. Will this solution work for your app, or would
>> you prefer to use the BIRT parameter UI?
>
>> There was question about how to bind a report and data set parameter. See
>> this page for details:
>
>> http://www.eclipse.org/birt/index.php?page=faq/params.html
>
>> And, see the Data Set Parameters section of this page:
>
>> http://www.eclipse.org/birt/index.php?page=faq/data.html
>
>> Thanks,
>
>> - Paul
>
>> Paul Rogers
>> BIRT PMC
>
>
>> "Naveen" <a14342@gmail.com> wrote in message
>> news:f398b643d2202366a7426ffd66d89800$1@www.eclipse.org...
>>> Zohair,
>>> Just my looking at the screen, options,it doesnt look it is possible to
>>> get the data from database to populate the list box..I also had a exact
>>> question!!.
>>> On a side note, do you know how to bind a report parameter and data set
>>> parameter ?
>>>
>>> -Naveen
>>>
>>> Zohair wrote:
>>>
>>>> Hi,
>>>
>>>> While getting the parameter input from user,if its a Combo Box,can we
>>>> retrive the items from Database.Say i want to get the details of the
>>>> specefic department supplied by the user as input,can Combo list be
>>>> dynamically generated? for example from database,so that modifications
>>>> in database will reflect the Combo items of Report Parameters too.
>>>> Is there any possibility by which we can implement this in Birt.
>>>
>>>> Anyone got this working, please help!!
>>>
>>>> Using Birt M2 build .
>>>> Thanks in advance
>>>
>>>
>
>
|
|
|
Goto Forum:
Current Time: Mon Jun 02 07:13:47 EDT 2025
Powered by FUDForum. Page generated in 0.10272 seconds |
Home