Eclipse Community Forums: BIRT » Data Set Refresh Output Columns

Help

Home

Home » Archived » BIRT » Data Set Refresh Output Columns

Show: Today's Messages :: Show Polls :: Message Navigator

Data Set Refresh Output Columns [message #792123]

Mon, 06 February 2012 16:41

Shane Allred

Messages: 24
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

Report message to a moderator

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

Mon, 06 February 2012 16:43

Shane Allred

Messages: 24
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

Shane Allred

Messages: 24
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

Report message to a moderator

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

Mon, 06 February 2012 19:35

Shane Allred

Messages: 24
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.

Report message to a moderator

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

Mon, 06 February 2012 22:56

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.

Report message to a moderator

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

Wed, 08 February 2012 12:49

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 11:52:18 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter