Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Create new report based on existing one
Create new report based on existing one [message #716762] Thu, 18 August 2011 11:27 Go to next message
Sapphie Missing name is currently offline Sapphie Missing nameFriend
Messages: 21
Registered: October 2010
Junior Member
I am often in the position where I have designed a report returning data for certain fields from my database. Then I need an identical report based on a different field.

I usually create crosstab reports. For example if my report returns a count of the number of Widgets created per month for a given year.

Now I want exactly the same report but counting say those manufactured by Company A.

So all I am doing is changing one field name in my query but if I just take a copy of the first report it refers to data bindings etc for that and I end up deleting the crosstab and data cube and starting again!

There must be an easier way?

Lee
Re: Create new report based on existing one [message #716818 is a reply to message #716762] Thu, 18 August 2011 14:13 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You can refresh the bindings using the binding tab, but you will still
have to update the references to old column names. Another approach is
when you change the base query is to select the output columns and enter
an alias that matches the old binding name.

Jason

On 8/18/2011 7:27 AM, Sapphie wrote:
> I am often in the position where I have designed a report returning data
> for certain fields from my database. Then I need an identical report
> based on a different field.
>
> I usually create crosstab reports. For example if my report returns a
> count of the number of Widgets created per month for a given year.
>
> Now I want exactly the same report but counting say those manufactured
> by Company A.
>
> So all I am doing is changing one field name in my query but if I just
> take a copy of the first report it refers to data bindings etc for that
> and I end up deleting the crosstab and data cube and starting again!
>
> There must be an easier way?
>
> Lee
Re: Create new report based on existing one [message #716821 is a reply to message #716762] Thu, 18 August 2011 14:13 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You can refresh the bindings using the binding tab, but you will still
have to update the references to old column names. Another approach is
when you change the base query is to select the output columns and enter
an alias that matches the old binding name.

Jason

On 8/18/2011 7:27 AM, Sapphie wrote:
> I am often in the position where I have designed a report returning data
> for certain fields from my database. Then I need an identical report
> based on a different field.
>
> I usually create crosstab reports. For example if my report returns a
> count of the number of Widgets created per month for a given year.
>
> Now I want exactly the same report but counting say those manufactured
> by Company A.
>
> So all I am doing is changing one field name in my query but if I just
> take a copy of the first report it refers to data bindings etc for that
> and I end up deleting the crosstab and data cube and starting again!
>
> There must be an easier way?
>
> Lee
Previous Topic:Combo missing, dynamic list box is empty
Next Topic:BIRT_VIEWER_WORKING_FOLDER root linux and windows
Goto Forum:
  


Current Time: Tue Apr 23 12:03:35 GMT 2024

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

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

Back to the top