report description

Hi,
How can I display the report description on the report itself?
Have been looking over the books online but can't find the answer there.
Maybe its not supported?
regards,Please clarify the question.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi,
> How can I display the report description on the report itself?
> Have been looking over the books online but can't find the answer there.
> Maybe its not supported?
> regards,
>|||Hi,
Thanks for replying!
In the properties dialog of a report there is a 'Description' field in which
we are setting with text that describes the report's purpose.
Basically, I'm looking for a way to add this description field in a textbox
on the report, such that the description text is printed on the report. Is
there a global object collection which exposes this property?
example: Globals!reportName displays the report name, is there something
similar for the description?
regards,
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:uChoKJjpEHA.896@.TK2MSFTNGP12.phx.gbl...
> Please clarify the question.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Emmanuel" <emmanuel@.email.com> wrote in message
> news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > How can I display the report description on the report itself?
> >
> > Have been looking over the books online but can't find the answer there.
> > Maybe its not supported?
> >
> > regards,
> >
> >
>|||The Description property is not exposed. One workaround for this is to add a
textbox to your report that contains the description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:uAvux$jpEHA.1300@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Thanks for replying!
> In the properties dialog of a report there is a 'Description' field in
which
> we are setting with text that describes the report's purpose.
> Basically, I'm looking for a way to add this description field in a
textbox
> on the report, such that the description text is printed on the report. Is
> there a global object collection which exposes this property?
> example: Globals!reportName displays the report name, is there something
> similar for the description?
> regards,
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:uChoKJjpEHA.896@.TK2MSFTNGP12.phx.gbl...
> > Please clarify the question.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Emmanuel" <emmanuel@.email.com> wrote in message
> > news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > How can I display the report description on the report itself?
> > >
> > > Have been looking over the books online but can't find the answer
there.
> > > Maybe its not supported?
> > >
> > > regards,
> > >
> > >
> >
> >
>

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Report Builder localized in spanish

I work with an English SQL Server 2005 license , but would like that the Report Builder tool presents itself in spanish in the client computers .

I can localize the Report Manager to spanish without problems (configuring the spanish language in IE) , but the Report Builder still presents its interface in english .

How can this be achieved ? With Regards ,

George

You must have a Spanish version of the operating system, or a multi-language pack that allows you to change the operating system UI to Spanish. IE language settings do not affect Report Builder.

Report Builder imported questions from a customer

Hi,
1. If a table has a relation to itself example :
employee id emp name manager id
1 Melissa 2
2 Steven 100
This means Steven is the manager of Melissa.
Is it possible to make a report in Report Builder to have a list with of the
managers and their employees?
2.Following example in report builder an organization with his employees you
will see in Report builder this : (organization will appear only once)
Microsoft Steven
Melissa
BMW Jan
Els
In export to xls the customer wants to see this :
Microsoft Steven
Microsoft Melissa
BMW Jan
BMW Els
Is this possible?
And if a certain organization does not have employees they want to see this
organization for the moment the report only list organizations with employees?
3. If the email field of a person (table 1) is empty they want to see in the
report the email field of the organization (table 2) is this possible with
the function if then else... in the creation of a new field without having
fields of the organization in the report displayed?"carolineb" <carolineb@.discussions.microsoft.com> wrote in message
news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> Hi,
> 1. If a table has a relation to itself example :
> employee id emp name manager id
> 1 Melissa 2
> 2 Steven 100
> This means Steven is the manager of Melissa.
> Is it possible to make a report in Report Builder to have a list with of
> the
> managers and their employees?
Write query like this:
select
c2.Name as ManagerMame,
c1.*
from Employees c1
left join Employees c2
on c2.EmployeeID = c1.ManagerID
order by c1.ReportsTo
> 2.Following example in report builder an organization with his employees
> you
> will see in Report builder this : (organization will appear only once)
> Microsoft Steven
> Melissa
> BMW Jan
> Els
> In export to xls the customer wants to see this :
> Microsoft Steven
> Microsoft Melissa
> BMW Jan
> BMW Els
> Is this possible?
> And if a certain organization does not have employees they want to see
> this
> organization for the moment the report only list organizations with
> employees?
As far as I know this is not possible (export should be WYSIWYG if it is
working correctly)
> 3. If the email field of a person (table 1) is empty they want to see in
> the
> report the email field of the organization (table 2) is this possible with
> the function if then else... in the creation of a new field without having
> fields of the organization in the report displayed?
>
Yes it is possible, you don't have to display all fields.
Regards,
Stjepan|||"Stjepan Puljko" wrote:
> "carolineb" <carolineb@.discussions.microsoft.com> wrote in message
> news:FE5D33EF-66CC-4420-B60C-CC8AC82AA616@.microsoft.com...
> > Hi,
> >
> > 1. If a table has a relation to itself example :
> >
> > employee id emp name manager id
> > 1 Melissa 2
> > 2 Steven 100
> >
> > This means Steven is the manager of Melissa.
> > Is it possible to make a report in Report Builder to have a list with of
> > the
> > managers and their employees?
> Write query like this:
> select
> c2.Name as ManagerMame,
> c1.*
> from Employees c1
> left join Employees c2
> on c2.EmployeeID = c1.ManagerID
> order by c1.ReportsTo
> caroline : we cannot write a select in report builder?
> >
> > 2.Following example in report builder an organization with his employees
> > you
> > will see in Report builder this : (organization will appear only once)
> >
> > Microsoft Steven
> > Melissa
> > BMW Jan
> > Els
> > In export to xls the customer wants to see this :
> > Microsoft Steven
> > Microsoft Melissa
> > BMW Jan
> > BMW Els
> > Is this possible?
> > And if a certain organization does not have employees they want to see
> > this
> > organization for the moment the report only list organizations with
> > employees?
> As far as I know this is not possible (export should be WYSIWYG if it is
> working correctly)
> > 3. If the email field of a person (table 1) is empty they want to see in
> > the
> > report the email field of the organization (table 2) is this possible with
> > the function if then else... in the creation of a new field without having
> > fields of the organization in the report displayed?
> >
> Yes it is possible, you don't have to display all fields.
caroline : I have tried to do this and was only allowed to use fields of one
table in the if then else function, he did allowed to select a field from
another table in the if then else but indicated with an error message that
the function is not valid?
> Regards,
> Stjepan
>
>