Home » Archived » BIRT » Parameters
| Parameters [message #30347] |
Fri, 22 April 2005 10:48  |
Eclipse User |
|
|
|
Originally posted by: dsdas.yahoo.com
Please, can someone tell me how I must work with parameters in BIRT???
|
|
|
| Re: Parameters [message #30665 is a reply to message #30347] |
Fri, 22 April 2005 20:50  |
| Eclipse User |
|
|
|
Daniel,
BIRT provides two kinds of parameters: report parameters and data set
parameters.
Report parameters give your user a way to pass data into your report. For
example, if your report shows customer info, you may create a report
parameter to accept the customer number. To create a report parameter, go
into the Data Explorer, and the Parameters node. Use the context menu to add
a new parameter.
Now, there are some glitches with parameters. Unless you make the parameter
required, and with no default value, the parameter won't appear when you
preview. Also, within a BIRT session, the UI prompts for your parameter
values only once -- you can't go back and change the value without
restarting BIRT. This is a known issue, but may cause a bit of confusion.
Data set parameters pass data into or out of a data set (query.) In M2, only
input parameters are available. To create a data set parameter:
1. Add a ? to your SQL statement: SELECT * FROM customers WHERE custID = ?
2. Add a parameter in the parameter page of the data set editor. Be sure to
set the "Is Input" option to true.
3. Provide a default value. (If you don't, the data set editor will display
lots of error dialogs. Another known problems that can be confusing.)
4. Test the data set. You should see only those rows that match your default
value.
Finally, if you want the report parameter to provide data for your data set
parameter, you need to bind them together. The natural place to do so is in
the data set parameter page. However, that does not work in M2. (Yet another
known problem that causes confusion.)
Instead, create a table or list for your data set. In the Binding tab, bind
your data set parameter to your report parameter. Use the syntax
params.paramName to access the report parameter.
That's the quick overview. Let me know if there are specific areas where
you'd like more detail.
- Paul
Paul Rogers
BIRT PMC
"Daniel" <dsdas@yahoo.com> wrote in message
news:d4b2qr$gmb$1@news.eclipse.org...
> Please, can someone tell me how I must work with parameters in BIRT???
>
>
|
|
|
| Re: Parameters [message #33435 is a reply to message #30665] |
Tue, 03 May 2005 10:30 |
| Eclipse User |
|
|
|
Originally posted by: a14342.gmail.com
Paul,
Need more info on how to bind the report parameter to dataset parameter
in M2 build ?.
-Naveen
Paul Rogers wrote:
> Daniel,
> BIRT provides two kinds of parameters: report parameters and data set
> parameters.
> Report parameters give your user a way to pass data into your report. For
> example, if your report shows customer info, you may create a report
> parameter to accept the customer number. To create a report parameter, go
> into the Data Explorer, and the Parameters node. Use the context menu to add
> a new parameter.
> Now, there are some glitches with parameters. Unless you make the parameter
> required, and with no default value, the parameter won't appear when you
> preview. Also, within a BIRT session, the UI prompts for your parameter
> values only once -- you can't go back and change the value without
> restarting BIRT. This is a known issue, but may cause a bit of confusion.
> Data set parameters pass data into or out of a data set (query.) In M2, only
> input parameters are available. To create a data set parameter:
> 1. Add a ? to your SQL statement: SELECT * FROM customers WHERE custID = ?
> 2. Add a parameter in the parameter page of the data set editor. Be sure to
> set the "Is Input" option to true.
> 3. Provide a default value. (If you don't, the data set editor will display
> lots of error dialogs. Another known problems that can be confusing.)
> 4. Test the data set. You should see only those rows that match your default
> value.
> Finally, if you want the report parameter to provide data for your data set
> parameter, you need to bind them together. The natural place to do so is in
> the data set parameter page. However, that does not work in M2. (Yet another
> known problem that causes confusion.)
> Instead, create a table or list for your data set. In the Binding tab, bind
> your data set parameter to your report parameter. Use the syntax
> params.paramName to access the report parameter.
> That's the quick overview. Let me know if there are specific areas where
> you'd like more detail.
> - Paul
> Paul Rogers
> BIRT PMC
> "Daniel" <dsdas@yahoo.com> wrote in message
> news:d4b2qr$gmb$1@news.eclipse.org...
>> Please, can someone tell me how I must work with parameters in BIRT???
>>
>>
|
|
|
| Re: Parameters [message #33745 is a reply to message #33435] |
Tue, 03 May 2005 17:12 |
| Eclipse User |
|
|
|
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
If the information in these pages does not answer your questions (or is
incomplete), let me know and I'll try to fill in the gaps.
Thanks,
- Paul
Paul Rogers
BIRT PMC
"Naveen" <a14342@gmail.com> wrote in message
news:ce6b8a960558e535b6a8286ab0094f05$1@www.eclipse.org...
> Paul,
> Need more info on how to bind the report parameter to dataset parameter in
> M2 build ?.
> -Naveen
>
> Paul Rogers wrote:
>
>> Daniel,
>
>> BIRT provides two kinds of parameters: report parameters and data set
>> parameters.
>
>> Report parameters give your user a way to pass data into your report. For
>> example, if your report shows customer info, you may create a report
>> parameter to accept the customer number. To create a report parameter, go
>> into the Data Explorer, and the Parameters node. Use the context menu to
>> add a new parameter.
>
>> Now, there are some glitches with parameters. Unless you make the
>> parameter required, and with no default value, the parameter won't appear
>> when you preview. Also, within a BIRT session, the UI prompts for your
>> parameter values only once -- you can't go back and change the value
>> without restarting BIRT. This is a known issue, but may cause a bit of
>> confusion.
>
>> Data set parameters pass data into or out of a data set (query.) In M2,
>> only input parameters are available. To create a data set parameter:
>
>> 1. Add a ? to your SQL statement: SELECT * FROM customers WHERE custID =
>> ?
>> 2. Add a parameter in the parameter page of the data set editor. Be sure
>> to set the "Is Input" option to true.
>> 3. Provide a default value. (If you don't, the data set editor will
>> display lots of error dialogs. Another known problems that can be
>> confusing.)
>> 4. Test the data set. You should see only those rows that match your
>> default value.
>
>> Finally, if you want the report parameter to provide data for your data
>> set parameter, you need to bind them together. The natural place to do so
>> is in the data set parameter page. However, that does not work in M2.
>> (Yet another known problem that causes confusion.)
>
>> Instead, create a table or list for your data set. In the Binding tab,
>> bind your data set parameter to your report parameter. Use the syntax
>> params.paramName to access the report parameter.
>
>> That's the quick overview. Let me know if there are specific areas where
>> you'd like more detail.
>
>> - Paul
>
>> Paul Rogers
>> BIRT PMC
>
>> "Daniel" <dsdas@yahoo.com> wrote in message
>> news:d4b2qr$gmb$1@news.eclipse.org...
>>> Please, can someone tell me how I must work with parameters in BIRT???
>>>
>>>
>
>
|
|
|
Goto Forum:
Current Time: Mon Apr 28 03:06:29 EDT 2025
Powered by FUDForum. Page generated in 0.03889 seconds |
Home