Click here to Skip to main content
15,899,679 members
Everything / RDLC

RDLC

RDLC

Great Reads

by Nithesh AN
Printing an RDLC file in ASP.NET MVC3 automatically by converting into PDF and using Acrobat Reader.
by Jamal Seyedi
How to create print button for non-IE browsers in RDLC Viewers
by Tim Golisch
SSRS and Report Builder (or the old BIDS from 2008) are nice for making reports, but they don't embed into your ASP.NET project very nicely. This is one way to do it without the requirement for full SSRS (and the security hoops).
by santosh poojari
The intent is to try getting reportviewer like control in MVC razor by rendering RDLC report in View form. Moreover also tried to output report based on search filter criteria in MVC Razor.

Latest Articles

by Tim Golisch
SSRS and Report Builder (or the old BIDS from 2008) are nice for making reports, but they don't embed into your ASP.NET project very nicely. This is one way to do it without the requirement for full SSRS (and the security hoops).
by Nadir Muhammed
Creating an RDLC report by just binding a Dataset
by M. Rawan
direct print for microsoft report (RDLC) without preview
by Jamal Seyedi
How to create print button for non-IE browsers in RDLC Viewers

All Articles

Sort by Score

RDLC 

3 Apr 2013 by Nithesh AN
Printing an RDLC file in ASP.NET MVC3 automatically by converting into PDF and using Acrobat Reader.
12 Mar 2012 by Monjurul Habib
please follow below steps1. Create Report 1 , this is your main report.2. Create Report 2 , this will act as subreport.3. Now open report 1 and from toolbox drag the subreport control to this main report.4. Then Right click on the subreport control and configure it to Point to the...
24 Jun 2012 by E.F. Nijboer
How do you mean? After you placed the data at the bookmarks you could just call print on the WordDocument instance (assuming you use com interop). Technically you already opened the document when you started working on it.Good luck!
21 Aug 2012 by Prasad_Kulkarni
Try something by your side first Mohan!A simple search on google[^] with your question gives 180,000 results to me.Here is CP Article of same search:Using RDLC and DataSets to develop ASP.NET Reporting Services Reports[^]You can also try search on CodeProject[^] which gives you many...
6 Mar 2024 by Richard Deeming
It sounds like you're publishing your site as precompiled and not updatable: Precompiling Your Website (C#) | Microsoft Learn[^] The compiler seems to think your RDLC file is a page to be compiled, so it gets compiled into the .dll, and the file...
21 Jun 2012 by Vani Kulkarni
Hello Ujjwal, Please go through below links, see if they help:http://forums.asp.net/t/1717264.aspx/1[^]http://technet.microsoft.com/en-us/library/cc645968(SQL.105).aspx[^]http://www.sqlservercentral.com/Forums/Topic946001-1063-1.aspx[^]
1 Aug 2012 by Shingala Anil
I recently added SSRS Reports to our C# .NET application using SSRS 2008 R2 and ReportViewer 2010 (remote processing). When I view a report using any version of Firefox the "Report is being generated" message and progress spinner are not being displayed. Is this documented somewhere as a known...
1 Aug 2012 by Ganesan Senthilvel
Reason is, Browser displays SSRS report data thru IFrame. In Firefox, the IFRAME's height defaults to a few hundred pixels, so that you can see the top 2 inches of the report. In IE, IFrames automatically fixed to Data height, so it works fine in IE.To Fix the Issue in Firefox, you can try...
21 Aug 2012 by Prasad_Kulkarni
Please refer my previous answer:Bind Data in Datset to RDLC[^]..and more similar threads here[^]
21 Aug 2012 by Prasad_Kulkarni
Please refer similar QA: Bind Data in Datset to RDLC[^]and have a look on this article: Beginner's guide for creating standalone .rdlc reports with ssrs[^]
23 Apr 2013 by Sandeep Mewara
No. Not enough.You need BIDS to edit/update a RDL file. Once done, you need to redeploy it. Start from here: Creating an ASP.NET report using Visual Studio 2010 - Part 2[^]Following answers will also equip you with more information:How to view report created using SSRS from VB.net...
11 Oct 2013 by Azee
Hey Tanweer,Try setting AsyncRendering="true"and make sure you have done:if(!IsPostBack){} on your page load.Let me know if it helps.CheersAzee...
12 Dec 2013 by Dnyaneshwar@Pune
I have designed a RDLC report, in that i used a rdlc image control, bind the external image source to that image. If the imags is not available on the particular path then i want to display the alternate text..'Image not available'. I checked all the properties but not found the property for...
12 Dec 2013 by Dnyaneshwar@Pune
I have designed a RDLC report, in that i used a rdlc image control, bind the external image source to that image. If the imags is not available on the particular path then i want to display the alternate text..'Image not available'. I checked all the properties but not found the property for...
9 Apr 2014 by Schatak
fixed problem of decimal partPublic Function changeToWords(ByVal numb As [String]) As [String] Dim val As [String] = "" Dim wholeNo As [String] = numb Dim points As [String] = "" Dim andStr As [String] = "" Dim pointStr As [String] = "" Dim...
10 Apr 2014 by Schatak
First: In your Footer property set height to 0in. Second- don't use the build-in Footer. Instead, use a sub-report that will contain your footer details.Now, you need to define the sub-report as thin as possible in the main report (while in the actual sub-report - arrange your data as you...
15 Jun 2014 by Jamal Seyedi
How to create print button for non-IE browsers in RDLC Viewers
10 Oct 2014 by Mehdi Gholam
Read the following : http://stackoverflow.com/questions/14953294/how-to-get-running-sum-of-a-column-in-sql-server[^]
10 Oct 2014 by Maciej Los
Have a look at example:DECLARE @tmp TABLE(ID INT IDENTITY(1,1), aDATE DATETIME, Pallets INT)INSERT INTO @tmp (aDATE, Pallets)VALUES('2014-09-29', 4),('2014-09-30', 5),('2014-10-01', 6),('2014-10-02', 1),('2014-10-06', -2),('2014-10-07', 1),('2014-10-08', -3)SELECT t2.ID, t2.aDATE,...
2 Mar 2024 by Pete O'Hanlon
Try e->graphics->FillRectangle(Brushes::White, e ->PageBounds.Left - Convert::ToInt32(e->PageSettings->HardMarginX), e->PageBounds.Top - Convert::ToInt32(e->PageSettings->HardMarginY), e->PageBounds.Width, e->PageBounds.Height); instead.
2 Sep 2011 by md_refay
you can repeat table header & footer on each page by following theses stepsin the bottom of rdlc report window you 'll find row groups & columns groupnear columns group click the arrow && choose advanced mode then choose the row u want to rapeat in each pageyou 'll find it colored with...
15 Sep 2011 by htdu87
Hi, how i use ColSpan in Report Definition to merge cell in table in RDLC report? Thank!
26 Nov 2011 by Madzmar25
Hello guys... i would like to ask how to display the sum of the items in my report? well i know how to do the summation formula like =sum(fields!field.value) but using this formula i want it to display on every page... assuming i have 100 records and i have a field name expenses... now i want to...
27 Nov 2011 by thatraja
Are you displaying the data in Table or Matrix control?Using Sum Function[^] you can sum the data.Adding Table Data Regions[^]Adding Matrix Data Regions[^]Adding Data Regions to a ReportViewer Report[^](for other Data regions)Transfooter and Transheader functionality in RDLC(SSRS)...
22 Feb 2012 by Eduard Keilholz
Have you seen this[^] feature? I think it helps you a lot.I've also found a similar question on StackOverflow right here[^]
20 Mar 2012 by andrusha007
Hello vbguy, What I usually do is just wrap the whole content of the report body(including labels and everything) inside a List[^] element, and then assign the datasource to that list. This will iterate over all the elements of your datasource and you should have your report displaying...
20 Mar 2012 by Dev Kashyap
We have to add "file:" key infront of image's path.For example:-"file:" & Fields.Path.ValueIn this "file:" is a key to find the image file path on local computer andFields.Path.Value is a parameter which have value of image's .
30 May 2012 by Linto Leo Tom
Hi Azeeth,You can do it in two ways. Either you can check your conditions in your code behind. If evrthing is ok, thn only display the report. Or else you can write expressions for the visibility of the tables which you want to hide incase of your situations. This will load the report...
2 Jun 2012 by Tim Corey
There was a question similar to this that was answered in the MSDN forums. Here is that forum link:http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/30c901cc-759f-432d-905a-80467dd5e9aa[^]The accepted answer is not the one you want but rather the previous post by...
10 Jul 2012 by Sandeep Mewara
You need to create a parameter in report and pass the value to it at runtime in your code. This parameter can be set to display the assigned value during report viewing. Something like:List paramList = new List();paramList.Add(new...
1 Aug 2012 by Ganesan Senthilvel
As an alternative, you can try this solution.ADD the following code to the ReportingServices.css file (by default, it's found in "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles\"):
1 Aug 2012 by rohit24c
Hello, I have a Winform Application in which i have 2 separate rdlc's now on click of button i need generate the report with out reportViewer and to save the report as 2 separate .pdf files.Any suggestions please!
21 Aug 2012 by V Mohan
I have some data stored in Dataset. I need to convert those in RDLC . Previously i use MSChart Control to bind this . But Now i want to Bind this Dataset in RDLC . Pls anyone help. This is Very urgent
21 Aug 2012 by Hesha
Hi i just created RDLC for pre-printed paper. which means paper contains certain Space for each item. Ex : For Address : it has separate Space. problem is that in my RDLC i had to use Tab lix for display certain information.Number of Rows for that tablix coulb be get very according to the...
2 Sep 2012 by Chamara Eranda Sampath
Hi All ,I need to add sub report to rdlc report in visual studio 2010 with using c#if someone know how to do it, pls let me know.Thanks,Chamara
24 Sep 2012 by Manuele Camilletti
Dim arrPic as byte() = 'Load the image as array of byte''Convert byte() to BASE64Dim sIMGBASE64 as String = Convert.ToBase64String(arrPic))'Add the BASE64 stream to the parametersparamList1.Add(New ReportParameter(, sIMGBASE64)where sParamName is a parameter of the...
17 Jan 2013 by Vyacheslav Voronenko
Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full capabilities of SQL Server 2012 Reporting Serviceshttp://www.microsoft.com/en-us/download/details.aspx?id=29072[^]
20 Feb 2013 by Tisha Ahuja
Hi,I have a RDLC report in which i show a Bar Chart in the last column of matrix. But my problem is i dont want to show chart in the total row how could i achieve this please provide some good solution.Thanks & RegardsChinkey
5 Mar 2013 by Tharaka MTR
for this I recommend you to use the CROSSTAB query. In SQL PIVOT table.http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx[^]http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[^]try your self. If you have any question feel free...
29 Mar 2013 by ZurdoDev
A report is a report, and a report wizard is a wizard that walks you through creating a report.
3 Jul 2013 by Member 9700867
HI alImm using rdlc report for one form in my project.i need one help.im showing image in mt report.im taking it from mysql DB.i want one simple help.im binding photo from DB.if the image not coming in DB means i want to show image named "no image available"."no image...
3 Aug 2013 by Amar Kapadia
Quick Solution: Field Names in tables must not have spaces in them.Hello EveryoneI think I might know what is happening here. Indeed, perhaps all this stemmed from the Northwind40.sdf SQL Server Compact Edition 4.0 database file I was using. Again, I'm not sure how I got it but must be...
12 Aug 2013 by ridoy
See these discussions whether they can help you..Change-the-size-of-paper-in-rdlc-report.aspx[^]Reportviewer-paper-size[^]
12 Aug 2013 by Linto Leo Tom
You can do it directly from the menu bar.1. Go to the Report Menu.2. Select Report Properties.3. Select Layout Tab.There you can see the Height and Width boxes. Enter the dimensions you want.Happy coding :)
24 Sep 2013 by Molay Saha
Hello Everyone,I'm trying to show RDLC report in MVC and stuck with a problem. As I can't show RDLC in Razor page as Razor doesn't have ReportViewer, I took a web form (.aspx) view in my View folder structure. In aspx view I easily accessed ReportViewer. I'm using 'Code First With Existing...
7 Oct 2013 by bluesathish
Go to Solution explorer and remove all 'Microsoft.ReportViewer.WebForms references. Then Add the references from your latest directory (VS2008). Go to Build menu and Click clean solution and Click Rebuild solution.Regards,BlueSathish
11 Oct 2013 by tanweer
Hi every one, I am working on a project where I am using RDLC report, I want to use a master report for header and footer that contains some company informations and it binds with diffrent dataset and inside the main body of the report i have a subreport to show reports contents, this subreport...
7 Nov 2013 by Madhu Nair
I have solved this issue by adding multiple datasets in the the same report instead of having multiple sub reports!!!!
11 Nov 2013 by Sergey Alexandrovich Kryukov
Not enough information. Please see my comment to the question.All I can advice is: stop doing what you are doing and start using some Revision Control System right away. It could be open-source, free of charge, extremely light weight, unobtrusive and reliable. Please see my past...
27 Nov 2013 by ♥…ЯҠ…♥
Hi Folks,I got it resolved.When I try to fetch top 21 record, 21st record is overflow from the margin height.Now I adjusted height in the report now it works fine.Regards,RK
13 Dec 2013 by asalgadoscr
You can check the path in server side, send the result in a parameter, in the report you can set the property "Visibility" based on an expression, the expression will be something like "=IIf(Parameters!Exist.Value,true,false)"
21 Dec 2013 by yogeshkansete
Hello, I am trying to print rdlc report in my desktop application. I tried to pass the dataset value to reportsource but when the report execute it shows blank report.How can i solve this issue.
5 Feb 2014 by Dnyaneshwar@Pune
Suppose my stored procedure returns multiple datatable then how to manage that datatable in DataSet.xsd file
5 Feb 2014 by thatraja
Lucas Juan wrote:I see that there is another method which is using dataset. My problem is I don't use a database because I just print what it is in the screen that the user inputted. So I can't create a query for it. Is there any other way for me to solve this dilemma?You could use Dataset. To...
7 Feb 2014 by Dnyaneshwar@Pune
before adding datasources to report clear your datasourceReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.DataSources.Add(rds2);
8 Apr 2014 by Schatak
Error is in second line of your code.Dim numb as string = Convert.toString(val)just remove this line and it will work fine.
27 May 2014 by Dnyaneshwar@Pune
Use this code its working for me..http://www.dotnetspider.com/forum/316658-Reg-Convert-Amount-To-Words.aspx[^]
13 Jun 2014 by DamithSL
check below Answer how to make textbox font BOLD dynamicaly using expression in rdlc [^]
17 Jun 2014 by Abhishek Kumar (here to help!!)
HI,I've a windows application which gets deployed on client machines.The application comprises of few reports, and for that I'm using rdlc report in the same application.Now i need to access a public method from the same application in report to display calculated data.Since the...
30 Jun 2014 by Marcin Kozub
I hope this will help you:Reflection.Assembly TxAssembly = Reflection.Assembly.GetExecutingAssembly();// Full path to your report files with folders: Reports\MyReport.rdlc = Reports.MyReport.rdlcStream stream =...
18 Aug 2014 by ZurdoDev
I believe using the IsNothing function is what you'll need to use. It can test for NULL.See http://social.msdn.microsoft.com/Forums/en-US/cbed4e88-16d4-4d4b-821a-7a7e728c7e34/testing-for-null-in-rdlc-report-field?forum=vsreportcontrols[^]
18 Aug 2020 by Member 10924155
I have just started RDLC reports but this is freaking me out.I have a business layer class where a method returns a list of objects. I first created a report template (.rdlc file) and I mentioned that particular method. I got the fields in the object and I dragged them to the values portion...
14 Oct 2014 by Arora_Ankit
Use thisFormat(Now(),"MM/dd/yyyy h:mm:ss tt")
17 Oct 2014 by Santhosh Babu Mahimairaj
Try this..............http://stackoverflow.com/questions/17482345/how-to-deploy-or-show-a-ssrs-report-in-asp-net-page-using-c[^]Call SSRS Reports by using C#[^]
18 Nov 2014 by Hasitha Wijesooriya
This is My RDLC data table,CHINA,PEOP 8140969X 814096xx CAN8140887X 814088xx SHA8141451X 814145xx SHACAMBODIA 8139966X 813996xx PNHHONG KONG 8140533X 814053xx HKGI want to generate serial number(Using RDLC) like fllowing Table. CHINA,PEOP 1....
27 Apr 2015 by Sergey Alexandrovich Kryukov
These days, I strongly recommend the only legitimate and really good setup tool, first Microsoft Open-Source project: WiX Toolset:http://en.wikipedia.org/wiki/WiX[^],http://wixtoolset.org/[^].Not only it is open-source, this is the project fully compliant with MSBuild project standard....
17 May 2015 by Santhosh Babu Mahimairaj
Refer this https://www.simple-talk.com/sql/reporting-services/reporting-services-with-style/[^]
8 Jul 2015 by Member 11822294
Hi,I have a Parent report in which I have included 3 Sub-Reports.My Question is : Can I Hide the Sub - reports pragmatically on some condition?I want to change the visibility of the Sub report depending on some drop down control value located on the parent report.I am using...
17 Aug 2015 by Maciej Los
Have a look here: SSRS - How to continue data to next column?[^][EDIT]how to create a multicolumn report (Microsoft Report Viewer) in Visual Studio[^]
25 Aug 2015 by Member 11110990
In my app MVC2 application, i am creating PDF file using RDLC report. RDLC report creation and preview is working fine.If user clicks "Print" button , i want to create PDF file and print the PDF file in client side printer.Is any option for that?i want to print the PDF file in client...
12 Sep 2015 by Sreejesh T J Nair
Custom Print Functionality for Microsoft Report Viewer (RDLC)[^]
4 Mar 2016 by SathishRam
i want to display particular data in last page in RDLC Report(.pdf).i need expression to write in body not in header and footer. Or Can please give an idea to set group properties in FooterWhat I have tried:I tried in surfing net i get visibility expression in footer not in body .i got...
17 Mar 2016 by Salman622
use the below step hope it will help you1. while retrieving your data use nullif(ColumnName,'0') so that in your result set zero values would be null2.right click on your column in rdlc select column visibility.3.select Show or hide base on an expression4.use expression...
19 Aug 2016 by Karthik_Mahalingam
remove the square brackets and try parms[0] = new ReportParameter("parameter_name", TextBox1.Text);
2 Sep 2016 by Richard Deeming
Formatting Text and Importing HTML[^]:The following is a complete list of tags that will render as HTML when defined as placeholder text:Hyperlinks: Fonts: Header, style and block elements: , , ,, , , Text format: , , , List...
18 Sep 2016 by koklimabc
Have you using Table inside "RDLC",if "Yes, right-click to choose "Tablix Properties"-"General"-"Page Break Options", choose "Keep together on one page if possible".Besides this it is better to change the report layout to be "Landscape" ("Under Report Properties") to fit the widest column...
30 Sep 2016 by Dave Kreskowiak
Find a monospace font that has the boxes drawn around the letters already.
7 Jul 2017 by Richard Deeming
Select the group; Open the properties, and expand the "Page break" property group; Set the BreakLocation property to StartAndEnd; Set the ResetPageNumber property to True; Report Design: Reset Page Number on Group – Robert Bruckner's Reporting Services & Power View Blog[^]
26 May 2018 by RickZeeland
See example here: How to add an external image in RDLC Report (C#)[^] You can save the image first like this: pictureBox1.Image.Save(@"C:\Temp\Mypic.jpg",ImageFormat.Jpeg);
25 Oct 2018 by Richard Deeming
Use the NuGet package to reference the report viewer control in your application. All of the required files will then be copied to your bin folder, and can simply be copied to the target machine. NuGet Gallery | Microsoft.ReportingServices.ReportViewerControl.WebForms 150.900.148[^]
20 Dec 2018 by CHill60
The simplest way is probably select top 100 ROW_NUMBER() OVER (ORDER BY [object_id]) from sys.all_objects
21 Dec 2018 by Maciej Los
Check this: Display Serial Number (Row Number) in RDLC Reports[^]
4 Feb 2019 by Maciej Los
As is stated here[^] and here[^] there's no simple way to create dynamic columns in RDLC report at runtime, becuase an RDLC file is bit complicated XML file. Seems the only way to achieve that is to change to RDL. For further details, please see: Report Definition Language (SSRS) - SQL Server...
18 Apr 2019 by MetalKid007
I'm pretty late to this, but I have a real solution and can explain why! It turns out that LocalReport here is using .NET Remoting to dynamically create a sub appdomain and run the report in order to avoid a leak internally somewhere. We then notice that, eventually, the report will release all...
18 Apr 2019 by MetalKid007
I'm pretty late to this, but I have a real solution and can explain why! It turns out that LocalReport here is using .NET Remoting to dynamically create a sub appdomain and run the report in order to avoid a leak internally somewhere. We then notice that, eventually, the report will release all...
26 Mar 2020 by Richard Deeming
If you want to give the users a tool to edit the report, have them install Report Builder: Download Microsoft® Report Builder from Official Microsoft Download Center[^] If you want to build your own, that's a massive project, and far too broad...
2 Aug 2020 by Sandeep Mewara
You need to add a 'Total' row at the bottom of your report design instead of a column. Refer: Sum of Column Values in Reports Automatically Using Expression in .NET[^]
12 Jan 2021 by thatraja
You can write custom function for that. Below one has sample code with screenshots which's simple. You need to customize code based on your requirement Aggregate functions can be used only on report items contained in page headers and footers :...
7 Jan 2022 by Dave Kreskowiak
That error means you're trying to call a method or get/set a property on a object that is null, meaning that object doesn't exist. You haven't shown the code that's throwing the error, so this is about the most you're going to get for an answer....
1 Sep 2011 by md_refay
This is my first use for RDLC in vs 2010.I used to work on it on VS2008, but it's different on vs2010.I have noticed that when you drag table to RDLC it creates a default group with header & no footerI create group in my table, but I need report page header & footer that repeat each page,...
15 Sep 2011 by Sharma Richa
Hello AllI am using rdlc reports in my project. It was working fine.But I am using sub report and it is working fine on my local server. But giving error on server.An error has occurred during report processing. Exception has been thrown by the target of an invocation. A...
15 Sep 2011 by Pradeep Shukla
Data for the subreport is not supplied properly.The connection with SQL may have issues and that's what seems to be the reason here. Verify these two settings:1- Check the reportdatasource object is configured properly (connection string etc..) 2- The datasource of the subreport is...
4 Dec 2011 by Honey Jagyasi
Hello,I have a RDLC report where I need to do the addition the time in hh:mm:ss format.Values are as under :suppose time to complete a task is (1st task) 01:00:00(2nd task))+ 01:10:00 ------------Total = 02:10:00Please help me to calculate it.Also i want the...
3 Nov 2011 by shijuse
HiI have written a code like below, my problem was sometimes I am getting same color for different segments in the piechart if the value came from the same range. my code sample=SWITCH(Fields!ID__Share_of_Costs.Value
3 Nov 2011 by lukeer
A pre-defined enumeration? Not that I know of.You could create your own.Or find a way to use the struct System.Drawing.Color. It contains many pre-defined colours.Or you could process colours from their (R)ed (G)reen and (B)lue fractions in some fashion that subsequent colours are far...
15 Nov 2011 by Sharma Richa
HelloI am using .rdlc report. I have to generate pdf with dynamic names from my report.For this i am using DataView dv =(DataView) ObjectDataSource2.Select(); String st = ""; DataTable tb = dv.Table; if (tb.Rows.Count > 0) {//assigning...
21 Nov 2011 by jaideep06.jd
hi i am making a report in rdlc and i need to pass parameter in page header.That Part i hv done but the prblm is that i passes parameter value through query string.my queryString returns value like 1,2,3 and i need my report header to display value single value instead of whole query...
23 Nov 2011 by jaideep06.jd
i hv to add columns at runtime depending on conditions and managing the width of column at runtime.hw cn i do this ??
25 Nov 2011 by thatraja
Here you goHow to dynamically add new columns to report created with Reporting Services?[^]
27 Nov 2011 by thatraja
Why did you guys never come with complete details? Here you mentioned only partial error message. Anyway your friend(think so) asked the same question 7-8 months ago, check itAn error occurred during local report processing.....[^]