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...

GIG240 pointsBadges:

SSRS authentication in workgroup environment

Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 "server" authenticates fine but none of the current client computers are able. Thank you.

ConFlicker210 pointsBadges:

Reporting Services 2005

Hello, I am running reporting services 2005. I created a subscrition for a report named "paid_claims" that will auto generate an excel file into a shared folder on the network. The "paid_claims" report has a link to another report named "sub_paid_claims" in the same folder. We recently renamed our...

Rick Martinez585 pointsBadges:

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 to...

Darth Continent35 pointsBadges:

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 number...

SQL Server Ask the Experts2,585 pointsBadges:

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...

SQL Server Ask the Experts2,585 pointsBadges:

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...

Barend IT15 pointsBadges:

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

Prathesh5 pointsBadges:

Report Properties Code

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

JTHogan5 pointsBadges: