|
Re: Removing unused data column bindings from XML source. [message #504415 is a reply to message #504374] |
Fri, 18 December 2009 18:42 |
|
Jan,
On the binding tab for the table there is a refresh button which should
remove those. You can also just use the xml view and delete all the
designer values for runtime.
Jason
Jan Kohnert wrote:
> Hello,
>
> I'm trying to use BIRT within an dynamic product environment. This
> means, that certain database table columns will be removed over time.
> This leads into unrunable BIRT reports throwing exceptions like this:
> "Column binding "FACHRalt" has referred to a data set column "FACHRalt"
> which does not exist."
>
> The column FACHRalt is unused in the report design and only referenced
> in the <structure name="cachedMetaData">, <list-property
> name="resultSet"> and <list-property name="boundDataColumns"> entries in
> the report designs XML source.
>
> Is there a way to disable the data column binding caching, or is it
> possible that only the used (displayed or otherwise used) entries are
> getting stored?
>
> This behavior is exactly the reason why we never used MS Crystal Report
> what has similar problems. I hop that there is a way to ship around this
> problems, because otherwise BIRT wouldn't be usable for me :(
>
> Thanks,
> Jan
>
|
|
|
|
|
Re: Removing unused data column bindings from XML source. [message #504825 is a reply to message #504810] |
Tue, 22 December 2009 20:28 |
|
The issue is that although a databound item such as a table has to be
bound to a dataset not all columns must come from a dataset, so the
refresh does not remove bindings, because you may actually have a
binding that references an external Java class or script to calc a
value. If refreshing removed bindings this could cause an issue. These
bindings also might be used in external event handler classes as well
as expressions. Maybe we can look at offering a popup box to remove all
bindings that are not found in the report. This bug shows how the
button came to be:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=167115
Add comments for new suggestions to this bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=287822
I will bring this up with the PMC
Jason
Andreas Paul-Marcuse wrote:
> Jason,
> Refresh button doesn't work as expected. Removed columns remain at the
> DataSet and also at the XML source.
> To edit the xml view is a bit inconvenient in an professional environment.
>
> We use StoredProcedures instead of SelectStatements. Could it be, the
> Refresh doesn't support StoredProcedures ?
>
> - paul
>
|
|
|
Powered by
FUDForum. Page generated in 0.03421 seconds