Using reporting services 2005. I have a set of reports that use a custom assembly for some basic calculations. It has been deployed several times in the past successfully. I am trying to install the reports and assembly on a new instance of SQL Server, and the repors work fine as far as pulling back and displaying data. The only prob...
I'm trying to generate a list of available reports from an SSRS 2008 installation, using code as below: ReportingService2005 rs = new ReportingService2005(); rs.UseDefaultCredentials = true; CatalogItem[] items = rs.ListChildren("/", true); foreach(CatalogItem ci in items) { if (ddlReport.Type == ItemTypeEnum.Report) ddlRepor...
Hi I am trying to create a report and am looking to pull out some information from a table 'contact'. I am trying to pull out the 'advisor' relating to the contact and a count of contacts who have that advisor based on a set of criteria. This is fine and works, however, I want to pull out a third column which is also a 'Count' based on ...
Hello, I have a report (in SQL Server Reporting Services 2008) that has multiple parameters, but works very well. However, one of my users (my boss, of course) wants to be able to e-mail a link to the report using the parameters they have specified. They do not want to send the report itself, but just a link to it. However, as you se...
Hi, I have a Web Service that i have created using C# and Visual Studio 2010. The definition is below. [WebService(Namespace = "http://targetrocksoftware.org")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // To allow this Web Service to be called from script, using ASP.NET A...
After upgrading our report server from SQL2008 to SQL2008 R2, one of our complex production reports will no longer work properly. This report has several parameters such as selecting all data or a specific group of data, and selecting summary data only or detail along with the summary. Since going to R2, if we select a small group detail...
The stored procedure mapped to a report query builder returns values dynamically mean to say once 8 columns and sometimes 6 columns. My question is how to name the header for the extra added columns? ...
Hello...I have a Report in SSRS VS2008 that needs to run a Stord Procedure from Oracle. In the past I have run functions from Oracle that return tables in order to display the data. As well as straight forward SELECT statements For example: select * from table(MyFunction(:parm1, :parm2)) select * from MyTable I have not run a Store...
In my report I m able to see all my data when running query in data tab...but in preview i see a blank page...I have four parameters in my query.. I tried deleting .data files also...no luck.. any suggestions are at great help?? ...
Hi, Is it possible to filter a named query in a reporting services data source view on the global user ID? I would like to do something like select UserName, ContactNumber, Email from Users WHERE (Users.UserName = User!UserID) so that it returns the name and contact details of the user running the report. Any help would be much apprec...
I have a simple .NET 4.0 web forms app that references the Microsoft.ReportViewer namespace: <%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %> with a simple ReportViewer control on a page: <rsweb:Re...
Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and each column is a field in a form for that person. The fields themselves are dynamic (and implemented as column groups on the matr...
The below report is currently written using linq to entities to get the data and building an html table in code. I'd like to rewrite it using SSRS and need some advice. All of the data is in the same table. There will also be date range parameters. Here is the basic template for the report that is needed. Categories 0-30 31-60 ...
Hi, I have an ssrs 2005 report, the report has two groups and one nested table inside of a group, the report is displayed correctly in VS as two pages, but when trying to export it to PDF i get 17 page and the only correct pages i get are in the end of the PDF file, so anyone b4 faces such issue? Thanks ...
Hi guys! If the table is: Month 1 2 3 4 5 6 7 I need help how to convert it into Month January Februari May etc... The data needed to be converted as a expressen code in the reporting designer interface. // Fullmetalboy ...
Hi, by default the recycle time for reporting service is 720 minutes (12 hours). It is the reportserver.config file 720 Now it happens every 2 o'clock. so consequently, it happens twice a day 2 AM and 2 PM. Now the problem is we cannot have it recycled during business hours (2 PM). how do I set this to occur only @ 4 AM? thanks ...
Hi, I have a matrix in a report that returns five rows. effectively this r1 | s11 | s12 | s13 | s14 .. r5 | s51 | s52 | s53 | s54 I need to add a sixth row that computes a value based on the values in row 1 and row 5. r6 | s11+s51 | s12 + s52 | etc.... Is this possible and if so, how do I do it? ...
I'm running SQL Server Reporting Services 2008, with Custom Authentication, and without IIS. Everything works (Report Builder, Report Server, Report Manager, etc), with one exception. I can upload arbitrary files (via Report Manager), but I can never download them again via the Report Manager (http://server/Reports). I am able to downloa...