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

Calculate/create Row Number without identity

How do I output a row number for a table solely for the purpose of
querying for a unique row?

In my problem, the table from a legacy system does not have a primary
key, so it limits various querying I'd like to do that identifies
uniqueness in the table.

The problem is that since I'm using DTS to simply copy the table to
SQL, I don't want to create identity rows.chrispycrunch (chrispycrunch@.gmail.com) writes:
> How do I output a row number for a table solely for the purpose of
> querying for a unique row?
> In my problem, the table from a legacy system does not have a primary
> key, so it limits various querying I'd like to do that identifies
> uniqueness in the table.
> The problem is that since I'm using DTS to simply copy the table to
> SQL, I don't want to create identity rows.

Not sure why the use of DTS would preclude the use of an IDENTITY row,
but then again I have no experience of DTS. After all, IDENTITY seems
perfect in this case.

If there really is a problem for DTS, you make a two-stepper and have
DTS to park the data in a transient table, and insert from there into
the target table.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi. Are you sure that the original table has no duplicates? If there
are any
duplicate, you do not have unique rows. However, assuming you want to
establish an identity for future use, you could extract the old data
row-by-row
and set a unique identity of your own construction, and maintain that
with
any new rows that get added (and make sure to have a unique index on
that
value.
All in all, the identity column is made for this.
Joe Weinstein at BEA

C#/SQL noob question

Using C# and ASP.NET, I need to connect to an SQL Server running Reporting Services, grab a report, supply a couple of parameters and an output format, and render a stream that I can write to a browser. Can anybody point me to an example or tutorial explaining how to do that?

thanks!

You probably want to start here:

http://msdn.microsoft.com/sql/bi/reporting/default.aspx?pull=/library/en-us/dnsql90/html/integratrsapp.asp

BURST Support

Hi,
Does anyone knows if Reporting Services support BURST execution of a Report.
That is ONE Report execution will generate SEVERAL output files (Excel for
exemple)
based on User data perimeter or rights.
Many thanks.No it does not.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Does anyone knows if Reporting Services support BURST execution of a
Report.
> That is ONE Report execution will generate SEVERAL output files (Excel for
> exemple)
> based on User data perimeter or rights.
> Many thanks.
>|||Writing a custom delivery extension is always an option :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uQQPjqNyEHA.3908@.TK2MSFTNGP12.phx.gbl...
> No it does not.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
> news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > Does anyone knows if Reporting Services support BURST execution of a
> Report.
> >
> > That is ONE Report execution will generate SEVERAL output files (Excel
for
> > exemple)
> > based on User data perimeter or rights.
> >
> > Many thanks.
> >
> >
>|||Yes it can do. But you are going to have to do a little work.
Firstly when a Report is executed all the data is collected from the data
source(s) along with the definition of the report and combined to produce an
executed representation of the report which is stored in "session" called
Intermediary Format, until you manually flush the session or until it times
out.
You can include in the URL request for a report from the Report Server the
SessionID as well as the format, or if using the SOAP interface then you can
also specify the SessionID.
What this means is that you can get several different rendering from exactly
one execution of the Report against its data sources - which means that your
Excel, PDF, HTML versions of a report can all be consistent with each
other - something which is essential in systems where the data is pretty
volatile.
We discuss SessionID in our book "The Hitchhiker's Guide to SQL Server 2000
Reporting Services"
BTW: If you were meaning to ask that by clicking on an object in the Report
Manager - can you also do a BURST - then the answer to that is also yes -
you just need to Customise the Report Manager - and we also discuss that in
the book.
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Does anyone knows if Reporting Services support BURST execution of a
> Report.
> That is ONE Report execution will generate SEVERAL output files (Excel for
> exemple)
> based on User data perimeter or rights.
> Many thanks.
>