|
Re: Create new report based on existing one [message #716818 is a reply to message #716762] |
Thu, 18 August 2011 14:13 |
|
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 |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.03828 seconds