Hello, I need some help with the generation of formulas when rendering to Excel.
Let's take a small table to explain the problem, with the columns quantity, price per article and total price. The last column is a calculated column which could look like:
=ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
So far no problems, this works fine and generates a correct formula in Excel. However, I also need a total value in the table footer, which gives me the total quantity and the total overall price. The values in the footer also need to be implemented as formulas, since the end user needs to get an Excel file which enables him to see the effects of changing the quantity and price per article.
How do I get this to work? On a table row basis this seems to work fine, but in the table footer there is no way that I can reference the calculated fields from the table row. I get a message that says that I can only reference report items inside the same grouping scope...
Any help is welcome, since this looks like a basic functionality that is either missing or needs to be implemented in a way that I haven't discovered yet.
Thanks,
VincentAggregate formulas are not currently implemented in the Excel renderer.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Vincent" <Vincent@.discussions.microsoft.com> wrote in message
news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> Hello, I need some help with the generation of formulas when rendering to
Excel.
> Let's take a small table to explain the problem, with the columns
quantity, price per article and total price. The last column is a calculated
column which could look like:
> =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> So far no problems, this works fine and generates a correct formula in
Excel. However, I also need a total value in the table footer, which gives
me the total quantity and the total overall price. The values in the footer
also need to be implemented as formulas, since the end user needs to get an
Excel file which enables him to see the effects of changing the quantity and
price per article.
> How do I get this to work? On a table row basis this seems to work fine,
but in the table footer there is no way that I can reference the calculated
fields from the table row. I get a message that says that I can only
reference report items inside the same grouping scope...
> Any help is welcome, since this looks like a basic functionality that is
either missing or needs to be implemented in a way that I haven't discovered
yet.
> Thanks,
> Vincent
>|||Is this planned for the next release or update (SP2)?
"Chris Hays [MSFT]" wrote:
> Aggregate formulas are not currently implemented in the Excel renderer.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Vincent" <Vincent@.discussions.microsoft.com> wrote in message
> news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> > Hello, I need some help with the generation of formulas when rendering to
> Excel.
> >
> > Let's take a small table to explain the problem, with the columns
> quantity, price per article and total price. The last column is a calculated
> column which could look like:
> > =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> >
> > So far no problems, this works fine and generates a correct formula in
> Excel. However, I also need a total value in the table footer, which gives
> me the total quantity and the total overall price. The values in the footer
> also need to be implemented as formulas, since the end user needs to get an
> Excel file which enables him to see the effects of changing the quantity and
> price per article.
> >
> > How do I get this to work? On a table row basis this seems to work fine,
> but in the table footer there is no way that I can reference the calculated
> fields from the table row. I get a message that says that I can only
> reference report items inside the same grouping scope...
> >
> > Any help is welcome, since this looks like a basic functionality that is
> either missing or needs to be implemented in a way that I haven't discovered
> yet.
> >
> > Thanks,
> > Vincent
> >
>
>|||No. It is on our wishlist for some future version, but there are no
immediate plans to implement it.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Vincent" <Vincent@.discussions.microsoft.com> wrote in message
news:4C49ABA5-825A-4758-AE88-5A00CD828D73@.microsoft.com...
> Is this planned for the next release or update (SP2)?
>
> "Chris Hays [MSFT]" wrote:
> > Aggregate formulas are not currently implemented in the Excel renderer.
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach of
> > children under 3.
> > "Vincent" <Vincent@.discussions.microsoft.com> wrote in message
> > news:2B8C24ED-0506-4297-9EBC-9DB8C43616B6@.microsoft.com...
> > > Hello, I need some help with the generation of formulas when rendering
to
> > Excel.
> > >
> > > Let's take a small table to explain the problem, with the columns
> > quantity, price per article and total price. The last column is a
calculated
> > column which could look like:
> > > =ReportItems!tbQuantity.value * ReportItems!tbPricePerArticle.value
> > >
> > > So far no problems, this works fine and generates a correct formula in
> > Excel. However, I also need a total value in the table footer, which
gives
> > me the total quantity and the total overall price. The values in the
footer
> > also need to be implemented as formulas, since the end user needs to get
an
> > Excel file which enables him to see the effects of changing the quantity
and
> > price per article.
> > >
> > > How do I get this to work? On a table row basis this seems to work
fine,
> > but in the table footer there is no way that I can reference the
calculated
> > fields from the table row. I get a message that says that I can only
> > reference report items inside the same grouping scope...
> > >
> > > Any help is welcome, since this looks like a basic functionality that
is
> > either missing or needs to be implemented in a way that I haven't
discovered
> > yet.
> > >
> > > Thanks,
> > > Vincent
> > >
> >
> >
> >
No comments:
Post a Comment