Click here to Skip to main content
15,890,438 members
Everything / Reporting

Reporting

reporting

Great Reads

by Olga Tabulov
Ever tried to put a break in the textbox of the rdlc report? \n and such don't work...
by Sunasara Imdadhusen
MS Test Result Viewer is a free open source library to convert MS Test result (.trx) file into HTML. It is also allowed you to perform MS Test on your test container project (.dll) file. This utility will work with simple command line arguments to generate test report in HTML format with excellent U
by Maxim Kurayan
EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source
by Justin Shepertycki
Using Entity POCOs as a DataSource for your Crystal Reports

Latest Articles

by Bert O Neill
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
by JBartlau
In this article, we discuss how embedded reporting tools like List & Label offer advanced design and formatting capabilities, enabling users to customize the layout, font and formatting of Pixel-Perfect reports.
by JBartlau
Integrate List & Label into existing ASP.NET MVC app
by JBartlau
List & Label and some of their key features and benefits

All Articles

Sort by Updated

Reporting 

N 29 Apr 2024 by Bert O Neill
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
30 May 2023 by Member 13010813
I'm trying to pass the custom Id in multivalue parameter.Basically by defualt multivalue parameter accepts only index like 0,1 and its return data on base of that index but my current SSRS requirement that to use the custom ID in multivalue...
17 May 2023 by mtoha
At my case, you should install chinese keyboard, to type chinese characters. At textbox at RDLC, you can select SimSun font. Like this picture https://live.staticflickr.com/65535/52906143304_e0f58c375e_b.jpg[^] After I generate the report,...
15 May 2023 by Member 9346617
I want to display chinese characters in report (rdl) in C#. I am getting the text from database and showing the same on report. in database, I can see the chinese characters properly without any issue but they are not getting rendered on UI. On...
8 May 2023 by JBartlau
In this article, we discuss how embedded reporting tools like List & Label offer advanced design and formatting capabilities, enabling users to customize the layout, font and formatting of Pixel-Perfect reports.
4 May 2023 by Member 11811771
I had worked with RDLC report in my project previously. When I am using it for the second time the report viewer window is not coming on the screen, only in the bottom it is showing as reportviewer1. What I have tried: I am using Visual Studio...
18 Apr 2023 by JBartlau
Integrate List & Label into existing ASP.NET MVC app
26 Mar 2023 by mmd20092010
I'm using the following code trying to SetParametr : var report = new ReportParameter[1]; report[0] = new ReportParameter("MyName", "Raha"); var reportDataSource1 = new ReportDataSource { Name = "WpfApplication17_User", Value = _users }; ...
26 Mar 2023 by Member 14115736
Hi. I had the same error and the problem was with NULL values from SQL. Check if you have null values in your SQL result. I lost two days searching for what is not ok with "The report definition for report '' has not been specified".
17 Feb 2023 by JBartlau
List & Label and some of their key features and benefits
6 Feb 2023 by Venkat Chaitanya Kanumukula
Tableau is one of the powerful reporting tool which is on the market for over a decade. Here's a quick tour in designing BI reports with Tableau using Microsoft Dynamics AX 2012 R3/ Microsoft Dynamics 365 Finance and Operations.
6 Feb 2023 by JBartlau
This article provides an overview of Visual Studio's integration of combit's report generator List & Label.
3 Feb 2023 by JBartlau
This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.
1 Feb 2023 by JBartlau
This article sheds light on why it is useful to combine different data sources in a report.
2 Aug 2022 by Maciej Los
To create another table you have to call Tables.Add(Range, Int32, Int32, Object, Object) Method (Microsoft.Office.Interop.Word)[^] Assuming that you have a 9 paragraphs, you can insert into them 9 tables: //on the top of file using Word =...
2 Aug 2022 by Manojkumar-dll
I want to add 9 tables in my word file while try the below code it only adds rows instead of a table in my report automation how to do it What I have tried: private void CreateDocument() { try { ...
24 Jun 2022 by Siva Tech
You can download using below link https://www.crystalreports.com/download/
28 Mar 2022 by Member 13950809
I Have Query in Access Database with Param I need to add this Query to Report of C# and pass the Value of Param from The Form OF C# What I have tried: I Have Query in Access Database with Param I need to add this Query to Report of C# and...
12 Dec 2021 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).
2 Nov 2021 by Grid-Code
Good Day Have a win Forms app developing, SQL Database then DSR.xsd Dataset for report Export Data from Datatable to DSR Dataset - No issues there Can Get Data into ReportViewer Datatable for parent Report but Not able to Get Sub-Report Data...
18 Sep 2021 by RickZeeland
Take a look at FastReport here: open-source-reporting-tools[^]
18 Sep 2021 by Richard MacCutchan
asp.net report designer - Google Search[^]
3 Sep 2021 by swissmawi
This is not possible with SSRS Reporting Services and RDL/RDLC. There is an expensive (in terms of CPU) and hacky way to do this by hand: SSRS: Right and Centre Align Images in a Table | Magnetism Solutions | NZ (Auckland, Wellington,...
24 Aug 2021 by swissfritz
I'm working on a project that has to deliver reports in English and German languages. The English version works fine locally on my machine and also fine on the website. The German version works fine on my machine but not on the website: It gives...
24 Aug 2021 by A Lefever
you can read Running a RDL/RDLC (SQL Report) in ASP.NET without SSRS[^]
24 Aug 2021 by swissfritz
Richard's and A.Lefever's answers have pushed me in the right direction, thanks a lot! If the English version works and the German one doesn't, there must be some error in the remote DB. So I tested the first 20 of the 33 stored procedures and...
24 Aug 2021 by A Lefever
Are you using the english data-names in the german version?
12 Aug 2021 by Asif 7969814
HI, IF you are creating a web application and want to make simple reports DataTables.net is a good free tool for you it has export to Excel pdf and csv attribute column filter and a lot more. you can explore all examples of this by that Link I...
11 Aug 2021 by Member 14169626
Hello, I want to create a table format according to my sql queries with the reporting tool and show the reporting results. How can I create a report by drawing a view and giving the parameter with a sql query? I use reporter to c# programming...
4 May 2021 by Member 14909399
Ok! hi! So, this could be a little bit large... I have a store procedure that returns this table: Img1 I colored for the explanation: columns in yellow are data for the headers, and columns in green are the detail rows for every header. the...
13 Feb 2021 by Luc Pattyn
Putting Textbox1.value inside an SQL query string does not make any sense: the query gets executed by the database, which can't access your textboxes. The logic I would suggest goes as follows (in pseudo-code!): DateTime now=DateTime.Now;...
13 Feb 2021 by kyrons
I want to filter age range based on two (2) textboxes value I have two (2) textboxes in a form, the first textbox is for beginning of range and second is for ending of range (e.g. 45(first textbox) to 60(second textbox)).A report is containing...
8 Feb 2021 by Amit Sharma (Patna)
I am using Crystal Report IN MVC 5 but it throw an error that is. 1. Make a simple file test.rpt with using of Repository and want to show only PartyCode and PartyName 2. Following is code in action: using...
8 Feb 2021 by thatraja
You need to set dynamic DB Logon at runtime. Refer these C# Crystal Reports Dynamic Logon parameters[^] Sample article Bind Crystal Report In ASP.NET Application And Export In PDF And Excel Format[^] Other fix threads c# - Failed to Load...
15 Jan 2021 by The Cool Cat
Try this, I use this in External Images for RDLC. Just initialize the image parameter like a normal string parameter, and set the Me.ReportViewer1.LocalReport.EnableExternalImages to TRUE Dim ImgParam As New ReportParameter("ImgParam", "") ...
15 Jan 2021 by mirzamujib
Hi,I've problem in displaying image on my rdlc (Microsoft Report Viewer) report. I took picture box on my report and made its properties as SOURCE=EXTERNAL, VALUE=Parameters!Path.value where Path is my Report Parameter.Below is the code to display image on Report load event:Dim...
4 Jan 2021 by Member 14479145
Hi All, I am having issue while exporting rdlc report containing Unicode characters to pdf. when exported the data in Thai shown as garbage as below- üĺüľ it is actually ลูกค้า Data is showing correctly on webpage but when exported is show...
4 Jan 2021 by thatraja
This thread might help you. .net - How to embed a Font in a PDF with RDLC - Stack Overflow[^] For reference Exporting to a PDF File (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs[^] Hope you installed required font in...
30 Nov 2020 by André Marcos (Advisor)
Hi guys, Is it possible to put more than 2 formal authors in a article? How can I to do this? regards, andre.marcos What I have tried: i'd put this information into the text body. but is is a bad way cause i cant collaborate like a...
30 Nov 2020 by OriginalGriff
Edit your article, and look at the top of the document - under "A descriptive title" is the "By" list, which is initially just your username. Beside your name is a small "+" - click that and it'll open a text box with a tip attached: "Enter the...
15 Nov 2020 by Glorious007
When i am using Bangla Fonts SutonnyMJ font in RDLC Reporting .here some character missing.but MS Office word write correct . ScreenShoot What I...
23 Sep 2020 by Seesi
This worked for me. var report = new StiReport(); report.Compile(); // Set report parameters or variables var parameter = new Stimulsoft.Report.Dictionary.StiVariable("variableName","variableValue"); report.Dictionary.Variables["variableName"] =...
23 Sep 2020 by Reza Alipour Fard
HiI have a report in windows form application that it's designed by Stimulsoft report generator. My report get data from MySQL database by a stored procedure.My stored procedure has a parameter as PersonalCode and my report has a parameter with same name.I want load report file and pass...
11 Jun 2020 by OriginalGriff
This is one of the most common problems we get asked, and it's also the one we are least equipped to answer, but you are most equipped to answer yourself. Let me just explain what the error means: You have tried to use a variable, property, or a...
11 Jun 2020 by Member 14779968
I am not sure why I am getting one of my variables testlog is null. I am able to initialize and start the test but at the teardown method in my test class its not able to flush the reports and log it because testlog is null.. Any help would be...
15 Apr 2020 by Member 14779968
Currently I have configured Extent report for my test cases. I have several projects under my solution. I am generating the report in "Reports" folder that i created in each project. However I want to know How can I store this in one common...
24 Mar 2020 by Don Burton
Hi All - Does anyone know of a source for downloading Crystal Reports 2011? I'm at a company who have "misplaced" their copy. I know it's ancient technology but its what all of their reports are in. SAP does not carry it anymore. So says their support folks. Thanks in advance. What I...
26 Jan 2020 by RickZeeland
If you need version 12, download from here: Download MICROSOFT® REPORT VIEWER 2015 RUNTIME from Official Microsoft Download Center[^] If that does not work you can try a newer version from: NuGet Gallery | Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1400.0[^]
26 Jan 2020 by hungubhai
I get following error while adding reportviewer to Winform Error message is: Failed to create component "ReportViewer" the error message follows 'System.IO.filenotfound Exception: Could not load file or assembly 'Microsoft.reportviewer.common.version= 12.0.0.0,...
29 Dec 2019 by Lokesh Godem
Previously I'm using "telerik reporting" tool for generating reports, now I would like to use "Telerik ReportDesigner" tool, as a part of that I need to convert my previous reports. Is there any ways to convert telerik reporting reports (.cs extension reports) to telerik report server reports...
5 Dec 2019 by Member 14679544
Hi, I created a .net program in visual studio which runs locally in my company and stores data in an access database. I have been using crystal reports to create summaries and graphs of the data stored in the database, but I find the reports to be very limited in terms of the type of report it...
5 Dec 2019 by RickZeeland
Maybe one of these: best-and-fastest-graphic-controls-for-wpf-c[^] Or one of these: best-open-source-reporting-tools[^]
4 Dec 2019 by Member 14678256
How do we make this report work on older version of reporting ? You need to make 2 changes in to the RDL file to get it working. 1. Open the RDL file using notepad or other editing tools ,you will find something like below in the beginning of the code. image change the version from 2016 to...
4 Dec 2019 by Sarath kumar.N
Dear All,I have created one report in visual studio 2010. While running the project the system showing following error."The report definition is not valid. Details: The report definition has an invalid target namespace...
21 Aug 2019 by Maciej Los
Initial note: i think the answer to your question is opinion and experience based only. Quote: - What is the preferred way of handling this kind of situation? Well, there are possible two ways to store dates in a database: 1) UTC time or 2) DateTime + Offset The second method is recommended...
21 Aug 2019 by Ramakrishna.Pathuri
There were quite a few questions about saving DateTime & timezones info in DB but more on the overall level. Here I'd like to address a specific case. System specs We have a CRM system database It is a multi-tenant system where tenants can use setting his timezone (it is setting but single...
20 Jun 2019 by TheKhanSoft
Hello there, I have created an App in C#, wherein: I wan to update Crystal Report dynamically. For this purpose, 1. I have created a DataSet (item in solution) 01 - Items.PNG - Google Drive[^] 2. Added/Defined Tables, one of these tables is "PersonalInfo" 02 - DataTabe (from DataSet).PNG -...
8 May 2019 by Ali Majed HA
I have a report in Stimulsoft Report.There are headers and footers that I want to repeat in all pages, but it doesn't. I have noticed that Stimulsoft doesn't break the pages, so it count them as 1 page and so there are just one header and footer. I have uploaded a picture in my dropbox account:...
21 Mar 2019 by ibrahim karakira
Problem: I am using the printer zebra LP 2844 to print labels that I created in asp.net as microsoft Report. The Report has the size: width:7.5cm and height : 5 cm. when I use the print button in the microsoft report viewer it automatically sets the orientation to landscape mode switching the...
21 Mar 2019 by Keerthi_Siri
Here is the solution, Simply create the report as you wish and add following code before opening the report in ReportViewer. Dim ps = New System.Drawing.Printing.PageSettings() ps.Landscape = False ReportViewer1.SetPageSettings(ps) Me.ReportViewer1.RefreshReport()
4 Mar 2019 by Mahmod Abu Jehad
Hello everyone, i have a problem and need to help please, my problem is when add a dataset to sub report and run the application showing the message below: Data retrieval failed for the subreport, 'Subreport2', located at: ###Path###. Please check the log files for more information. some...
13 Feb 2019 by Member 14149215
0 hi i want to show value of the previous record in new record g1 = if {Mah.Mahf1} "" then (tonumber({Mah.Mahg1})/1000 ) * tonumber({Mah.Mahf1}) ... g2 = if {Mah.Mahf2} "" then (tonumber({Mah.Mahg2})/1000 ) * tonumber({Mah.Mahf2}) to g30 {Mah.Mahf1} is price {Mah.Mahg1} is...
13 Feb 2019 by Gerry Schmitz
You "pre-join" the "current and previous" records that go into the report. You need to come up with a query to do that (using sequence numbers), because most report writers can't.
2 Feb 2019 by OriginalGriff
The whole idea of a PrintDocument is that the PrintPage method is used to print the data regardless of the destination. The difference is that for a PrintPreview you do this: PrintPreviewDialog ppd = new PrintPreviewDialog(); ppd.Document = myPrintDocument; ppdialog.Show(); And for a "real"...
2 Feb 2019 by ahmed_sa
Which event used to preview print document instead of print ? I need to preview data not print so what event used for preview or load printdocument without print What I have tried: under button private void button1_Click(object sender, EventArgs e) { ...
21 Jan 2019 by Dj Vidov
On line _reportViewer.ServerReport.SetParameters(report);//error use LocalReport instead of ServerReport
11 Jan 2019 by Kolpher
I'm stuck with getting count of different values of same column. in crystal report i actually want only records with one specific condition; like records of city = "NY" but i have to show each and every individual count values at the bottom. like; Washigton 5 Dilhi 6 Shanghai ...
11 Jan 2019 by Maciej Los
Try to use unlinked subreport. How? Crystal Subreports Overview[^] Good luck!
24 Dec 2018 by mohamad qodosi
hi i had the same problem for long long time and after all i figured it out. paper size has some values like height and width. when you make a new object of PaperSize, these values are set to zero and when you set your paper to be A4, these values are zero again. so your paper size is not...
24 Dec 2018 by AhmedYehiaK
Hi everyone I have a report viewer that programmatically display a rdlc report when user click a buttonin button event i do the following: System.Drawing.Printing.PageSettings pg = new System.Drawing.Printing.PageSettings(); pg.Landscape = true; pg.Margins.Top = 2;...
7 Dec 2018 by ghidabadawi
Where to best buy crystal reports from ?
7 Dec 2018 by Member 14081535
crystal report website Moreover, this is a programming forum and programming questions are expected.
5 Dec 2018 by Maideen Abdul Kader
Hi I have an issue in asp.net using vb codeI am using Visual Studio 2012 with MSSQL 2005. I have problem in adding Report viewer, Version=11.0.0.0. I have checked this in google "'ReportViewer' is ambiguous in the namespace ".But I could not solve..Please anybody help me to solve...
30 Nov 2018 by YSLGuru
@Richard - I appreciate your taking the time to reply but did you read my post beyond the Title? I know how to find product specific groups/forums; I'm looking for non-product specify report developers to talk custom reporting about.
30 Nov 2018 by YSLGuru
Are there any Report Writing User Groups, groups that focus on custom reporting in general and not for a specific report writing software/platform? As best as I can tell the only custom report writing entities seem to be tied to a specific product or platform such as Microsoft's SSRS or SASS's...
11 Oct 2018 by OriginalGriff
Perhaps if you gave examples of my "spiteful and extremely hurtful messages" I could respond better - I don't see anything in my recent messages that fits the description (though I may be biased since I wrote them). The message list is public, as are all the messages, so if you could point me at...
11 Oct 2018 by Richard MacCutchan
Well firstly you have posted this in the technical questions forum, instead of the Site Bugs and Suggestions, so the administrators see it. Secondly, you have hidden behind a pseudonym so we do not have any idea who or where you are. Thirdly we have no idea what messages you are referring to....
18 Sep 2018 by Furqan Sehgal
Hi,I have been coming across this error very very often."A data source instance has not been supplied for the data source"Please advise why it comes and how to fix it.I googled it but did not get any solid method to fix it.ThanksFurqanUpdate from OP:OP resolved the issue...
6 Sep 2018 by #realJSOP
I found this with a google search: "SQL Server 2012 Reporting Services can use SQL Server 2005, 2008, 2008 R2, or 2012 databases as the data source. Besides, SSRS 2012 report server catalog database can also be hosted in SQL Server 2005, 2008, 2008 R2, or 2012 instances. Since you have turned...
6 Sep 2018 by malikkattubadi
I am working on a ssrs report where I am using custom data source i.e. am using ssrs expression (="data source=" & Parameters!ServerName.Value & ";initial catalog=master;integrated security=sspi") to use multiple connections from selected parameter to connect to that particular server. Am able...
1 Sep 2018 by Gerry Schmitz
Walkthrough: Using ReportViewer in a WPF Application[^]
1 Sep 2018 by Ammar Shaukat
What is the simplest way to add a simple RDLC report in WPF after a lot of work I came to know about following things that are required to generate a report(RDLC) in WPF. - A report ( myreport.rdlc ) file. - A report viewer ( in case of WPF, winform report viewer will be used to host rdlc...
27 Aug 2018 by vincentmathieu0@gmail.com
Hello, just to complete this issue, I could solve it in the KeepTogether properties of the Row group Level (not the Tablix level). Hope this help. Regards,
27 Aug 2018 by Paulo Augusto Kunzel
Hello All,I have a report done in ssrs 2012 that, on a page, has the data displayd as:|textbox | textbox ||------------------||textbox||------------------||textbox||------------------||Tablix||------------------||textbox||------------------||textbox|For reports...
9 Jul 2018 by Gautam Raithatha
Hello, I am designing an invoice in RDLC report. In the body part I have a table which contains ItemName, Price, Quantity and Amount columns. This table also contains a footer row that displays some totals. Below the table is summary section that contains total invoice amount and few other...
9 Jul 2018 by rajendra sharma
same problem any idea for this problem Please help me
26 Jun 2018 by rikidev
Hi I'm creating a PDF with prawn, how can I do to align the texts here that you see in the image below at the same height? Report Image What I have tried: Prawn::Document.generate("my.pdf") do image logo,:width=>540,:height=>60 text "Spett.le ",:align=>:right move_down 5 text...
22 Jun 2018 by MadMyche
Where did all the Crystal Reports XI R1 and R2 fixes go? | SAP Blogs[^]
19 Jun 2018 by DoingWork
What is Best Reporting Tool that compatible with Laravell and How ?? What I have tried: What about Birt Reporting Tool ?
18 Jun 2018 by Maciej Los
Try this: Manually: Click On Crystal Report -> Design -> printer setup -> change page layout (as per requirement) Programmatically: Crystal report page size[^]
18 Jun 2018 by Member 13040174
Im using SP19, while printing Report in either landscape and portrait, it getting cuts off around 10 to 14 mm.. Can this have any fix in some other versions? pls say What I have tried: I tried changing the SP till SP21. im getting page orientation corrrectly but while printing its get break
30 May 2018 by Hasitha Wijesooriya
how to set RDLC report rectangle fixed height ?? table in side the rectangle. problem is data filling the table report bottom side textbox location going down.how to stop it?
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 May 2018 by Ahmed Taha
I want to pass PictureBox to rdlc report, but I get this error [cannot convert from 'System.Drawing.Image' to 'string'][1] private void ReportPrintDes_Load(object sender, EventArgs e) { pictureBox1.Image = picQr; pictureBox2.Image = picQr2; ...
14 May 2018 by Richard MacCutchan
JasperReports® Library | Jaspersoft Community[^]
14 May 2018 by Member 13825784
Trying to generate the attendance report based on selecting the start date and end date. Not at all getting an idea to create the report regarding attendance sheet.where it should be in the format of...!!! St.ID Std.Name Date1 Date2 Date3............Date30 TotalDays presentdays absentdays %age...
14 May 2018 by Member 8057273
I am creating a report in PHP using mPDF Library. Till now the output is saved as a pdf file which I need to print out manually by opening the auto downloaded file. What I need is as soon as I click on Print button on my PHP Web page, mPDF should create the output and immediately print the...
13 May 2018 by kheo1
I'm using the RDLC report in VB.Net 2015. In report design -> Report properties, I set Paper size = A4, Width = 21cm, Height = 29.7cm, Top = Left = Right = Bottom = 2cm. In Body Properties, I set Width = 17cm (= 21 - 2 - 2) and place the controls in the design area. However, when the report...
19 Apr 2018 by AkiStar
I'm trying to send data from angular application to display the telerik report using telerik web services. I was able to do so using custom resolver but im looking for the best solution to achieve this. What I have tried: I have created a telerik rest service to generate the report at server...
16 Apr 2018 by EeMan X
I design a rdlc report with "txtpayee" parameter and a text box with an expressing of "=Parameters!txtpayee.value" I want to pass the value from my combobox to the textbox in my report. The problem is when i try to do it, it pass the value but not in the textbox instead it creates another page. ...