rdlc

When to use RDLC over RDL reports?

I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main difference between RDL and RDLC. Searching for this information yields fragmented information ...

Is it possible to create a table of contents with page numbers for an RDLC report?

I have a fairly large report I'm trying to create as an RDLC in Visual Studio 2008. There are several sections that I plan to create as subreports and then compile them all into a master RDLC. However, one of my client's requirements is that it have a table of contents with page numbers indicating where to find the various sections of th...

SQL Reporting Services - Cryptic Warnings

I'm using reporting services in local processing mode. I'm setting the report data to a Dataset pulled from a sql database. When I come to render the report I get two warnings: The data set ‘PPA_Dev’ contains a definition for the Field ‘EMail’. This field is missing from the returned result set from the data source. The data set ‘PPA...

Displaying a Number in Words in SSRS

I work on VS05 C# window .In my rdlc report i want to show my group amount in word... like in my group i got the agount 1000 ...now i want to show that in word....but how? I know how to convert amount in word, but problem arise when i use it on my group....how to convert group amount in word in my need .......is there any built in method...

Report group Amount problem

Duplicate: This is an exact duplicate of Group amount in word. He's got a new user and the same name. Please close as duplicate. I work on C# VS05 Window. My problem is ,i can not show the group amount in word...For more clarification : WorkerID Designation Name CurrentSalary DueSalary 1 AC ...

Removing Unused Columns from a Bar Chart

I am creating a departmental bar chart that shows time frames for a set of tasks. Some departments share tasks, others are unique. I have the chart running except that I don't want all possible tasks listed for every department. I would only like to display those tasks that the department actually did. Here is an example of the data (#...

RDLC filtering nested tables

I am creating an RDLC report where the dataset consists of several datatables. There is one parent table and several child tables. What I would like to do is display relevant data from each child table for each row in the parent table. Here is a simplified example: table1 = "Purchase" has columns PurhcaseID, PurchaseNumber, PurchaseDa...

A few RDLC and ReportViewer questions

I've got a few questions about the ReportViewer control, when bound to what I believe is called a "Windows Report", although there seem to be a few flavours of this. I'm using a RDLC file, if that helps. I need to create reports, and populate, display and print them at run time. This is for a asp.net web app using VS 2005 and SQL Serv...

Multiple results in Subreport on RDLC causing Error

I have a report with an embedded subreport. The subreport has a table on it that shows a list of values and is itself embedded in a table on the main report. The problem I am running into is that when there is one result in the subreport, it displays and works fine. If there is more than one result, I get the "Error: Subreport could not ...

Dynamic Data in an RDLC Report Footer across Multiple Pages

I created an RDLC report (based on a stored procedure) that contains lists. I need to display data from one of those lists in the report footer across every page. However this data only shows in a list on the first page, so that is the only page on which it shows in the footer also. I’ve researched this but haven’t found much information...

rdlc excel export problem

i work on C# window vs05. Let me ask you a question here. If I export on RDLC report to Excel or PDF format, always have document map ? In the case of Excel, the generated .xls file will have two sheets: one holds the document map, and the other is the actual report. If you click any of the items in the document map, you will be take...

ASP.NET rdlc with external images not displaying images in PDF

I'm using the Microsoft ReportViewer that comes with ASP.NET and have a report parameter that should be setting the value (path) of an image in my report. I'm providing the path as a complete URL right now, starting with http:// but have also tried this as an app relative path, site rooted path, etc. and for some reason the image is alwa...

Project Reference in RDLC ReportViewer Report

I have a Visual Studio 2005 solution which contains two projects - a Windows Forms project in VB and a class library in C#. My VB project includes an RDLC report file. I have recently learned that you can add custom code and external references to an RDLC report. I would like to reference my C# class library from the RDLC file (which, ...

Bind child object property with in rdlc (Report)

I have a custom object say "objMain" in which i have few properties and also the property of object type (i.e. like a child object). objMain has these properties: 1. Name [type: string] 2. Description [type: string] 3. StartDate [type: datetime] 4. ObjSubject [type: object] - this is of custom type ObjAddress has these properties 1. S...

VS2008, reporting via RDLC gives problem with 2nd level objects due to lazy load

I have a report that tries to show Order.Customer.Address.Line1 in a report. My Order object comes from a Linq2Sql DBML file. In the report i define it as Fields!Customer.Value.Address.Line1, but it comes out as "#Error". I then tried "touching" the variable before passing it to the RDLC, and lo-and-behold it suddenly worked. Apparen...

How do I handle null nested objects in RDLC report that is bound to custom assembly object datasource?

I have an RDLC report that I am rendering directly to the Response Stream as PDF (rather than using the ReportViewer). In the code that renders the report, it's DataSource is bound to a List(Of ClassA) objects defined in a custom assembly. This seems to work for the most part. My problem is that I can't seem to handle the situation wh...

Reload and Refresh Report Viewer based on New RDLC File

I have written a C# program using VS 2008 that uses the built in Report Viewer and processes reports locally. When the report is being viewed I want to replace the current rdlc file with a new one and refresh the report without closing the report form that contains the report viewer. I have already checked to make sure the file is bein...

Printing from RDLC report to Dot Matrix Printer

Hi, I am trying to print a RDLC report to a dot matrix printer using Generic/Text only printer driver in windows xp. But the problem is that, I am not getting the proper output as I am able to see in the preview of the report. In the print preview the report the output is perfect. But when I print to the printer, some of the fields are ...

rdlc Expression Error

I am using iif(Field!test1.Value=nothing,"",test1.Value.ColumnName) It works fine if test1.value is not null. If it is null then i am getting #Error in my report. Is there something i am doing wrong? ...

rdlc report in pdf is not displayed correclty

I have one rdlc report and rendered it in a web page using microsoft's reportviewer control. This report contains mutiple tables to display records. When I export this report to PDF, the text in one table displayed over the other table texts (texts behind other texts). Is there any settings for the table to display it one below other? An...