reporting-services

Producing a Form from an Overlay from Reporting Services rdlc Reports

I am not sure what you call it in other technologies, on the IBM i (or iSeries) we call it overlays. The overlay is an image of a form that is stored on the server then a program generates the form with fields from the database so you can eliminate preprinted forms. I had a problem last year with the method I was trying at the time. It ...

SSRS 2008 Interactive Sorting in Sub-Report not working as expected

I have a (parent) report that has a list. The details group of this list contains one sub-report. So basically if the list has 10 records (rows) the sub-report is executed 10 times. The problem seems to be with interactive sorting in the Sub-Report. It has 4 columns with interactive sorting enabled. When I run the parent report and try ...

Code Access Security in Reporting Services 2008

Hi I have a Delivery Extension running inside Reporting Service 2008. It has been running fine for a long time. But now I want to make an insert into a database from within the extension. First error I got, was this: Exception: System.Security.SecurityException Exception Message: Request for the permission of type 'System.Data.SqlCli...

transaction log shipping sql server 2005 to 2008

I have a reporting setup with SSRS on our sql server 2005 database. Because sql server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our prod database. Unfortunately when I run our weekly check reports the web interface constantly times out because the server cant do the conversion to PD...

How do I get TFS 2010 to enable Sharepoint portals and reporting?

Ive tried EVERYTHING. I have installed multiple times combinations of SQL 2008 R2 + Sharepoint 2010 Foundation/Server and VS2010. Is there something special I need to do to get VS 2010 to realize that there is Sharepoint 2010 + SQL 2008 R2 on my box and to enable reporting and TFS sharepoint portal ? Maybe the option to enable it is ...

SSRS footer item wont format correctly

I am using SSRS with Visual Studio 2010. I have a cell pulling to a footer text box using the value: =ReportItems!GuarantorBalance.Value I CANNOT format the cell in the footer with the currency format. I tried every which way to format the text box but it never pulls the currency value. If I try to format the account number in the foo...

SSRS Report Manager Report names

Is it possible to have SSRS's Report Manager display a report name that is not the .RDL file name? I.E. I have a Report .RDL named "MyReportAboutSomeImportantStuff.RDL" but I want the Report Manager to display this user friendly as "My Report About Some Important Stuff." ...

Error while rendering .rdl file into pdf format

I an generating reports using SQL Server reporting services. I have generated a report and have put .rdl report file in the "E" drive. Now, when I am going to render the .rdl report file into pdf format,I am getting the exception : - "An error occurred during local report processing." The stack trace is follows : - at Microsoft.Report...

How to create textbox in Microsoft Reporting Service?

I have create a report in Microsoft Reporting Service that is presented in a browser. I would like to create button that opens a textbox where the user can fill in text. This text should be saved in column in the underlying database. ...

List problem in Reporting Services 2005

Hi, I have a problem with a list in srss 2005. The list is grouping too much information and I dont know how to un-group it. I made a picture to show it. But because I'm new, I can only show it with this link: http://img32.imageshack.us/img32/6058/listproblem.gif So the list is also grouping the weeks, but that is not what I would lik...

Render an asynchronous report, wider than the screen, without extra scrollbars

I have an asynchronous local SSRS 2005 report that is of variable height and width, but routinely is bigger than the screen. I want to render it full size so that some of the report renders off screen and the only scrollbars the user sees are the ones on the browser window. What is the best way to accomplish this? The only method th...

Reporting services subscription reports errors, but logs don't give details

Where can I find more detail about my subscription errors. I have a data driven subscription, showing status: Done: 24 processed of 24 total; 24 errors. but my trace file ReportServerService__xxxxx.log does not show any errors. It does show the subscription ran, but just no errors. My server DefaultTraceSwitch set to 3 and also trie...

Pre-built UI components for displaying SSRS Local Mode Parameters

BACKGROUND Am writing a WinForm app that uses the SSRS Report Viewer control to render reports in local mode - there is no SSRS server involved at all I can successully create and execute reports in local mode What I want to do is add Parameters to the report THE PROBLEM When the Report Viewer control executes a report in local mod...

ReportViewer Error When AsyncRendering set to false

I have problem using reportviewer with asyncrendering set to false, the report showing this error message: "The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly ...

Group keywords by site

I am finding a lot of useful help here today, and I really appreciate it. This should be the last one for the day: I have a list of the top 10 keywords per site, sorted by visits, by date. The records need to be sorted as follows (excuse the formatting): 2010-05 2010-04 site1.com keyword1 apples wine keyword1 visits ...

Does RDLC fire any events when binding to a datasource?

In Microsoft ReportViewer Web server control I have a report in RDLC that "binds" a table to a datasource. Are there any events fired that I can hook into on each cell/row so that I can programmatically set formatting properties for each row/cell in my c# code? ...

Integrate Access report

How can I integrate Reports done in Microsoft Access in my WPF application? ...

how to stop animated GIF once report data is returned?

Hi all, I can't find the answer anywhere, and the particulars are driving me crazy. I've been tasked with updating an older application, using only javascript for client UI stuff. Reports used to be generated using PDF templates and manually looping through datasets and basically doing a form fill, then displaying the report. This ha...

Can't find SSRS anchor property

I have a table1 in a table2 and I need table2 to be anchored to the top-right corner of the containing area in table 1. This would be useful since I need to hide parts of table2 depending of an element in table1. I can't find the anchor property. I originaly intented on using subreports, but since the child cannot return data to the par...

How to pass parameters to report model in Reporting Services

I'm developing report in RS that show top N customers based on some criteria. It also allows to select number of customers and period of time. Is it possible to do it by using report model? Thing that it seems to be difficult is how to pass parameters determined by user. Another thing that in my oppinion is very disappointing is that i...