Earlier today I was searching all over for how to Group By Week in SRS. (HINT TO MS: This is extremely easy in Crystal...) And while I found several others asking the same question I found no satisfactory answer. I had to dig into SQL books online to put it all together and have tested this so...more >>

I am starting to get the following error in reporting services Server Application Unavailable the web application you are attempting to access on this web server is unavailable. Please hit the "Refresh" button in your browser in order to retry your request. I was trying to access report mana...more >>

The virtual directories are created on the default Web site in Internet Information Services (IIS). How I can locate the IIS in which he is not default? ...more >>

how do i set PDF as default attachment, instead of web archive? ...more >>

I have a report that uses parameters from a query. The query returns two columns. One for the paramerter value and one for the parameter title. I want the header of the report to access the same fild that I have set as the Label Field in my report parameter dropdown. I can add the actual pa...more >>

Hi guys I have created a report that connects to a FoxPro database. The report works fine on my local box(dev environment) but once deploied it wont work. Displaying the following error: -------------------------------------------------------------------------------- An error has occurr...more >>

I have been building our own generic report viewer using the render method. I am aware that you lose the interactivity with the report, but I an wondering(hoping) if someone has come up with a solution for creating page navigation? In a perfect world I would also hope to recreate the dr...more >>

Is there a way to configure a RS data source (in VS.NET) to be not visible as default when deployed? Thanks, Bryan ...more >>

Can you create a Report project from a workstation? Any help would be greatly appreciated. Thanks. Jacob...more >>

Developers, I'm VERY new to MRS and I'm trying to format a report. I have a Header, Detail, and Footer. In the Detail section, I have a table containing my report items. Each cell contains variable(s). Well, I have an address, and I want the Verticle Spacing between the lines to be...more >>

Hi, I have a Matrix that looks like this: ------------------------------------------- | | Vend #1| ------------------------------------------- | Customer# | Sales:| $1.00 | | 123 ABC St. ------------------ | Anycity, USA 22222 | Ca...more >>

Hi, Do you want a webbased Report Builder for Microsoft Reporting Services visit www.gmsbv.nl and order the free 60-days trial of ReportPortal 2.0. With ReportPortal 2.0 you can build Reporting Services reports without need for Visual Studio or any other component. Regards, Marco www....more >>

I changed the security on the directory security on the 'Reports' virtual website to anonymous, and then changed it back to Windows Authentication. After this, it appears that I am no longer a System Administrator when I access the Report Manager website /Reports/Pages/Folder.aspx 'Site Se...more >>

I have an existing asp webpage, I'll refer to it as page1. Page1 displays a limited set of data. I want to have a detailed report version of page1 on reporting services. I'd like to pass page1's querystring to the report on reporting services and have the report use this querystring for the re...more >>

Hello Group, I am having a report parameter which is of the type DateTime. I get a simple textbox for that and if the user types in some invalide date an exception is thrown on the UI. I want to handle this parameter as soon as user types it in and clicks on the 'View Report' button. Can i so...more >>

Hi, I am just wondering if it is posible to use Graphic query designer outside of VS or Enterprise Manager? There are third party tools, but all of them are for from this one. Or maybe there is a way to use Microsoft classes/components used to build Graphic query designer. Thanks. V...more >>

I was using some field value as querystring of external link. the value type is string so I used Web.HttpUtility.UrlEncode to transfer it. It works fine in preivew but the link doesn't work when I upload the rdl file to the server. I copied system.web.dll to bin folder of the server but it did...more >>

It helpded - thank you very much. It's a kind of nightmare - when I fix one error (with your help) I got another... :(( After fixing aspnet credentials I got something like this: The underlying connection was closed: Could not establish secure channel for SSL/TLS. I unchecked SSL ...more >>

Hi, I'm trying to open a report that was created a few days ago to make modifications. When I double click on it in the Solutions Explorer in VS.NET, I get an Exception from HRESULT error. The report has been published to the report server. Does anyone know how I can troubleshoot this?...more >>

Subscriptions created with the "Include Report" and Render Format selected are throwing the following error: ReportingServicesService!library!63c!02/24/2005-11:18:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server ha...more >>

Hello, I hope this all makes sense. I need something that has the functionality of both a table and a matrix: - Table: drilldown into individual records - Matrix: show one of the groups horizonally Here's a simplified version of what I need the table/matrix to look like. Everythin...more >>

PROBLEM: I wish to use reporting services to produce a report which prints product labels. Each row in the product data source will have a label, therefore I use a list object. The report must have 4 columns - one label in each column, therefore I set the column property in the report body ...more >>

Hi All, I have develoded the SRS report using vs.net , and deployed to my local sever using vs.net all works fine. No i need to deploy these reports to a production server where vs.net is not present. So can any one tell me how to automate this process of deployment to product...more >>

Does anyone perhaps have an idea how to set the report to print in Landscape by default? Any help would would be much appreciated Thank you ^^ ...more >>

I am using a strong-named custom assembly to which I have assigned 'Full Trsut' in both the rspreviewpolicy.config as well as rssrvrpolicy.config. Now, I have introduced a function in my assembly that requires reading some settings from a file....The error message I see when executing that fun...more >>

Hi I have a report which includes a table as follows table 1 table1_Group1 table1_Group2 In the footer of Group 1, I have a formula =Sum(Fields!INVOICED.Value,"table1_Group2") When I try and run the report, I keep getting the error "The value expression for the te...more >>

HI, I am actually a java developer .I have suddenly changed to RS. so i am very new to .net programming and ReportingServices. I am getting error like "HTTP 401 Error: Access Denied." I know i have to set credentials.But i don't know where i have to set i.e in which file i have to set. ...more >>

I have created a report to use a parameter, Case_Year, for the year accessing an Oracle 8i database. The parameter is set to a string. The database field the parameter would be used to query against is a varchar2. In the Data tab, I have tried using the parameter as @Case_Year or ?Case_Ye...more >>

I'm rendering my reports as PDFs using URL access. Each time the users render a report they are presented with a File Download dialogue box to either Open or Save the report. Does anyone know how to avoid this dialogue box and instead automatically open the report? I've done a search on her...more >>

Hi All, I have a report using a Matrix, showing Dimension Date/Time [Year, Month, Week, Day, Hour, 1/2 Hour, 1/4 Hour] On the other Dimension, i have 4 levels. I have some Measures and Calculated Members. The report uses the Drilldown in all levels. I inserted some Parameters in a D...more >>

i ve used SOAP API in my web application and thus generated the report in html giving user an opton to export the report to excel or PDF when user exports the report to excel it works perfectly but when it is exported to PDF as usual open/save dialogue box appear what so ever is the response a...more >>

Hi I have created a subscription. The schedule that it uses runs every minute. When I look at my subscription, its status stays at "New Subscription" although the Last Run Field changes. When I look in the shared folder into which the reports must be exported to from the subscription, t...more >>