| Need clarification on Dataset Property Binding [message #243381] |
Tue, 19 June 2007 13:52  |
Eclipse User |
|
|
|
Hi,
I'm a little confused on how the Dataset Property Binding works. The
documentation I'm finding in the help, doesn't really explain what it does.
Here is what I would like to do. I have a database with different
schemas, facility#. I have a user that has select permission on all the
different schemas, reportuser. That user is the login/password that I've
defined as my datasource.
Now I want to create a data set, and here's where my question on
Property Binding comes in. Can I use property bindings to specify a
schema name? For example:
select *
from param[facility].item
Where facility is a parameter passed in to the report. How would I
accomplish this using property bindings? Or if this isn't the best
solution, what would be the best solution.
|
|
|
| Re: Need clarification on Dataset Property Binding [message #243655 is a reply to message #243381] |
Wed, 20 June 2007 16:03  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
You should be able to do this with property binding or script.
your property binding may have to look like "select * from " +
param["facility"] + ".item"
Jason
Raishad wrote:
> Hi,
> I'm a little confused on how the Dataset Property Binding works. The
> documentation I'm finding in the help, doesn't really explain what it does.
>
> Here is what I would like to do. I have a database with different
> schemas, facility#. I have a user that has select permission on all the
> different schemas, reportuser. That user is the login/password that I've
> defined as my datasource.
> Now I want to create a data set, and here's where my question on
> Property Binding comes in. Can I use property bindings to specify a
> schema name? For example:
>
> select *
> from param[facility].item
>
> Where facility is a parameter passed in to the report. How would I
> accomplish this using property bindings? Or if this isn't the best
> solution, what would be the best solution.
|
|
|
Powered by
FUDForum. Page generated in 0.45973 seconds
Home