Click here to Skip to main content
15,881,715 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 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
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.

All Articles

Sort by Score

Reporting 

16 Nov 2010 by Olga Tabulov
Ever tried to put a break in the textbox of the rdlc report? \n and such don't work...
16 Oct 2012 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
5 Sep 2015 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
23 Jan 2013 by Justin Shepertycki
Using Entity POCOs as a DataSource for your Crystal Reports
28 Dec 2014 by Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.
20 Aug 2012 by Albert Holguin
This is a quick overview of the Windows 7 Problem Steps Recorder utility.
3 Apr 2013 by Nithesh AN
Printing an RDLC file in ASP.NET MVC3 automatically by converting into PDF and using Acrobat Reader.
7 Feb 2011 by Furqan Sehgal
I just found the way to fix it.Got o your ReportViwer that carries the report.Click on the triangle above and clickChoose Data Sources. Here you will find the binding sources in in your data sets.Just choose your binding source and you are done.
10 Mar 2011 by strogg
It seems like you are using more than one dataset / datatable in your reportSpecify a scope for the text boxHere's an example of a textbox value without a scope:=First(Fields!xxx.Value)(does not have a scope, valid if only one datatable / source is attached to your report)If you have...
21 Sep 2012 by Mohamed Mitwalli
Hi ,Check this private void Form1_Load(object sender, EventArgs e){ this.usp_ReportPersonByIDTableAdapter.Fill(this.HeaderPerson.usp_ReportPersonByID,1);//Place it First before Refresh this.reportViewer1.LocalReport.SubreportProcessing += new...
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...
20 May 2012 by Manas Bhardwaj
Lets say you have a table like this: CREATE TABLE [dbo].[Table_1]( [test] [numeric](18, 2) NULL) ON [PRIMARY] The query below should give you results like you want:SELECT Test, CASE WHEN (Test % 1) > 0 THEN CAST(Test AS FLOAT) ELSE (CAST(Test AS INT)) END AS...
31 May 2012 by codeBegin
Grouping Data in a ReportViewer Report [^]Building rdlc report in Visual Studio 2010.[^]ReportViewer: Grouping Data in RDLC Report[^]
5 Dec 2012 by Eranda Ketawalage
Suppress field in Crystal Reports.
12 Aug 2013 by Volynsky Alex
Please read following article below:http://blog.mayurtendulkar.com/2010/07/experience-with-crystal-reports.html[^]and it:http://www.techrepublic.com/forums/questions/crystal-reports-printing-on-dot-matrix-printers/[^]Regards,Alex.
6 Oct 2013 by Sergey Alexandrovich Kryukov
This is because you did not write a single line putting any content in print document. Please read carefully: http://msdn.microsoft.com/en-us/library/system.drawing.printing.printdocument.aspx[^].Please see the code sample at the end of this article. It shows how to handle the event...
19 Jan 2015 by Thinira
In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.
27 Jun 2016 by Maciej Los
Here: Microsoft Products Accepting Bugs and Suggestions | Microsoft Connect[^]Here is a guidelines: Bug Reporting Guidelines | Microsoft Connect[^]
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...
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.
26 Jun 2010 by Sandeep Mewara
ash_lookin4u wrote: I have a formula filed '@DebitAmount' ,I want to calculate the 'sumIts already a formula field. Why not have a SUM inside that very formula? Whats the issue in it... i guess that is do-able!
27 Sep 2010 by Hiren solanki
if you are getting SoapException then put your code in Try. and Catch.Use Catch using below snippets.Catch(SoapException soapEx){string Error = soapEx.Detail.InnerText;}put the Detail to here so that the devloper can understand the actual problem.Rather then putting the...
3 Nov 2010 by Simon_Whale
use Crystal reports but the data source would be a dataset that you pass to it.have a look at this example[^]
10 Dec 2010 by thatraja
You can disable that by using the below propertyCrystalReportViewerBase.EnableParameterPrompt Property[^]Also take a look at this one toohow to assign values for parameter fields at run time[^][Edit]
31 Jan 2011 by Manfred Rudolf Bihy
I've just taken a look at the project page at sourceforge.net and it seems to me that there isn't much development going on in recent times for Report.NET. I don't know if you need this for a commercial product or not, but please have a look here: http://itextpdf.com/[^]. For commericial use...
22 Apr 2011 by Aman4.net
Hi All,I just tried the following concept to print without viewing report. DialogResult ans = MessageBox.Show("Want Print Preview?", "App Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);if (ans == DialogResult.No){Int32 OrderID =...
14 Jun 2011 by milenalukic
I had a similar problem. This might not be the best solution but it solves the issue.Include an extra column in your data (Call it what you like) you can even leave it blank.When you create the matrix group on State as you are doing and also include the extra column so that it shows...
4 Dec 2011 by thatraja
Check theseSSRS 2008: cumulative values in line-chart[^]Charts, Running Totals and Time Series. Custom Code to the Rescue.[^]
5 Dec 2011 by WebMaster
If U are adding a table in Report viewer then the table get shrink in some browser.To solve this issues, firstly use rectangle and then drag the table in that Rectangle.Outer - RectangleInner - TableThis works well in our Project
30 Dec 2011 by Wendelius
Perhaps this would help: http://stackoverflow.com/questions/5454972/setting-image-source-in-rdlc-report-dynamically[^]
5 Jan 2012 by Vijay Kr Sharma
Ask Your Hosting provider , are they supports microsoft reporting or not i have been faced the same problem before few days when i purchased mywebspace from manas hosting
5 May 2012 by Sandeep Mewara
You missed to mention it is SSRS. Now,the image column is says #ERRORThis simply means that the column type defined for the image is not configured correctly to show an image. Look here for details on how to do it:MSDN: How to: Add an Image (Reporting Services)[^]Display Database Image...
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[^]
22 Aug 2012 by Mits Machhi
Dear , you need to create a Add Command for that and in that you specify Union Query for that.this done in using the ADD COMMAND...and another thing is that "You need to Create Join Query for Return the Value from Different Table"for Example..this example shows different from different...
17 Sep 2012 by Stephen Hewison
There was something wrong with the report definition. It wasn't updating the parameter definitions to use the default values.After deleting the report from the server and republishing it, the default values were applied.
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...
12 Aug 2013 by Marc Gabrie
Hi,To get fast printing with a dotmatrix printer, you have to send raw bytes to the printer. I'd do this:1. Export the rpt file to txt by using this snipped code:ReportDocument myReport = new ReportDocument();myReport.Load(Server.MapPath("~/MyReport.rpt"));string...
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...
19 Nov 2013 by thatraja
Check this KBhttps://www.devexpress.com/Support/Center/Question/Details/Q332257[^]And hereafter use DexExpress support[^] for quick response. They have KB, forums, FAQ, training, tutorials, etc., for you.
22 May 2014 by Arjun Holla
http://www.bimonkey.com/about-the-bi-monkey/support/ssis-component-samples-list/[^]
22 Jun 2015 by Mikhail Smirnov
How to create a tool that helps to collect​ and analyze vital statistics information about users in one place​ using JavaScript.
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"...
1 Feb 2023 by JBartlau
This article sheds light on why it is useful to combine different data sources in a report.
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.
12 May 2010 by Tom Deketelaere
In you report you can add a parameter.To select your data according to this parameter go to report - selection and add a condition.In code you can pass this parameter to the report withrpt.SetParameterValue(ParamNaam, ParamValue)
30 Jun 2010 by Goutam Patra
Design all page header stuff in the Report header section
13 Sep 2010 by nikhildsoni
go to the toolbox, right click and Choose Items.On the .NET Framework Components tab, click Browse to browse to the install path of Crystal Reports. Mine is at:C:\Program Files\Business Objects\Common\2.8\managed\depending on which version of Crystal you have installed.From here, select...
14 Oct 2010 by Abhinav S
You can start from here - 1.http://msdn.microsoft.com/en-us/library/aa287920(VS.71).aspx[^]2. http://www.beansoftware.com/ASP.NET-Tutorials/Using-Crystal-Reports.aspx[^]
20 Oct 2010 by Sandeep Mewara
Well, calling a report is not an issue. In order to show the rendered report to a user, you need a report viewer. Pick the report from a given path. Since RDL's are XML based you can use it accordingly in code. Google for 'SSRS runtime' if you need more info.
3 Nov 2010 by jonijoni
Hello.I'm programming in Visual Basic 2008. I need to make a report, with its header, body and foot, and with graphics and matrix with data (NOT data base tables).The challenge, is to make a report WITHOUT using data source. The data, are provided by an insternal calculation proccess...
16 Nov 2010 by strogg
Create a new dummy dataset in your solution & design a table with the columns you want (empty of course). Now use the fields of this table in your report designer (drag & drop will do).In your code, fill up a DataTable with the same structure as in your dataset.Add the DataTable to the report...
17 Nov 2010 by strogg
Make sure of these things1) The values of the fields in the table (in report designer) are set like=Fields!field1.Value , =Fields!field2.Value etc2) That you have created a DataTable containing the same field names (field1,field2,field3) and they have the same data types.3) Make sure...
18 Nov 2010 by strogg
All you had to do was to delete those designer generated bindings : )I don't know about your problem. weird.I had some funny problems when i maintained 2 tables in one dataset. After trying lots of things, it worked correctly when i moved each table to a unique dataset. Try that - just keep...
21 Nov 2010 by Sandeep Mewara
All you need is to form the query such that it returns the data in desired format. Once the query is in place, you can just bind it and show it in the crystal report.
7 Dec 2010 by Rajesh Anuhya
I'm not sure if it works with urls. In our rdlc reports, the external images' paths are set to the physical paths on the server
3 Jan 2011 by Gerry Logrosa
Hi all,I have trouble using StringReader to load my RDLC file after modifying it seems like no effect.If I overwrite the original RDCL file it worksPlease correct this code...public void localizeReport(LocalReport report) { //used to call the resources...
19 Jan 2011 by Umair Feroze
As far as I understood your question:You need to have a list call list1 which will be having master column or master information. Within list1 you have another list call list2.list2 will show up detail information of the master column which is in list1.To do this I followed the following...
28 Jan 2011 by Sandeep Mewara
Since you have said RDLC, I assume you are talking of SSRS.In SSRS, HTML parsing/fields are only supported in SSRS2008. Till SSRS 2005 HTML support is not there. If you want to set a richtextbox text in report than you need to use SSRS2008.
6 Feb 2011 by Sandeep Mewara
This article of mine would help you in understanding and learning on how to use Custom code: Localization of SSRS Reports[^]Now, pointwise:1) I have added a text box to header of the report, I want to assign some value to it from my variable.You can do it via custom code or using a...
8 Feb 2011 by #realJSOP
Make sure the variable's access level is public.
22 Feb 2011 by Tech Code Freak
Hi! you can use conditions to assign values to variables depending on the comboboxes in following way...string pid="";if(ComboBox1.SelectedValue != "") pid="P001";add parameter field in crystal reportthen..ReportDocument cryRpt = new...
3 Mar 2011 by thatraja
OP wrote:Question no 1: Why there is no Channel ID?Did you mean 'Call channel No'? BTW check whether that field has any properties/formatting(visibility, color, etc,) or small width...I'm sure it will be a minor issue.OP wrote:Question no 2: Why Why is the Call Date in long date format?You...
9 Mar 2011 by novice51
Does anyone here knows how to generate sqlite report in crystal reports?sample codes,library,dll,wrapper or links would be a great help...thanks in advance!
21 Mar 2011 by calcushtag
Well, I said in question that I installed SAP Crystal Reports for VS2010 and I can add a .rpt file to project; So why I should download Crystal viewr? that's not a good solution.But I solve it just by following two steps:1) In project Properties window in the Application tab changed the...
26 Mar 2011 by వేంకటనారాయణ(venkatmakam)
I think in my earlier company, in one project they are working on converting the images to PDF(not db tables).I think they used the library Libharu(i did not remember the exact name so i used Google) http://libharu.org/wiki/Main_Page[^]
22 Apr 2011 by Aman4.net
Hi All,I am using rdlc in my window application. I am using 2 Table Adapter with parameter as datasource and custom paging 8 X 5.5 in rdlc. I want to print rdlc report without viewing it. I have gone through the following...
2 May 2011 by yesotaso
Assuming you leave PDF viewer to the client you can dump binary pdf from a dummy page to client by changing mime type to "application/pdf".protected void Page_Load(object sender, EventArgs e){Response.ContentType = "application/pdf";// Fill data here with binay PDF supplied by reporter...
13 May 2011 by ajitha.pusapati
Good evening all,i developed a report using rdlc.i just show one table data in that.fields are id int, name string, decimal amount. data like the bellow.. id name amount 1 luxury- @5% 500 2 Service Charges -@6% ...
27 May 2011 by Ruard
This is what I did to dynamically create the report:and in code:this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("logdataset", new ObjectDataSource("logdataset.Report1TableAdapter", "GetData")));this.ReportViewer1.LocalReport.ReportPath = "ReportFile.rdlc";//...
7 Jun 2011 by satrio_budidharmawan
Hi,I wanted to ask on how to create Report (like a Crystal Report) in VB.Net with smartdevice project?I have a dataset and a database transaction about sell and buy (like a PoS).So I need to create report on :- who bought my product (Name,Address and so on)- what product they...
17 Jul 2011 by pradeeprawat100
Do the following settings for the textboxset language------- en-INformat ------- N2
3 Oct 2011 by Pradeep Shukla
Go through this link, would be helpful to what you are looking for:http://forums.asp.net/t/1644301.aspx/1[^]
7 Oct 2011 by Tanaya17
first make a temporary table.................then insert data from first table then from second table.................then view data from the temporary table...........
11 Nov 2011 by Ganesan Senthilvel
When you want to summarize data in a visual format, use the Chart data region. Charts enable you to present large volumes of aggregated information at a glance. It is important to carefully prepare and understand your data before you create a chart, as this will help you design your charts...
11 Nov 2011 by koolprasad2003
here is good link[^] to draw chart in excel using c#
21 Nov 2011 by OriginalGriff
Try:UPDATE myTable SET [2001]=amount *10/100, [2002]=amount*15/100And so forth.
23 Nov 2011 by Kschuler
Sounds like you need to do a little research. I think what you are looking for is sub reports. Here[^] are some CP articles on Crystal Reports.This one[^] has a sub report example.Hope this helps.
23 Nov 2011 by thatraja
Sub reports...SubReports in Crystal Reports SubReport[^]C# Crystal Reports - sub reports[^]kishorekke wrote:If i click on 10 in new hires col,i need to show 10 employees in another reportIf i click on 4 in new hires col,i need to show 4 employees in another reportIf i click on 1 in...
4 Dec 2011 by thatraja
Check theseProblem export Arabic to PDF[^]Designing for PDF Output[^]Reporting Services 2005 now rendering PDFs differently![^]
26 Dec 2011 by Wendelius
Have a look at these:- Creating a Simple Report with Visual Studio 2008[^]- Samples and Walkthroughs[^]
30 Dec 2011 by thatraja
Check thesehow to display image field in microsoft report in vb application?[^]Loading Byte image on SSRS from database[^]Code for loading a picture from any folder to data report[^]
5 Jan 2012 by fjdiewornncalwe
You may wish to check one or all of the following on the server that is hosting your application. The errors should be logged somewhere in these and should help you narrow down what the issue is.1) IIS logs2) System Logs3) Perhaps turn on FailedRequestTracing and check those logs as well.
7 Feb 2012 by thatraja
Check theseCrystal reports - Failed to open a rowset[^]How to Solve the "Failed to Open a Rowset" Error[^]"Failed to Open a Rowset" error when running Crystal Reports[^]
12 Apr 2012 by luisnike19
Using Report viewer. At least check this page you cam find some examples.http://www.gotreportviewer.com/[^]
24 Apr 2012 by ELiva
In the body of the report. Add a table (if you haven't already) that contains the desired fields from the dataset containing your data. You can then add a report footer easily to the report by right clicking in the leftmost heading table cell and selecting "Table Footer".
20 May 2012 by Wendelius
Even though you can partially format the data in the SQL statement I would advice to format it on the report. Have you tried using %g as the format. Picked up this from Inline formatting[^]
26 May 2012 by mutlyp
I am brand new to Microsoft Report Services so forgive my ignorance.I followed the "Integrate Reporting Services with Silverlight and RIA Services"Integrate Reporting Services with Silverlight and RIA Services[^]It's a great tutorial and was even able to create the same thing in VB. So...
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...
3 Jun 2012 by taha bahraminezhad Jooneghani
you can use Union method to get to table to one!you can use selecting event of linq datasource:protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) { e.Result = dt1.Union(dt2).ToList(); }you have two table in one list!now...
1 Jul 2012 by Ganesan Senthilvel
Couple of answers:If you want to generate a report using Microsoft Reporting Service, then you can refer MSDN article for step by step tutorial at http://msdn.microsoft.com/en-us/library/ms159170(v=sql.100).aspx[^]To find data from a table in between two dates, you can use the below SQL...
20 Aug 2012 by Prasad_Kulkarni
Refer similar thread on CP:what's the difference between .rdl and .rdlc reports[^]..and more here[^]
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...
29 Aug 2012 by Sourav Sarkar-SS
I think report.SetDataSource(dts);this is the problem line. report.SetDataSource(dts.Tables[0]);Try this.
11 Sep 2012 by david markal
using CrystalDecisions.CrystalReports.Engine;using CrystalDecisions.Shared; ........crystalReportViewer1.ReportSource = report;Why ... always => missing using direct ... reference..problem with .ReportSource not definition...?????some body help me!
16 Sep 2012 by Sandeep Mewara
textbox3 parameter is stardatetextbox4 parameter is enddateEven though the parameters are of date, but they are being passed through a textbox text. Thus, they are mere strings (and not date even if it is of date format)You need to convert the string into datetime and then pass on to SP....
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...
21 Sep 2012 by Dev-0001
I'm design Report with sub Report and I'm always get this Error Data retrieval failed for the subreport, 'SubReportZone', located at: PassesInfo.Report.SubReportZone.rdlc. Please check the log files for more information. private void Form1_Load(object sender, EventArgs e){ //...
28 Sep 2012 by Amol_27101982, India
I don't think problem is with server configuration.You should check the connection string you are providing in order to build resultant dataset which is bound to the crystal report viewer. Or maybe you should check for the WHERE clause (data filtering). It is highly possible that dataset...
2 Oct 2012 by AlmirM
Hi,dont't have much experience with ReportViewer but would appreciate quick guide...I would like to generate Report in .Net (using both vb and c#) using stored procedure for retrieving data (SQL Server sp). The problem is when I try to pass parameters from my .net code behind to stored...