Reporting services 2005 - rezising the legend size

Hi all,I have a report with a chart.the chart has a legend.The problem is that the number of categoried the legend contains grows in time.

How to i do i make the legend rezing dynamicly so that the text doesnt go over the other?

You could consider a "table" legend layout which may be able to better accomodate the legend items.

Other than that, you could look into building a custom legend by using a table data region instead of using the built-in legend (see this article for more details: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx)

-- Robert

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 - use of temp tables

Hello all,

I need to create a report based on a stored procedure. This stored procedure contains temp tables. At the time of creating the report, I receive a message mentioning - There is an error in the query. Invalid object name '<temp table name'>

Doesn't Reporting Services support temp tables?

Thanks all,
SauravYou can use temporary tables. I tend to do it like...

-- Create temporary tables
declare @.MyTempTable table
(
field1 int,
field2 smalldatetime,
field3 int,
field4 smallint
)

You can then use @.MyTempTable for your SP.

Hope that helps.sql

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
Marcin S.All versions of SQL 2005 will come with Reporting Services
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/p...rsfeatures.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Hi,
Ok, but wath about SQL 2000 server?
Marcin S.
"Wayne Snyder" wrote:

> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
>
>

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
Marcin S.
All versions of SQL 2005 will come with Reporting Services
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.
|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/pr...sfeatures.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.
|||Hi,
Ok, but wath about SQL 2000 server?
Marcin S.
"Wayne Snyder" wrote:

> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
>
>

Reporting services

Hi,
I could not find any information about the MSSQL Express/Workgroup
The question is: if this version contains the Reporting services?
--
Marcin S.All versions of SQL 2005 will come with Reporting Services
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Have a look at the SQL Server 2005 Reporting Services Feature Matrix
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> Hi,
> I could not find any information about the MSSQL Express/Workgroup
> The question is: if this version contains the Reporting services?
>
> --
> Marcin S.|||Hi,
Ok, but wath about SQL 2000 server?
--
Marcin S.
"Wayne Snyder" wrote:
> All versions of SQL 2005 will come with Reporting Services
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:0A23FFAC-4067-4ADE-B879-A66B1CED8531@.microsoft.com...
> > Hi,
> >
> > I could not find any information about the MSSQL Express/Workgroup
> >
> > The question is: if this version contains the Reporting services?
> >
> >
> > --
> > Marcin S.
>
>

Reporting Service Q: stored procedure works fine, but preview doesnt

Hello

I got an error when doing preview of my report.
The data set 'dsTransTime' contains a definition for the field 'Trans_Type'. This field is missing from the returned result set from the data source.

The data set is populated by stored procedure. The data set works fine when I run it seperately at the Data view in Visual Studio 2003. But it doesn't work on Preview.

Please help!, thanks,

Spent few hours, finally find the solution.
Just click the 'Refresh' button on the Data view.

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.