How to Create Report using Report Viewer in ASP.NET

Awesome Priti thanks for your Example...Thanks a lot..

Is it possible to create a Unique Report Viewer Page in ASP.Net? Just like in windows applications.

Thanks Priti for such a simple and best report sample.

Which report control supported for asp.net project hosting on server

Reportviewer good example , I served much to start a new project , thanks , greetings from Bogota - Colombia (http://devcate.blogspot.com/)

hi priti my contact no is this 07878766113 call or misscall me i have some error with reportviewer.please help me ...

Very Gud Article Priti, Its helpful to us. But can you provide me the guidance, about like this Report Design, i would like to do some fields in Group and other would be in details. Like Example as INVOICE Report ( BILL report format). Please Guide me How to use Groups in Microsoft Report RDLC.

This article very usefull to me

Nice Article

have u got any error? Make sure you have put name of datasource is correct in this line of code: ReportDataSource _rsource = new ReportDataSource("DataSet1", dt);

Hi, I've been trying to follow exactly the tutorial above but my report doesn't display anything. What I suppose to do? I try to debug. seems the DataTable return a value but it does not display at the report

Asp.Net Reports with Report viewerhttp://www.codesolution.org/?p=39

am looking for personal class for Dot net in Nerul

Hi priti, can this work in getting data from database and how can I get the next value? Thank you for your answer

Hi Priti, That article was great help. Now I am able to generate the report template from button click. But I am facing another challenge now. My variables are declared and generated in the MainWindow. How can I pass the variable value to another window? i declared it as public string, public int etc, but seems like by just doing this is not enough to read the variable value from another window. Any advice on this?

Hi Priti, much thanks for the links. I will try them out and let you know. Regarding the plot, the graph is already plotted on the mainwindow and i have a way to copy it to clipboard or save it to a bitmap image. I will need to move it to the report template to complete the report for individual users.

Hi Priti, thanks for the article. Could you tell me how to do it in wpf application please? I have a program that analyses a dataset and saves the results such as frequency, peak value and the graph plot in variables. I want to generate a report based on this analysed data. What I have done is to crete a report.rdlc file and made a template. I also created a dataset.xsd and created the data variables that I will need for report generation. I am stuck there and not sure how to pass the analysed data to the report template and generate the report upon a button click. Could you help?

@sudi Mashruuc ,like instanciating class. DataSet ds=new DataSet().If you are new in a ADO.NET then first learn ADO.Net Concept.then u can easily understand the Dataset.

how i can create data set

nice explanations....

yes I got it. But percent format is different 66.6666666666667 how can I change the format to 66.66 %

You have to add one column in datatable.and place calculated field data in this column.

@priti, can you let me know how can i create a calculated field in report viewer. this is formula for that (gradeval * 100) / 12) gardeval is the column name Thanks

@priti, I found the solution Thanks

@priti, how can I call this GetData() class in the below code..................ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc"); Customers dsCustomers = GetData("select top 20 * from customers"); ReportDataSource datasource = new ReportDataSource("Customers", dsCustomers.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource);

write this code: private DataTable GetData() { DataTable dscommted = new DataTable(); SqlConnection con = new SqlConnection(ConString); string strComment = "select top 20 * from customers"; SqlCommand cmdcomment = new SqlCommand(strComment, con); SqlDataAdapter sda = new SqlDataAdapter(cmdcomment); sda.Fill(dscommted); return dscommted; }

Hi Priti can you explain how can I bind this method to report viewer Data Source. private void GetData() { DataTable dscommted = new DataTable(); SqlConnection con = new SqlConnection(ConString); string strComment = "select top 20 * from customers"; SqlCommand cmdcomment = new SqlCommand(strComment, con); SqlDataAdapter sda = new SqlDataAdapter(cmdcomment); sda.Fill(dscommted); }