Eclipse Community Forums: BIRT » Data Set Refresh Output Columns

Home » Archived » BIRT » Data Set Refresh Output Columns

Data Set Refresh Output Columns [message #792123]

Mon, 06 February 2012 11:41

Eclipse User

I made a change to some of my table schemas and for the life of me cannot figure out how to refresh the associated Data Sets. I still see the old columns in the dataset and can't seem to find an option to refresh or rebuild the output columns.

I've tried right clicking on the Data Set and selecting "Refresh" but that doesn't appear to help.

I'd rather not have to delete and recreate these data sets as I use them from a library on many reports.

Thanks

Shane

Re: Data Set Refresh Output Columns [message #792124 is a reply to message #792123]

Mon, 06 February 2012 11:43

Eclipse User

I should probably mention that the data sets in question are off of MySQL views and not actual tables.

Shane

[Updated on: Mon, 06 February 2012 11:43] by Moderator

Re: Data Set Refresh Output Columns [message #792173 is a reply to message #792124]

Mon, 06 February 2012 12:44

Eclipse User

I found one workaround.

It appears that the issue is because in my data set I use "SELECT *". I updated this to be "SELECT first_name", saved, and then changed it back to "SELECT *" and the output columns were refreshed. I'm not sure if this is the best solution, but it is the only one I have got to work (other than recreating the data set).

Thanks

Shane

Re: Data Set Refresh Output Columns [message #792230 is a reply to message #792173]

Mon, 06 February 2012 14:35

Eclipse User

I have a similar problem in the actual reports. It seems clicking "Refresh" on the data binding adds missing columns but leaves deleted and changed columns in the list, which causes an error when you run a report. I had to go into the XML and manually make the changes.

Re: Data Set Refresh Output Columns [message #792357 is a reply to message #792230]

Mon, 06 February 2012 17:56

Eclipse User

I do not think refreshing the bindings will remove a column because
technically a column in the binding can be created that gets its data
from an external source and not the data set. That said you can remove
a column by selecting the binding tab for the report item, click on the
column and click on the remove button.

Jason

On 2/6/2012 2:35 PM, Shane Allred wrote:
> I have a similar problem in the actual reports. It seems clicking
> "Refresh" on the data binding adds missing columns but leaves deleted
> and changed columns in the list, which causes an error when you run a
> report. I had to go into the XML and manually make the changes.

Re: Data Set Refresh Out put Columns [message #793692 is a reply to message #792173]

Wed, 08 February 2012 07:49

Eclipse User

Shane Allred <forums-noreply@eclipse.org> wrote:
> I found one workaround.
>
> It appears that the issue is because in my data set I use "SELECT *". I
> updated this to be "SELECT first_name", saved, and then changed it back
> to "SELECT *" and the output columns were refreshed. I'm not sure if this
> is the best solution, but it is the only one I have got to work (other
> than recreating the data set).
>
> Thanks
>
> Shane
Sorry, Shane, I have no solution.
I have dynamically created tables in my database. I easily created datasets
containing the data, but can't figure out how to dynamically create tables
containing the data. What I would like it the programmatic equivalent of
dragging and dropping the dataset into a report - which might solve your
problem too.

--
Colin Sutton

Previous Topic:	birt view localization problem
Next Topic:	1000's separator in tooltip

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 23:01:09 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter