Reporting Services

Connection issue from analysis to reporting

I have a report pulling the data from analysis services and reporting in SSRS reports. when i try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...

Identifying data in SQL Reporting Services

I am using SQL Reporting Services, and one of the files has the same ID but a unique position number. The field names are ID, pos, phone number and extension. Now, for example, a person with three phone numbers will have three records (pos 1-3). In this scenario, how would I identify a phone...

Blank fields on reports in SQL Server Reporting Services

I am working on Microsoft Visual Studio Team System for testers, and I have generated reports using SQL Server Reporting Services. However, when I select Dial-Up 56 or Cable/DSL 384 network in the Network mix, the values in all the fields of the reports come up as 0. Is there any reason why this...

Reporting Services - Deploy error

Hi there, I recently changed my computer name, and from that moment the SQL Server Development Studio couldn't deploy my project anymore. It successfully builds the project, but can't deploy it. It returns the following error message: "A connection could not be made to the report server...

SQL 2000 Reporting Services - Using embedded code to guide user on input parameters?

I'm working on a report which has these input parameters: StartDate (textbox, data type is datetime) EndDate (textbox, data type is datetime) AccountNumber (dropdown, data type is string) I need to set up logic where if the user viewing the report has input only date values, they'll be prompted...

sql server reporting server

I have seperate application server for ASP.NET(2.0) and Database server for Sql RS 2000, when i try calling reporting service webservice to generate excel and allow to download to the web user, it gives an error as "401 as unauthorised", can anybody has a solution for this Regards, Prathesh

Report Properties Code

Where can I find information on how to use the Report Properties Code