Hello, I am new to SRS. So this is a new-be question. When creating a new report in visual studio. When creating a new dataset. Do you always need to create a query string to retrieve the fields that can be used on the form? Is there some SQL picker query builder. Where you can build a query...more >>

Hi, I'm having a Matrix with 5 RowGroups and 2 (+static) ColumnsGroups The Rowgroups 1-4 are a kind of dummy groups that always have the same = value (expression =3D1) so that i can play with the values printed in = the totals. I'm having this expression to test my values .. =3DIif(InSco...more >>

Hi all I would like to make one report that could connect to all servers on my network (not all on the same domain, Mixed mode authintacation). An example of use would be to click a link for each server to view the result set for sp_who, sp_databases, version information or anything simil...more >>

Is there a way to show the report title in an Internet Explorer tab instead of having it render "Report Viewer"? Seems that users are opening many reports and it is hard to find the one you want with many windows open. Any Thoughts? Thanks Rick...more >>

We have our webserver (http://www.mywebserver ) and the reporting services 2000 running on a different intranet server ( http://myrs2000). For some time, we have exposed some RS reporting using the ReportViewer object on several intranet web applications as well as within Sharepoint portal ser...more >>

I have a report where the dataset is text and not pulling from a stored procedure but probably should be. The query includes populating a temporary table. All has been fine passing parameters from the report into the select statement that populates the temporary table until I added an addition...more >>

I'm new at this but here goes... I just got handed the Reporting Service Management and wanted to know if anyone had a report that would list the reports on my site that a specific role had access to? Example how many reports have Domain Users as one of the role assignments? Or list the rep...more >>

Hi everyone I'm using Reporting Services and in my Dataset's Query I'm want to use a variable in my IN clause that that holds the different values (strings) but I can't seem to get it to work. I've posted the SQL statement as it currently is and what I tried to do to get it to work. Thanks fo...more >>

I have a matrix and I want to insert a page break on a column group. I dont see the option under grouping and sorting properties for my column groups only on the rows?...more >>

Is it possible to pass a field value as a parameter to a stored procedure? I included 2 datasets in my report. The first dataset contains the data fields while the other retrieves a stored procedure. I need to pass the parameter to the stored procedure based on the data field of the first dat...more >>

I have a detail report that prints an employee info form - which easily fits on one page. When viewed online it displays one page per employee (beautiful) - but when printed there is a blank page between each employee form (where blank = page header and nothing else). Any ideas on how I can...more >>

We're trying to put together a pretty advanced implementation of SQL Reporting. We are trying to devise a way to allow the end user to dynamically order the columns. For a variety of reasons we cannot use/deploy the client tool set. Our data won't fit nicely into models. So, what we ...more >>

I have a report which prints an employee information sheet for multiple employees - with each employee' sinformation on a separate page. When I view and navigate through this online, I see one page per employee (which is correct). However, when I print this report, I get a blank page (with the...more >>

Can I upload a Excel Report to Reporting Services? The only reason I am asking is that in the UI of our Report Manager, we can upload Excel, Word, PDF documents, etc. Am I in the wrong newsgroup? If so, can someone direct me to the proper newsgroup? I have a questionmm to ask. ...more >>

I am using SQL Server 2005. My report has four parameters; three prompt for values and one is internal. The internal one is the source of the problem, since when I remove it the report works. I am using this internal parameter to display database information in the page header, following ...more >>

I'm trying to change that a matix column reflects, but if i place a case statement in my SQL I get: The multipart identifier could not be bound. ...more >>

Bonjour! I have this error when I try to run my reports with https://URL:port/reports. My application pool on IIS is set to a domain account(we don't have kerberos). If I call it in Visual Studio with the Reportviewer object everything is fine. I don't understand, the data source is set t...more >>

Hi, I have a web reportviewer control in a web page, which is based on a Master page. If I open a report that expects parameters, and I don't pass any parameters, then it will prompt for them as you would expect. If a parameter is a date / datetime, it will show a datepicker control - a...more >>

We have a plan to migrate our Existing Crystal Enterprise 10 system to Sql server 2005 reporting services(SSRS). Following are the details about the existing system/requirements:- Existing stats:- No of reports- 1500+ Max NO. OF RECORDS in a report REPORT-500K total number of users- 500 ...more >>

I have an oracle stored procedure that will accept 3 parameters from a report services..... it seems that I can not find the way to call this stored procedure since the syntax is not the same as this sp was written in SQL Server. Could you help? Thanks...more >>

When trying to setup a subscription, I am getting the following error; "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid." Any ideas? Thanks, Ryan ...more >>

Bonjour! I can't have access with my management studio to Reporting services (2005)installed on my web server. (Cannot connect to...)Do my developpers needs special rights? Regards, Joel :)...more >>

We are using SSRS SP2 in SharePoint integrated mode and when I use an expression that results in a URL that I use for a hyperlink in a report, it works in Visual Studio but not in report viewer. If I use a static URL it works fine. Upon inspection of the source that is returned by SSRS w...more >>

Hi, How can I have a tabular report with two tables where the data starts to flow from the top of first table on the left until it reaches the end then begins filling the other table in the same manner (top to bottom)? example: S/N EmployeeName | S/N EmployeeName 1 Employee1...more >>

When I first call for a report (from URL access or called from ASP 3.0), it takes about 10 seconds before it appears. Subsequent reports take less than a second to appear. I'm not really sure where this lag is likely to come from, e.g. IIS, RS, SQL Server, etc. Where and how do I configure ...more >>