Hello, I have a report which used AS as a source. I have a report parameter and a dataset with the following query: ="with Member [Measures].[BGBNLUniqueName] as '[Product].[Concern].currentmember.UniqueName' member [Measures].[BGBNLDisplayName] as 'IIF( [Product].[Concern].Current...more >>

These are answers to questions I frequently received from early adopters (TAP customers): Q: Is the ReportViewer control included in SQL Server 2005? A: No. Report Server is a component of SQL Server 2005, but the ReportViewer control is not. ReportViewer is only included in Visual Studio 20...more >>

Hi, I've written a report that uses a matrix to display some data that all comes from a funky select statement. The report is month based, so there is a where clause specifying the month in the select The user now wants to add a Year to Date column. Because of the data structure of the data...more >>

We tried to develop a MSRS Java Client to communicate with the MSRS server via web services. Because of integrated windows authentication, we encountered an access denial error. Has anyone encountered this problem and know how to embed windows security in the Java client. By the way, I used ...more >>

When I browse through https://rpsvcs.mysite.com/Reports/Pages/Report.aspx?ItemPath=%2fpath%2fto%2fmy%2freport... a text box for searching within the results is shown and also a Search | Next hyperlinks for performing these actions. However, when I access the same report using direct urls su...more >>

I create an ODBC connection to my datasource. Then in my data set i only have a "Text" and no "Stored Procedure" in the drop down list. How do i go around this and why is only "Text" available when using an ODBC connection? Thanks! ...more >>

Hi All, I am using a .net dll in my RDL, I have done all the steps to implement the custom assembly in the report. -- Message posted via http://www.sqlmonster.com...more >>

Hi, I have two tables based on the same dataset. The way the report is setup i have it set up with two tables. One table shows the latest month and the other table shows a 12 month period of the same data. It is also grouped by division number. What i want to do is show both tables (latest an...more >>

I have a number of dynamically configured hyperlinks in my report. Clicking on them, takes user to a different application. I want for this new app to open in a different browser window from the report itself, but instead it opens in the same window and replaces my report data. Any ideas ho...more >>

Currently I'm using this expression in a matrix to provide a running total of sales by month. Is there a way to reverse this so that it counts down to zero rather than adding each month together? Here's the expression as is: =IIF(InScope("matrix3_RowGroup1"),Sum(Fields!MonthAmount.Value),Run...more >>

I would like to create a report in Reporting Services that lists the reports in my SRS, including their descriptions, specified by the folders they reside in, by pulling the data directly from the SRS? Is this possible? The data's there. How can I get to it dynamically? Thanks. ...more >>

I have seen this discussed before here, but I guess not quite that way I want to use it. We would like to use pure Windows NT Integrated Security, therefore taking advantage of AD groups and existing security in SQL Server. However, anytime we select the 'Windows NT Integrated Security' option...more >>

Hi, I have the Year as parameter in my query. I want also an option for "All Years" so that when users choose "ALL Years" they can view the data for all years... How can I add this in my query.... Select Customer_info.KPChoice as BusinessUnit,Count(*) as TotalOrders,Region.Region,LEFT(DA...more >>

Is there a way to enlarge the area where report input parameters are displayed on report manager? Right now, reports with many input parameters require the user to use a scroll bar to view all parameter to input...more >>

hello >> i want to show a custom dialog that shows specific printers and let the user pick one and then I want to print to the selected printer. (i don't want to show all the printers installed in the system) -- how can i do this is RS? - >> there does not seem to be an object model for RS ...more >>

Is there a list for all of the expressions that belong under the Globals. Such as: Globals.ReportName Globals.TotalPages .. .. .. Thanks! ...more >>

When i attempt to create a new e-mail subscription to a report i get the following error message: "Subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer vali...more >>

I need to generate a report which (1)using a dataset to get the path and file names of a group of GIF images from a database table, and (2) dynamically construct an URL for each images, and finally (3) using the URLs to dynamically add the images into the report pages. Since I have millions of...more >>

Hi, On my Windows XP pro SP1 I have installed: 1. SQL Server 2000 with sp3a 2. VS.NET 2003 3. and I'm able to create a ASP.NET 1.1 project and deploy it to IIS. And when I start the setup of the SQL SERVER Reporting Service Dev Edition. And request to install ALL Server Co...more >>

Good morning, 1. It is my understading that you cannot merge cells in a column in a table (report item) but you can in a row. Does anybody know of a workaround to this and can possibly explain to me why you cant merge cells in a cloumn? 2. I have a value, say 2, and i want 2 stars or '**' ...more >>

Hi there! I have a report that has a link on another report ( something like hyperlink to another report ). This link is configured in the Advanced Properties under the tab Navigation. I use 'Jump to report option'. Everything works okay, however the report to which I want to navigate is ...more >>

I have a situation where MSRS is being used as a part of a number of web based applications. One of the requirements of these applications is that a SessionID can be logged with every call made to an application component. The purpose of this is to allow end-to-end auditing of all the user...more >>