rdlc

RDL 2008 Syntax Changes

I'm moving a .NET project from VS2005 to VS2010, and I've encountered a problem with some RDLC report files in my project. Using VS2005 RDLC reports, I was able to refer to the value of child objects within parent objects. For example, in a textbox I could use the following expression: =Fields!Customer.Value.FirstName & " " & Fields!Cu...

dynamically setting the width of a textbox in a RDLC(VS2010) report

VS2010 RDLC cannot using expression for textbox's width,How can i do this? ...

How to limit RDLC report for one page in a PDF

I have a RDLC report and I am displaying it on the Report Viewer Control in my front end application. I get the report perfectly and theres no problem in it. But the problem arises when I try to export the report to a PDF (using available option - basically the inbuilt option). I get the report in 3 pages whereas my client wants it to ...

Why can my precompiled web application not load the RDLC report?

I have a VS2008 Web Application project that is being pre-compiled without being updatable. When I try to load a page that should display an RDLC report using the ReportViewer, it just displays an empty page. It works fine in a non-precompiled version. What could be the problem? ...

Sql Server Reporting Services vs Reporting Via .NET Application

My boss wants me to create a few reports in the near future and I think he wants to use SQL Server Reporting Services to deploy the reports. I'm not so sure this would be such a great idea considering that we are a pretty small organization and I cannot see us making good use of or needing the features that this solution offers such as s...

Generate a rdlc Report using an Object not a Table or View

Hi All, I am creating a ASP.NET MVC 2 application where I want to generate a PDF report I have this code in my Report controller: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Mvc.Ajax; using System.Text; using System.Linq.Expressions; using Microsoft.Repor...

Formatting multiple fields at once in RDL or RDLC

Over the years, I've been working with SSRS reports (RDL and RDLC) but I have not found a solution to this problem: Let's say I have x number of fields in my report. I would like to highlight all the fields at once and modify the background-color, foreground-color, font and font size, for all fields at the same time. Is this possible...

Inserting a Word document content (with formatting) in a RDLC report using C#

Hello, I'm creating a RDLC report in C#. Is it possible to insert the content of a Word 2003 document (with formatting) in it (either in design time or programmatically) before exporting to PDF. The final result will be a PDF file containing the initial report (fields from database) and the Word document content following it. Why this...

RDLC table column width growing

I'm working with a report that has two columns in a group. It also has a sub-group that spans both of those columns and contains a list. The list contains a matrix. The purpose of this list is to build a horizontal table with some number of columns (http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/48de91f9-184...

Reporting Services - RDLC - Object Datasource with Child List for Subreport

Hi All, I'm creating an SSRS client side report (RDLC) and am using custom objects to populate the report. The report is an invoice report which has line items. The report datasource is a List<Invoice>. Each Invoice object has a List<LineItem> property that should map to the invoice line items on the report. This seems like it shoul...

VB.Net: How to use an Object data source in report (.rdlc)

My question is similar to this one but I'm having some problems with the actual implementation. I've got a report (.rdlc) in the business layer of a 3-tier app. I've got an object in the BL (EmployeeManager) which has a GetEmployees(Expression as Expression(Of Func(Of Employee, Boolean))) As IQueryable(Of Employee) method. As I didn'...

Using Microsoft Reports (.rdlc) in a 3-Tier app

Hi, I'm new to reporting so need some good information/resources to help me get some reports set up in our 3-tier app. We currently have: UI (ASP.Net MVC 2 at present but also winforms in future), Business Logic and DAL (Entity Framework - Code-Only ie no edmx) The BL has "manager" objects for selecting and manipulating entities. Now...

Subreport repeating problem in RDLC

Hi, any one pls help me, i have one RDLC report. It has sub report. I have printed my subreport with SubreportProcessingEventArgs. now its showing the correct values.But the problem is the same subreport repeating in main report. How can i overcome this problem? pls help me. ...

SSRS/RDLC Calculating SubTotal of an Expression

this is the desired result i needed. i had populated State(RowGroup), Male(ColGroup), Year(ColGroup) and the data inside the matrix. to calculate the data count total(100), i used the feature AddTotal by right clicking it. But in this report i have used expression to calculated individual Percentage. Expr1: to calculate the percentag...

RDLC Subreports

Is it possible to use an IIF statement to choose which subreport is used? I have two subreports, one of which is always hidden based on a report parameter, but an empty line still shows up when one of them are hidden. ...

Visual Studio 2010 RDLC: Support for HTML?

I've read rumors that with the Report Viewer component of Visual Studio 2010 Professional, it is possible to render HTML from the database into a report. Unfortunately, I wasn't able to find definite information online and I'd rather not buy the upgrade just to try it out. Can anyone confirm or deny that this feature exists, preferably ...

Distributing RDLC output as an email attachment

Our winforms application has long allowed a "print" option which basically uses RDLC. The customer has requested that we add a feature allowing users to send the "printed" output via email. Now, we know that an EMF file is created (in the TEMP folder) as a sort of hidden byproduct of our current printing process. Seems to us we can s...

Optimizing an RDLC report

Hi. I am using RDLC Reports and the report viewer control, and I am seeing that the more records there is in the final result the longer it takes to load. It sounds to me that the RDLC report loads all records at once (and caches them locally) even though it paginates it when sending to the browser. So I believe the solution should be to...

RDLC vs Crystal Reports vs Anything Else Free: I'm running Informix and using C# 4.0

I'm not sure which is the way to go for choosing a report type with my current setup. In the past I was using MS Server 2008 R2, MS SQL Server, MS.NET C# 3.5. Now I'm using something similar except my Database is IBM Informix and I'm using MS.NET C# 4.0. I'd prefer to use RDLCs since I'm used to them, but I didn't wanna jump down that a...

How to link multiple tables in VS2010 RDLC Reports

I have two tables which are linking together by primary key... as an example Genre ----- GenreID GenreDescription Track ----- TrackID GenreID TrackName I want to show like the following TrackID Name Genre 1 Track1 Pop 2 Track2 Pop 3 Track3 Rap 4 Track4 Rock How can I write custom SQL ...