SQL Server Reporting

Error using SQL Server reports in a web application

I have used SQL Server reports in my web application, and I can see it on the same server but we are getting a "Server Not Found" error on my user's machine.

"Login Failed."

Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit "OK" they get and error that says "Login Failed." i am getting ERROR Message "Failed...

Preparing a report on a SQL Server database

I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?

Building reports in SQL Server 2008

I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?

Error message while running a report created in SQL Server Report Builder

I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: "Cannot create a connection to data source 'dataSource1'. ---------------------------- An error has occurred during report processing." What can I do to avoid this...

shrinking of pie-chart graph when there is no data

In my application, i have to display "No Data Available " at the pie-chart when there is no data to show in pie-chart... I have done that by setting the NoRows property to "No Data Available" , but the graph block shrinks by 1-2 mm when there is no data..Can anyone provide me the solution to this...

Deploying reports created in SQL Server Reporting Services

We have SQL Server Reporting Services installed and I have created several reports. However, I cannot get the Report Manager website to work so I can deploy the reports. How would I do this?

Designing a report in SQL from an Excel worksheet

I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

sql reports

Sql Server Reporting service. 1.first query I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below, Fig:1 Jan-08 Feb-08 Mar-08 Bug Trend ECR 3.88 4.06 3.86 Goal 5.00 5.00 5.00 Backlog 70 75 82 Incoming67 71 55 Outgoing62 65 56...

SSRS Excel export

Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.

Excluding Data Usin NOT IN

I'm trying to export data from a sql table into sql reporter. The information I'm trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type ...

SQL Reporting Service 2005 Report Stayle/Layout

How to make the Reports layout change automatically? That it looks just like the clients webpage? Even when they change their colors, borders etc.

Hosting SSRS on Windows XP - user limitation.

While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.