| How can I retrieve data? [message #848123] |
Tue, 17 April 2012 20:35  |
Eclipse User |
|
|
|
I have a database table that contains the names of other, dynamically
created, database tables. I can retrieve that data and from it compose a
query. I tried to use the composed query in a subreport table, but cannot
see how to pass it to the beforeopen of the dataset. The subreport example
shows how to pass a parameter of a where clause, but I need to pass the
whole query. How can that be done?
--
Colin
|
|
|
|
|
| Re: How can I retrieve data? [message #850436 is a reply to message #849589] |
Thu, 19 April 2012 23:17  |
| Eclipse User |
|
|
|
Colin,
Look at the attached example and give it a try. It may cache the
dataset defeating your purpose but it may be worth a try. Look at the
outer table oncreate on the detail row and the beforeOpen script on the
inner data set.
Jason
On 4/19/2012 5:15 AM, Colin wrote:
> I retrieve one column, converting it to a string in the query and renaming
> it to one name using sql 'as'
>
> Jason Weathersby<jasonweathersby@xxxxxxxx> wrote:
>> Does the query change, change the column definitions? Ie are you just
>> changing the table name and not the column names and column types in the sub report?
>>
>> Jason
>>
>> On 4/17/2012 8:35 PM, Colin wrote:
>>> I have a database table that contains the names of other, dynamically
>>> created, database tables. I can retrieve that data and from it compose a
>>> query. I tried to use the composed query in a subreport table, but cannot
>>> see how to pass it to the beforeopen of the dataset. The subreport example
>>> shows how to pass a parameter of a where clause, but I need to pass the
>>> whole query. How can that be done?
>>>
>
>
|
|
|
| Re: How can I retrieve data? [message #851345 is a reply to message #850436] |
Fri, 20 April 2012 18:28 |
| Eclipse User |
|
|
|
Thanks, Jason, that showed me exactly what I needed..
--
Colin
Jason Weathersby <jasonweathersby@xxxxxxxx> wrote:
> Colin,
>
> Look at the attached example and give it a try. It may cache the
> dataset defeating your purpose but it may be worth a try. Look at the
> outer table oncreate on the detail row and the beforeOpen script on the inner data set.
>
> Jason
>
> On 4/19/2012 5:15 AM, Colin wrote:
> I retrieve one column, converting it to a string in the query and
> renaming it to one name using sql 'as'
>
> Jason Weathersby<jasonweathersby@xxxxxxxx> wrote:
> Does the query change, change the column definitions? Ie are you just
> changing the table name and not the column names and column types in the sub report?
>
> Jason
>
> On 4/17/2012 8:35 PM, Colin wrote:
> I have a database table that contains the names of other, dynamically
> created, database tables. I can retrieve that data and from it compose a
> query. I tried to use the composed query in a subreport table, but cannot
> see how to pass it to the beforeopen of the dataset. The subreport
> example shows how to pass a parameter of a where clause, but I need to
> pass the whole query. How can that be done?
|
|
|
Powered by
FUDForum. Page generated in 0.07411 seconds
Home