Reporting Services and Excel interoperability

Dear friends

I am using SQL Server 2000 reporting services.
But my customer does not like the output reports
He just want to his reports look like Excel 2007 output format or a third party tool Crystal Xcelsius Designer output format.
I am deploying the reports to a Share Point Server.
How can make dynamic reports that he like to see with/without using Excel 2007 or a third party tool.

Thanks OZ

Reporting Services strives to mimic the layout of the report in the Excel export. This means that it tries to attach report items to cells on the Excel sheet, and to do this accurately with the positions of objects appropriate to each other it has to create merge cells, which can cause problems when trying to manipulate the output from Excel. In addition, Excel features and RS features do not always map well, which sometimes results in reports that don't work in Excel the way the user intended them to.

We are aware of these issues and the problems it causes; we are looking at ways to improve the Excel export in future releases.

In the meantime, the best suggestion I have for you is to take a look at SoftArtisans OfficeWriter. It will allow you to design a report in Excel and maintain all of the Excel features in the output report, while allowing you to leverage Reporting Services for data, security, scheduling, management, etc. It works on the Excel 97-2003 formats, which can be read by Excel 2007.sql

Reporting Services and Excel interoperability

Dear friends

I am using SQL Server 2000 reporting services.
But my customer does not like the output reports
He just want to his reports look like Excel 2007 output format or a third party tool Crystal Xcelsius Designer output format.
I am deploying the reports to a Share Point Server.
How can make dynamic reports that he like to see with/without using Excel 2007 or a third party tool.

Thanks OZ

Reporting Services strives to mimic the layout of the report in the Excel export. This means that it tries to attach report items to cells on the Excel sheet, and to do this accurately with the positions of objects appropriate to each other it has to create merge cells, which can cause problems when trying to manipulate the output from Excel. In addition, Excel features and RS features do not always map well, which sometimes results in reports that don't work in Excel the way the user intended them to.

We are aware of these issues and the problems it causes; we are looking at ways to improve the Excel export in future releases.

In the meantime, the best suggestion I have for you is to take a look at SoftArtisans OfficeWriter. It will allow you to design a report in Excel and maintain all of the Excel features in the output report, while allowing you to leverage Reporting Services for data, security, scheduling, management, etc. It works on the Excel 97-2003 formats, which can be read by Excel 2007.

Reporting Services and Excel

Can someone please help me. My first posting for this question went
unanswered. Here goes...I'm trying to create a report in reporting services.
The end result will be a subscription that creates an Excel file with
contains multiple sheets (Tabs). Each sheet should corresponds to a different
query or subreport. All the sheets will be derived from the same data source
and all the sheets except for one have the same column headers. Can someone
tell me how I would set this up in reporting services? I have been able to
create several reports and deployed them individual. The result is a
subscription for each report, and several individual Excel files with one
sheet. Thanks!!
I did something similar with one of our reports. I created each individual
report. I then created one report with the subreports. I put each
subreport within a rectangle and I gave each subreport a different name
(right-click on the subreport | properties | general tab | name). I have
page breaks after each rectangle, and each subreport shows up on a different
tab.
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:49D866DD-D778-458B-BE8B-FF5268B96280@.microsoft.com...
> Can someone please help me. My first posting for this question went
> unanswered. Here goes...I'm trying to create a report in reporting
services.
> The end result will be a subscription that creates an Excel file with
> contains multiple sheets (Tabs). Each sheet should corresponds to a
different
> query or subreport. All the sheets will be derived from the same data
source
> and all the sheets except for one have the same column headers. Can
someone
> tell me how I would set this up in reporting services? I have been able
to
> create several reports and deployed them individual. The result is a
> subscription for each report, and several individual Excel files with one
> sheet. Thanks!!
|||Thank You Keith. Your suggestions worked perfectly after several hours of
tweeking. I'm hoping you can help me customize it even further. Since each
subreport is a Tab or sheet in Excel, I need to pass the name of the
subreport to Excel so that the tabs or subreport assume the subreport name.
Currently each tab is named the default (Sheet1, Sheet2, etc.). Is this
possible? Also, once the report is deployed, I would like to set up a
subscription. Can you assign a certain filename that you want the
subscription to save the file as or does it assign it the name of the
project? Thanks!!
"Keith Kratochvil" wrote:

> I did something similar with one of our reports. I created each individual
> report. I then created one report with the subreports. I put each
> subreport within a rectangle and I gave each subreport a different name
> (right-click on the subreport | properties | general tab | name). I have
> page breaks after each rectangle, and each subreport shows up on a different
> tab.
> --
> Keith
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:49D866DD-D778-458B-BE8B-FF5268B96280@.microsoft.com...
> services.
> different
> source
> someone
> to
>
|||Unfortunately it is not possible to controle the naming of the tabs. It is
possible to create a document map (the first worksheeet contains named links
to each tab). This is the only option for now. I had a disucssion with an
individual from Microsoft on this issue and I believe they are looking into
it. There is no official timeline for the enhancement. There is no
guarantee that they will put it in, but I am hoping that it will make it
into the product eventually.
Regarding the name of the file, yes you can specify the name of the file and
the path when setting up the subscription.
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:31E014F7-F155-433F-AEE3-A38C5C817A0E@.microsoft.com...
> Thank You Keith. Your suggestions worked perfectly after several hours of
> tweeking. I'm hoping you can help me customize it even further. Since each
> subreport is a Tab or sheet in Excel, I need to pass the name of the
> subreport to Excel so that the tabs or subreport assume the subreport
name.[vbcol=seagreen]
> Currently each tab is named the default (Sheet1, Sheet2, etc.). Is this
> possible? Also, once the report is deployed, I would like to set up a
> subscription. Can you assign a certain filename that you want the
> subscription to save the file as or does it assign it the name of the
> project? Thanks!!
> "Keith Kratochvil" wrote:
individual[vbcol=seagreen]
have[vbcol=seagreen]
different[vbcol=seagreen]
able[vbcol=seagreen]
one[vbcol=seagreen]
|||Once again Keith, your advised has helped me tremendously, Thanks!!..In terms
of the name of the file, I noticed that you can specify a filename if you are
saving the report to a fileshare directory but you cannot specify a filename
if you are sending the report via the report server email delivery in report
manager. Is there a way around that? My report will be emailed to several
customers and I would like to specify different filenames for each
customer/report based on inidividual subscriptions for each customer.
"Keith Kratochvil" wrote:

> Unfortunately it is not possible to controle the naming of the tabs. It is
> possible to create a document map (the first worksheeet contains named links
> to each tab). This is the only option for now. I had a disucssion with an
> individual from Microsoft on this issue and I believe they are looking into
> it. There is no official timeline for the enhancement. There is no
> guarantee that they will put it in, but I am hoping that it will make it
> into the product eventually.
> Regarding the name of the file, yes you can specify the name of the file and
> the path when setting up the subscription.
> --
> Keith
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:31E014F7-F155-433F-AEE3-A38C5C817A0E@.microsoft.com...
> name.
> individual
> have
> different
> able
> one
>
|||I am glad to hear that the suggestion was helpful!
Hmmm, I don't know if it is possible. Perhaps someone from Microsoft will
chime in with an answer.
In the mean time, send your request to sqlwish@.microsoft.com
They might not respond to your email, but they do read them!
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:CDBABC21-8E21-4F85-8DC5-2ABCE1FE9DA1@.microsoft.com...
> Once again Keith, your advised has helped me tremendously, Thanks!!..In
terms
> of the name of the file, I noticed that you can specify a filename if you
are
> saving the report to a fileshare directory but you cannot specify a
filename
> if you are sending the report via the report server email delivery in
report[vbcol=seagreen]
> manager. Is there a way around that? My report will be emailed to several
> customers and I would like to specify different filenames for each
> customer/report based on inidividual subscriptions for each customer.
> "Keith Kratochvil" wrote:
is[vbcol=seagreen]
links[vbcol=seagreen]
an[vbcol=seagreen]
into[vbcol=seagreen]
and[vbcol=seagreen]
of[vbcol=seagreen]
each[vbcol=seagreen]
this[vbcol=seagreen]
name[vbcol=seagreen]
went[vbcol=seagreen]
with[vbcol=seagreen]
a[vbcol=seagreen]
data[vbcol=seagreen]
Can[vbcol=seagreen]
been[vbcol=seagreen]
a[vbcol=seagreen]
with[vbcol=seagreen]

Reporting Services and Excel

Can someone please help me. My first posting for this question went
unanswered. Here goes...I'm trying to create a report in reporting services.
The end result will be a subscription that creates an Excel file with
contains multiple sheets (Tabs). Each sheet should corresponds to a differen
t
query or subreport. All the sheets will be derived from the same data source
and all the sheets except for one have the same column headers. Can someone
tell me how I would set this up in reporting services? I have been able to
create several reports and deployed them individual. The result is a
subscription for each report, and several individual Excel files with one
sheet. Thanks!!I did something similar with one of our reports. I created each individual
report. I then created one report with the subreports. I put each
subreport within a rectangle and I gave each subreport a different name
(right-click on the subreport | properties | general tab | name). I have
page breaks after each rectangle, and each subreport shows up on a different
tab.
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:49D866DD-D778-458B-BE8B-FF5268B96280@.microsoft.com...
> Can someone please help me. My first posting for this question went
> unanswered. Here goes...I'm trying to create a report in reporting
services.
> The end result will be a subscription that creates an Excel file with
> contains multiple sheets (Tabs). Each sheet should corresponds to a
different
> query or subreport. All the sheets will be derived from the same data
source
> and all the sheets except for one have the same column headers. Can
someone
> tell me how I would set this up in reporting services? I have been able
to
> create several reports and deployed them individual. The result is a
> subscription for each report, and several individual Excel files with one
> sheet. Thanks!!|||Thank You Keith. Your suggestions worked perfectly after several hours of
tweeking. I'm hoping you can help me customize it even further. Since each
subreport is a Tab or sheet in Excel, I need to pass the name of the
subreport to Excel so that the tabs or subreport assume the subreport name.
Currently each tab is named the default (Sheet1, Sheet2, etc.). Is this
possible? Also, once the report is deployed, I would like to set up a
subscription. Can you assign a certain filename that you want the
subscription to save the file as or does it assign it the name of the
project' Thanks!!
"Keith Kratochvil" wrote:

> I did something similar with one of our reports. I created each individua
l
> report. I then created one report with the subreports. I put each
> subreport within a rectangle and I gave each subreport a different name
> (right-click on the subreport | properties | general tab | name). I have
> page breaks after each rectangle, and each subreport shows up on a differe
nt
> tab.
> --
> Keith
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:49D866DD-D778-458B-BE8B-FF5268B96280@.microsoft.com...
> services.
> different
> source
> someone
> to
>|||Unfortunately it is not possible to controle the naming of the tabs. It is
possible to create a document map (the first worksheeet contains named links
to each tab). This is the only option for now. I had a disucssion with an
individual from Microsoft on this issue and I believe they are looking into
it. There is no official timeline for the enhancement. There is no
guarantee that they will put it in, but I am hoping that it will make it
into the product eventually.
Regarding the name of the file, yes you can specify the name of the file and
the path when setting up the subscription.
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:31E014F7-F155-433F-AEE3-A38C5C817A0E@.microsoft.com...
> Thank You Keith. Your suggestions worked perfectly after several hours of
> tweeking. I'm hoping you can help me customize it even further. Since each
> subreport is a Tab or sheet in Excel, I need to pass the name of the
> subreport to Excel so that the tabs or subreport assume the subreport
name.[vbcol=seagreen]
> Currently each tab is named the default (Sheet1, Sheet2, etc.). Is this
> possible? Also, once the report is deployed, I would like to set up a
> subscription. Can you assign a certain filename that you want the
> subscription to save the file as or does it assign it the name of the
> project' Thanks!!
> "Keith Kratochvil" wrote:
>
individual[vbcol=seagreen]
have[vbcol=seagreen]
different[vbcol=seagreen]
able[vbcol=seagreen]
one[vbcol=seagreen]|||Once again Keith, your advised has helped me tremendously, Thanks!!..In term
s
of the name of the file, I noticed that you can specify a filename if you ar
e
saving the report to a fileshare directory but you cannot specify a filename
if you are sending the report via the report server email delivery in report
manager. Is there a way around that' My report will be emailed to several
customers and I would like to specify different filenames for each
customer/report based on inidividual subscriptions for each customer.
"Keith Kratochvil" wrote:

> Unfortunately it is not possible to controle the naming of the tabs. It i
s
> possible to create a document map (the first worksheeet contains named lin
ks
> to each tab). This is the only option for now. I had a disucssion with a
n
> individual from Microsoft on this issue and I believe they are looking int
o
> it. There is no official timeline for the enhancement. There is no
> guarantee that they will put it in, but I am hoping that it will make it
> into the product eventually.
> Regarding the name of the file, yes you can specify the name of the file a
nd
> the path when setting up the subscription.
> --
> Keith
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:31E014F7-F155-433F-AEE3-A38C5C817A0E@.microsoft.com...
> name.
> individual
> have
> different
> able
> one
>|||I am glad to hear that the suggestion was helpful!
Hmmm, I don't know if it is possible. Perhaps someone from Microsoft will
chime in with an answer.
In the mean time, send your request to sqlwish@.microsoft.com
They might not respond to your email, but they do read them!
Keith
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:CDBABC21-8E21-4F85-8DC5-2ABCE1FE9DA1@.microsoft.com...
> Once again Keith, your advised has helped me tremendously, Thanks!!..In
terms
> of the name of the file, I noticed that you can specify a filename if you
are
> saving the report to a fileshare directory but you cannot specify a
filename
> if you are sending the report via the report server email delivery in
report[vbcol=seagreen]
> manager. Is there a way around that' My report will be emailed to several
> customers and I would like to specify different filenames for each
> customer/report based on inidividual subscriptions for each customer.
> "Keith Kratochvil" wrote:
>
is[vbcol=seagreen]
links[vbcol=seagreen]
an[vbcol=seagreen]
into[vbcol=seagreen]
and[vbcol=seagreen]
of[vbcol=seagreen]
each[vbcol=seagreen]
this[vbcol=seagreen]
name[vbcol=seagreen]
went[vbcol=seagreen]
with[vbcol=seagreen]
a[vbcol=seagreen]
data[vbcol=seagreen]
Can[vbcol=seagreen]
been[vbcol=seagreen]
a[vbcol=seagreen]
with[vbcol=seagreen]

Reporting Services 2000 Export Excel Issue

Hello All,
I am currently creating a Reporting Services report whose total
page width is 33in. I use three data tables to simulate one very large table.
My issue is:
When I export this data to the EXCEL format, tables two and three are not
visible past the first sheet. Is there something that I should do to ensure
that all three tables are visible on every Excel WorkSheet?
Thanks
EricOn May 3, 2:52 pm, Eric <E...@.discussions.microsoft.com> wrote:
> Hello All,
> I am currently creating a Reporting Services report whose total
> page width is 33in. I use three data tables to simulate one very large table.
> My issue is:
> When I export this data to the EXCEL format, tables two and three are not
> visible past the first sheet. Is there something that I should do to ensure
> that all three tables are visible on every Excel WorkSheet?
> Thanks
> Eric
I'm not sure about the maximum width of a report; however, you can try
adding all 3 table controls into a single rectangle control. This
should conserve width space. Also, make sure that the properties of
the table controls include 'Fit table on one page if possible.' Sorry
I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting Services : Exporting Report To Excel (SubReport)

Hi All,

Issue : While Exporting Report to Excel (Report contains SubReport)

Advance Thanks

In Reporint Services, I am using Table control to display the data.

In that control footer section i added one subreport that accessing the value from the Footer Section of the table(like Total ..) Report is generating.

While exporing that report, it is giving exception like : "Sub Report in Table Cell could not be shown."

Any idea/ suggestion to resolve this issue.

I believe export to excel does not support this.

Reporting Services - Excel vs HTML ERROR plz help

Hey,
I have a little format issue with Excel 2003:
I am working in reporting services - creating a report. The SQL store
procedure returns a date with the following format:
MM/DD/YYYY HH:MM PM/AM
In my report on that perticular text field I have the following format:
dd/mm/yyyy HH:MM:SS
Because I want it in military time.
It displays fine in the report but when I open it in Excel it brings up
the following ERROR:
"File Error. Some number formats may have been lost"
And it shows the date columns the following way:
"38692.46597"
The document is NOT huge and does't contain more than 2000 rows.
Any ideas on how to solve this?
Sorry for posting twice(first post on here).
I have put this same post in the reporting services group.. Sorry

Reporting Services - Add a trendline with forecast to a chart

I know how to add a trendline with forecast in Excel. How is it done in SRS?
Thank you,
EmmaEmma
I would like to invite you to try Dundas Chart for Reporting Services.
What you are attempting to do is simple with our RS offering and an
example of this is included with our distribution.
Please visit www.Dundas.com to download a fully functioning eval
version.
Thanks
Andrew Bryan
Dundas Software
EmmaNikki wrote:
> I know how to add a trendline with forecast in Excel. How is it done in SRS?
> Thank you,
> Emma|||I took a quick toor of your website - the product looks great. I'd be buying
it with my funds, so can't do that.
Thanks, anyway.
Emma
andrewb@.dundas.com wrote:
>Emma
>I would like to invite you to try Dundas Chart for Reporting Services.
>What you are attempting to do is simple with our RS offering and an
>example of this is included with our distribution.
>Please visit www.Dundas.com to download a fully functioning eval
>version.
>Thanks
>Andrew Bryan
>Dundas Software
>> I know how to add a trendline with forecast in Excel. How is it done in SRS?
>> Thank you,
>> Emma
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200606/1|||Emma,
We came across the same problem, so we wrote a Stored Procedure that, for a
given set of values , would return the Linear Regression values of:
@.XCOUNT:
@.XSUM :
@.XSUMSQUARE:
@.YSUM:
@.SUMXY:
@.SLOPE:
@.INTERCEPT:
being the standard elements of calculating Linear regression. The Slope
indicates the Trend.
If you want a version of this, I can supply you it, it costs nothing, but I
will not post it on the forum at present.
Tony
"EmmaNikki via SQLMonster.com" wrote:
> I took a quick toor of your website - the product looks great. I'd be buying
> it with my funds, so can't do that.
> Thanks, anyway.
> Emma
> andrewb@.dundas.com wrote:
> >Emma
> >
> >I would like to invite you to try Dundas Chart for Reporting Services.
> >What you are attempting to do is simple with our RS offering and an
> >example of this is included with our distribution.
> >
> >Please visit www.Dundas.com to download a fully functioning eval
> >version.
> >
> >Thanks
> >
> >Andrew Bryan
> >Dundas Software
> >
> >> I know how to add a trendline with forecast in Excel. How is it done in SRS?
> >>
> >> Thank you,
> >>
> >> Emma
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200606/1
>

Reporting Service Rendering of Chart in Excel

Can I know when will Microsoft make available the true chart rendering
from reporting service to Excel?
I have been waiting for this features for 2 years now!On Jan 10, 4:15 pm, nhc2...@.gmail.com wrote:
> Can I know when will Microsoft make available the true chart rendering
> from reporting service to Excel?
> I have been waiting for this features for 2 years now!
I don't quite follow your question. I will say this though, I believe
that Dundas Charting is going to be used in SQL Server Reporting
Services 2008; so, that should definitely improve the charting
quality. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

reporting service client and column selection

can I use excel as a client for my reporting service? I see some docs on it,
but can't find the actual product. I want the user to be able to select what
column to be displayed. Is that possible now? how about sql 2005.Reporting Services 2000 can export to Excel format.
Reporting Services 2005 can too.
Office 12 (due in about a year?) has some additional Business
Intelligence functionality. There isn't much public yet about what
that will consist of, but it looks likely that Excel will do some
interesting things with Analysis Services information.
Can you elaborate on your column-related question? I am not sure
precisely what you are asking.
Thanks
Andrew Watt
MVP - InfoPath
On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>can I use excel as a client for my reporting service? I see some docs on it,
>but can't find the actual product. I want the user to be able to select what
>column to be displayed. Is that possible now? how about sql 2005.|||I don't mean export, I mean using excel directly connect to a reporting
server. basically, excel acting as a fat client.
column selection: if the report dispaly a table which consists of 10
columns, however, some user may not be interested in seeing all 10 columns.
Can the end user have the ability to hide/collapse that column? i.e. make the
report to display 5 columns instead of ten.
"Andrew Watt [MVP - InfoPath]" wrote:
> Reporting Services 2000 can export to Excel format.
> Reporting Services 2005 can too.
> Office 12 (due in about a year?) has some additional Business
> Intelligence functionality. There isn't much public yet about what
> that will consist of, but it looks likely that Excel will do some
> interesting things with Analysis Services information.
> Can you elaborate on your column-related question? I am not sure
> precisely what you are asking.
> Thanks
> Andrew Watt
> MVP - InfoPath
> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
> <NewSPUser@.discussions.microsoft.com> wrote:
> >can I use excel as a client for my reporting service? I see some docs on it,
> >but can't find the actual product. I want the user to be able to select what
> >column to be displayed. Is that possible now? how about sql 2005.
>|||I don't know precisely what BI in Office 12 will consist of but I
would expect to see more off-the-shelf functionality/integration of
SQL Server (2005?) BI apps with Office apps, including Excel then.
I believe you can use Excel (not sure which versions) to connect to a
Web Service. Since RS has a Web Service it should be possible to
produce a custom Excel app if you have the relevant VBA etc skills.
It's not something I have explored in detail.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 17:20:23 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>I don't mean export, I mean using excel directly connect to a reporting
>server. basically, excel acting as a fat client.
>column selection: if the report dispaly a table which consists of 10
>columns, however, some user may not be interested in seeing all 10 columns.
>Can the end user have the ability to hide/collapse that column? i.e. make the
>report to display 5 columns instead of ten.
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Reporting Services 2000 can export to Excel format.
>> Reporting Services 2005 can too.
>> Office 12 (due in about a year?) has some additional Business
>> Intelligence functionality. There isn't much public yet about what
>> that will consist of, but it looks likely that Excel will do some
>> interesting things with Analysis Services information.
>> Can you elaborate on your column-related question? I am not sure
>> precisely what you are asking.
>> Thanks
>> Andrew Watt
>> MVP - InfoPath
>> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
>> <NewSPUser@.discussions.microsoft.com> wrote:
>> >can I use excel as a client for my reporting service? I see some docs on it,
>> >but can't find the actual product. I want the user to be able to select what
>> >column to be displayed. Is that possible now? how about sql 2005.
>>

Reporting Service 2000 Rendering Extension. Changing Default Opti

Hi Everyone,
I'm having an issue with the CSV export in Reporting Services. The default
encoding for CSV doesn't work the best in Excel. I would like to change the
default encoding type for CSV to ASCII. It this possible?
Thanks
ChadYes it is. You need to alter the RSReportServer.config file for the CSV
rendering extension.
By default, the CSV export is in unicode, to export as ASCII then you'll
need to add some deviceinfo for the CSV rendering as follows :
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
Hope this is what you were looking for.
Phil
"Chad" wrote:
> Hi Everyone,
> I'm having an issue with the CSV export in Reporting Services. The default
> encoding for CSV doesn't work the best in Excel. I would like to change the
> default encoding type for CSV to ASCII. It this possible?
> Thanks
> Chad

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, Chris
If you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
--
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> > Howdy all. I just started a new job and am suddenly having to write
> > queries
> > for users on the fly and put the results into Excel. I was thinking
about
> > denormalizing the db(although there isn't really much normalization now)
> > into just a few tables that users would be able to understand and be
able
> > to
> > query for themselves. Then have some great tool that would be able to do
> > queries and export to Excel. Perhaps using drag and drop, check boxes,
> > etc.
> > Is there such a tool already for SQL?
> >
> > TIA, Chris
> >
> >
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>

Reporting from an excel datasource

Hi
I am trying to build a report from data residing in an excel datasource, but
cannot work out how, could anyone assist?
Kind regards
RickyYou need to setup and ODBC driver for excel. and then use this as the
datasource provider.
"RickyP" <ricky@.msn.com> wrote in message
news:4371AC59-84E2-4010-98DB-2CAB3755AF1E@.microsoft.com...
> Hi
> I am trying to build a report from data residing in an excel datasource,
> but cannot work out how, could anyone assist?
> Kind regards
> Ricky|||Thanks for the note, didn't realise you had to connect via ODBC...thought
that you could connect straight to an XL file...
"news.microsoft.com" <me@.myplace.com> wrote in message
news:O9ZEwxvlIHA.5956@.TK2MSFTNGP03.phx.gbl...
> You need to setup and ODBC driver for excel. and then use this as the
> datasource provider.
>
> "RickyP" <ricky@.msn.com> wrote in message
> news:4371AC59-84E2-4010-98DB-2CAB3755AF1E@.microsoft.com...
>> Hi
>> I am trying to build a report from data residing in an excel datasource,
>> but cannot work out how, could anyone assist?
>> Kind regards
>> Ricky
>