Services - Reporting Services

Thread preview

Thread	Last Post	Replies

Distinquish our two SSRS websites with the use of color...	31 Jul 2009 17:46 GMT	2
I finally have a development/test environment at my company and we would like to distinquish our two SSRS websites from each other with the use of color. I know you can change the "Name" of the server in the site settings to
Report Layout	31 Jul 2009 09:43 GMT	2
Is it possible to change the default web page for the report? For example, move the "view report" button, or change the tabs.
Sorting strings with numbers (natural sort order)	30 Jul 2009 20:16 GMT	4
I'm using SSRS 2005. Basic report is simply reading a table and returning two pieces of information: ProdCode and Description I am trying to find a way to present the data set with a more natural sort
Creating a report with Master and multiple details	29 Jul 2009 16:21 GMT	2
I need to create a master /detail report and I'm trying to avoid calls to the data source for each master item. For a simple case where I have one set of details associated with a master item, I can just join at the datasource and group by master
Dynamic Sub Reports	29 Jul 2009 11:32 GMT	2
One of the best features in Reporting Services (all versions) is the ability to have that little expression box next to most properties where you can dynamically generate more "flexibility" at run time. I love it!!! EXCEPT WHEN IT COMES TO SUB REPORTS.
Local printing with RSClientPrint	28 Jul 2009 15:11 GMT	1
Here is a code I am trying: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" >
Reporting services load times	27 Jul 2009 15:57 GMT	1
Running SQL 2005 RS and I have noticed that when I launch IE and go to http://myserver/reports it takes litterally minutes for it to display in the browser. Seems like it only does it the first attempt in the day, after that it loads fine. I'm guessing there is something on the ...
product function	27 Jul 2009 13:42 GMT	4
is there a way to emulate a product function with reporting services? Let's say I have the following rows in my datatable 1 2
Read Committed Snapshot Isolation (RCSI). -- can it be put in connection string of Data Source?	24 Jul 2009 10:05 GMT	1
Subject says it all. Can a part of the connection string be added to the Shared Data Souce to get RCSI? Any help appreciated. Thanks in advance. Michael
Adding/Deleting SSRS users and roles	24 Jul 2009 07:32 GMT	4
Any one know how to add or delete a SSRS user or how to add or delete roles to a SSRS user in SQL2005 Can this be done wothout using the Report Manager? Can this be done via .Net(eg. vb.net). Or via sql code in SSMS
SSRS 2005	23 Jul 2009 23:06 GMT	10
I am working on creating a administration report to list all user access to folders and reports. Then add parameters to filter the report base on reports and folders. I started but I want to get any suggestions on what tables I should use to get this information.
Using IIF in a report?	23 Jul 2009 21:39 GMT	2
I have a dataset where one field contains either the letter T or the letter F. In my report I want it to show as the word True or blank. I thought using IIF was the obvious function but I can't get it to work. In the expression for the field I have:
How can I duplicate Excel's % of row in SSRS 5005 matrix report	23 Jul 2009 18:57 GMT	4
I have an Excel Pivot table that includes a calculated field that gives a percentage of the row for each cell. (Field Settings\|Options\| Show Data as:). I'm moving this report to SQL Server using Reporting Services 2005.
sorting by textbox	23 Jul 2009 10:09 GMT	12
I have a textbox field as a column in my SQL Reporting Services report. It’s a field based on a nested “If, Then” statement that I created that returns results numbered 1, 2, 3, 4, 5, 6, or 7. I simply want to sort my report based on the values in this column. But, I
Report Generation Taking a long time	22 Jul 2009 18:46 GMT	5
I am using SQL SERVER 2005 with RS, my development IDE is VS2005. I have a report which gets its data from a series of UDF's (nested), my problem is that within Query Analyser, and The 'data' tab in the report designer the results come back in 5-8 seconds.