Dear all, I just started working with SQL reporting service last week. I have been writing a winform client that contains a the web browser control/pane. In additional to my winform client, I also have an ASP.NET application with my own HttpModule to handle security. I found that there's no...more >>

I have a matrix with the total column as the last column. I want a detail field to reflect a % of what the total field is. So something like this, which doesn't work, which is my issue, any thoughts? =Sum(Fields!QUANTITY.Value)/Total...more >>

Hi, I wonder how to combined the url path and table fields in order to have a complete path in generating an image dynamically?The image should be placed in a table details. Eg path that I want to display: file:\\sjwdtmsfs01\fin1\data\finprod\attachments\(file name) File name consist of thes...more >>

I know there are two license formats for Reporting Services Standard and Enterprise. I am interested in data-driven subscriptions which is an enterprisse feature. I have went through the Microsoft Reporting licensing pages and I cannot get a concrete answer on this question. Do I need SQL Server2...more >>

Hi All, Is it any way to hide a particular report from listing in the report folder? My actual problem is I deployed 2 reports in the report server and one of them is a subreport. And I want the users should able to run only the main report and not the subreport. TIA, Samuel ...more >>

Problem: Trying to combine two datasets onto a single table for x-referencing purposes. One dataset comes from a SQL Server and the other comes from a File System processing unit. The File System dataset makes it so that OpenRowSet can not be used. Attempt: I tried to create a DataSet through a...more >>

Programic render of a report to PDF, how to remove my html, and or render to a pdf w/out my param controls? Can I call a NewWindow? or what should I do? I've overcome how to pass a .Net dataset to a SSRS report, smoke & mirrors, it is a kluge but I've got it working. It wasn't much code j...more >>

I have been trying to use a custom XML data extension for SQL Reporting Services. The extension works fine when in the Visual Studio IDE, taking the "Connection String" (which is basically a directory path to the XML document used for the report) as both file system path and UNC path. Howeve...more >>

We are considering Reporting Services as one of the options for our company's data reporting needs. I have a few questions. It will be great if someone can help me with these. 1.Are Iframe and "new window" the only two ways to display/integrate reports in a .net Web application? Does the repor...more >>

I want to pass my report parameters via URL string and while I can get this to work, I was wondering if it's possible to hide the parameter text boxes at the top of the screen. I want these to be hard-coded from the hyperlink I access the report from within my web application and the user should no...more >>

HI, I have a dataset created from multiple datasources. I would like the reporting service to use this dataset to generate reports. How do i do this? In crystal reports, you could this by designing the report with field definitions only and setting the datasource property to Dataset/Recordset ...more >>

I am trying to use couple of PDF librararies to do some post processing on the PDF generated by reproting services but all the tools i have tried so far are unable to open PDFs generated by RS - however other PDF (which are not generated by RS) can be opened normally programatically. RS generated PD...more >>

In case of cascading parameters - when the report flashes - it shows a blank white screen. How may I replace that blank white screen with a message - "Please click view report when you are done selecting" ?...more >>

Ok, there has to be a way of dragging multiple fields from a dataset to a table like there is in Access. I have a dataset of about 30-40 columns and it will be excruciating to right click on a column in the table 30-40 times to add more columns so that I can then drag one at a time all the fiel...more >>

In Visual Studio Report Designer data tab, whenever I try to create a new dataset with the CommandType "TableDirect" I get the following message: "An error has occurred while setting the Command Type property of the data extension command. CommandType.TableDirect is not supported by the .Net S...more >>

Hi, I have created cubes using Analysis Services. Could I please know how to create a data source to connect to those cubes in Reporting Services to generate reports out of them. When I choose to create a data source in Reporting Services, I am able to see options only to connect to Sql Server, O...more >>

I want to change the layout for the parameters in my menu bar. I understand that with SP1, I can use style sheets. 1. I want to group three on top and then but a horizontal bar <hr> and then I want to put four in the middle - and agin a <hr> and then three at the bottom. 2. Also - ...more >>

Hi, Has anybody come across a good menu system for MSRS? We could write our own but are perfectly willing to look at a packaged product. Thanks for your help. CB ...more >>

Hi, I use subtotal in matrix and data source is OLAP Cube. Syntax is... SELECT { [Measures].[Cnt]} ON AXIS (0), { Descendants ([Product].[ALL],[Proeduct].[Brand], LEAVES) } ON AXIS (1), { Descendants ([Year].[ALL]) } ON AXIS (2) From Prodkuct But why the value of subtotal is the first v...more >>

I have created a test table in the dataset using following SQL DECLARE @Table TABLE ( ID INT IDENTITY (1, 1) Not Null, Category varchar(20), DetailLine varchar(500), NumData INT ) INSERT INTO @Table (Category, DetailLine, NumData) VALUES (N'ABC', N'Detail ...more >>

I've set up a timed subscription scheduled for Monday - How can I run it now? Thanks ...more >>

Hello, Is there a format in VB.net/Reporting Services that will achieve the same results as [h]:mm:ss in Excel? (e.g. 64:09:34) Thanks in advance for any help. Craig...more >>

Ok, what is the secret key combination to refresh the fields list? Please? :-) I am modifying a drilldown report I created, and have added a field returned from my stored procedure, and would now like to include this field on my report. I am clicking around and I cannot seem to trigger it to re...more >>

Hello Newsgroup, i have problems with formating in the textfield. I want to format a field user-defined like this #,##0.00 ?/ Fields!MengenEinheit.Value now the text would have to look as follows 12.345,67 ?/m³ but it is indicated the following 12.345,67 ?/ Fields!MengenEinheit.Value ...more >>

Hello, I installed RS on a Windows 2003 Domain Controller then uninstalled the product. Now when I attempt to install again the process gets through the support files then just ends. Upon rebooting the server I am told the install failed. What is going on and how can I reinstall RS? Th...more >>

My home folder gives Everyone access to the Browser role. Then I have a Test folder that contains a Test Report. I created a TestUser and added them to a TestGroup. The problem is that the TestUser cannot see my TestReport. I removed Everyone from the TestReport. TestFolder still has ...more >>

I'm trying to access report server from internet. Is ReportServerExternalUrl the right way ? Or must I change all references to <servername> in configuration files to <www.mysite.com> ? Can someone tell me how to use ReportServerExternalUrl configuration setting? The documentation is very poor ...more >>

I would like to take 3-4 reports and export them to one PDF file- whats the easiest way to do this? Thanks. ...more >>

This there a way to integrate the full version of Dundas Chart Pro in RS reports by using the extensibility API? Including a URL accessed image of a Dundas Chart doesn't cut it if the rendering is to be done by PDF - my experence is showing that the image will be heavily pixelated. TIA Je...more >>

I'm trying to specify a Null default value for a query-parameter... I tryied "=Convert.DbNull", but it doesn't work... Does anybody knows how can I do that? Thanks...more >>

There is a way to configure the currency symbol (default $) in order to use what define in the regional setting (Euro € for example). ...more >>

I'm trying to call a report, passing my parameters via query-string... I have one parameter that can receive null values... Following Books Online, the syntax for null values is :isnull, giving the following sample of URL: http://exampleWebServerName/reportserver?/foldercontainingreports/orders&d...more >>

Is it possible to actually rotate text 90 degrees to the left or right in a text box using custom code?...more >>

When a user subscribes to a parameter report, usually enters specific values with which the report should run before delivered through the subscription. If the subscription is an ongoing one, time-based parameter values initially entered by the user will have the problem of being outdated and havi...more >>

Hi,everyone I have a report. I List a employees in a table,I use a parameter "DepartmentID"(0-n) to query employees dataset1. I have other dataset2 ,the department from a sql text. the parameter "departmentId" from dataset2,and I need a default value "All" to list all employees. But the def...more >>