|
Re: Adding dynamic columns to an OdaDataSet [message #748427 is a reply to message #743873] |
Mon, 24 October 2011 17:19 |
|
See the attached example to see how to add the column bindings.
Jason
On 10/21/2011 3:55 PM, mcastoe wrote:
> We have a report that is going to essentially produces a crosstab like
> result. The BIRT crossTab element has some limitations that the customer
> can't abide so we are trying to get a report where the output table and
> the underlying OdaDataSet are extended dynamically based on a set of
> input parameters. The output table bit works perfectly thanks to the
> many helpful examples. What I've not been able to do is to get the table
> data bindings to work. I add the data binding in the beforeFactory
> event. In the beforeOpen on the dataset, I add columnHints for each new
> column and I try to add the resultSet columns but the resultSet is null.
> Any hints or examples of how to go about this? I've tried adding a
> computedColumn to the dataset but the report errors out saying it has an
> invalid column binding.
>
>
|
|
|
|
Re: Adding dynamic columns to an OdaDataSet [message #753770 is a reply to message #753749] |
Fri, 28 October 2011 16:50 |
|
See attached example for jdbc dataset. Notice report already defines
jdbc data source.
Jason
On 10/28/2011 10:56 AM, mcastoe wrote:
> Hi Jason,
>
> thank you for your reply. I am using an ODADataSet rather than the
> scripted data set and I get dependency cycle errors in the dataset at
> runtime. It is looking like the issue is that the ODADataSet simply will
> not allow dynamic modification of the columns it provides at runtime. I
> may have to switch to a scripted dataset as you are using in your
> example. the problem is that I am not sure how to make the JDBC calls
> from the dataset. I suppose it would be something like opening the jdbc
> resultset in the dataset open event and then iterating the resultSet in
> the onFetch.
-
Attachment: NewTable.zip
(Size: 1.61KB, Downloaded 749 times)
|
|
|
|
Powered by
FUDForum. Page generated in 0.03837 seconds