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 16:41 Go to next message
Shane Allred is currently offline Shane AllredFriend
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 16:43 Go to previous messageGo to next message
Shane Allred is currently offline Shane AllredFriend
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 16:43]

Report message to a moderator

Re: Data Set Refresh Output Columns [message #792173 is a reply to message #792124] Mon, 06 February 2012 17:44 Go to previous messageGo to next message
Shane Allred is currently offline Shane AllredFriend
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 19:35 Go to previous messageGo to next message
Shane Allred is currently offline Shane AllredFriend
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 22:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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.
Re: Data Set Refresh Out put Columns [message #793692 is a reply to message #792173] Wed, 08 February 2012 12:49 Go to previous message
Colin  is currently offline Colin Friend
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: Thu Nov 27 14:38:21 GMT 2014

Powered by FUDForum. Page generated in 0.02333 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software