Calculated cells in Excel?

Hi,
We're evaluating Reporting Services for a client. I like the functionality,
but it's unclear whether we can manipulate Excel output. For example, our
client will want to generate or populate a spreadsheet that has multiple
worksheets, with calculated values that pull values from one or more of
those sheets.
Does RS support this level of complexity?
Thanks in advance,
Ian LurieI don't know about creating calculated fields, but you can put tables
onto different sheets by setting the page break after table property
to true. The only reporting product I have seen that allows you to
export formulas is actuate. Should you find a way to do it with
reporting services, *please* let me know! We are interested in it
too-
Thanks,
John Hennesey
johnhennesey82@.hotmail.com
"Ian Lurie" <ian@.portentinteractive.com> wrote in message news:<#eXuLqRXEHA.1356@.TK2MSFTNGP09.phx.gbl>...
> Hi,
> We're evaluating Reporting Services for a client. I like the functionality,
> but it's unclear whether we can manipulate Excel output. For example, our
> client will want to generate or populate a spreadsheet that has multiple
> worksheets, with calculated values that pull values from one or more of
> those sheets.
> Does RS support this level of complexity?
> Thanks in advance,
> Ian Lurie|||We export formulas as along as they contain only report item references.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Hennesey" <johnhennesey82@.hotmail.com> wrote in message
news:9f049b3b.0406281103.54baf474@.posting.google.com...
> I don't know about creating calculated fields, but you can put tables
> onto different sheets by setting the page break after table property
> to true. The only reporting product I have seen that allows you to
> export formulas is actuate. Should you find a way to do it with
> reporting services, *please* let me know! We are interested in it
> too-
> Thanks,
> John Hennesey
> johnhennesey82@.hotmail.com
> "Ian Lurie" <ian@.portentinteractive.com> wrote in message
news:<#eXuLqRXEHA.1356@.TK2MSFTNGP09.phx.gbl>...
> > Hi,
> >
> > We're evaluating Reporting Services for a client. I like the
functionality,
> > but it's unclear whether we can manipulate Excel output. For example,
our
> > client will want to generate or populate a spreadsheet that has multiple
> > worksheets, with calculated values that pull values from one or more of
> > those sheets.
> >
> > Does RS support this level of complexity?
> >
> > Thanks in advance,
> >
> > Ian Luriesql