Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data Set Refresh Output Columns
Data Set Refresh Output Columns [message #792123] Mon, 06 February 2012 11:41 Go to next message
Shane Allred is currently offline Shane Allred
Messages: 23
Registered: January 2012
Junior Member
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 Go to previous messageGo to next message
Shane Allred is currently offline Shane Allred
Messages: 23
Registered: January 2012
Junior Member
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]

Report message to a moderator

Re: Data Set Refresh Output Columns [message #792173 is a reply to message #792124] Mon, 06 February 2012 12:44 Go to previous messageGo to next message
Shane Allred is currently offline Shane Allred
Messages: 23
Registered: January 2012
Junior Member
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 Go to previous messageGo to next message
Shane Allred is currently offline Shane Allred
Messages: 23
Registered: January 2012
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.


Jason Weathersby

BIRT Exchange
Re: Data Set Refresh Out put Columns [message #793692 is a reply to message #792173] Wed, 08 February 2012 07:49 Go to previous message
Colin  is currently offline Colin
Messages: 14
Registered: September 2010
Junior Member
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:
  


Current Time: Wed Apr 16 12:08:13 EDT 2014

Powered by FUDForum. Page generated in 0.02915 seconds