Last post Dec 03, 2011 10:35 AM by FileFoundException
Dec 02, 2011 05:10 AM|MishMish|LINK
Hello Experts, I am starting my new career with ASP.NET, and i have just finished the first web form that i was asked to create, BUT, after creating it using a table in the data base that is showed and managed in a GridView, i was asked to generate a report,
and a chart, as a summary of my entries, and when i took my Microsoft .Net class, they didnt talk about reporting at all, so i really have no idea if this can be achieved throught Microsoft Visual Studio 2010 or not, but i think it showld be, can any one help
me please by at least giving me a hint or a link to help me out? or at least what method or tool do i have to use in order to make the report? but in VB.NET please, and thanx alot in advance...
Dec 02, 2011 07:59 AM|FileFoundException|LINK
You can create a local report (in the toolbox find a ReportViewer control and add it to your page) and this will give you a rich functionality. Search for ReportViewer local processing or read this http://msdn.microsoft.com/en-us/library/ms251704(v=VS.100).aspx and
the suggested pages.
Another approach is to use the chart controls
You can get started here
Dec 02, 2011 08:14 AM|Horizon_Net|LINK
additional to the good points in the post above: If you have to design the report yourself and your using SQL Server you should have a look at SQL Server Reporting Services (SSRS). Some good tutorials could be found on the following site -
Dec 03, 2011 12:47 AM|MishMish|LINK
Ok thanx alot every body for the great help, i managed to create my .rdlc reporting file and added it to my web form and worked greatly, now the problem is that i when i created the dataset and chose the column that i want to include in the report, it came
very clearly and nicely, but how do i put a condition!! like i dont want the whole table data to be populated into the report, i want for example to show all records in the table for a scpecific date, i have a date column of course, i want the user to chose
2 dates(starting and ending) and the report gets generated upon that, can any one please tell me how to do that!!
for example, if i wanna say that in SQL statements it would be like this:
SELECT * from MyTable where date => TextBox1.Text AND date =< TextBox2.Text
i tried so much to put the condition in the report but i only reached a dead end, can any one help me please? and thank you.
Dec 03, 2011 04:47 AM|MishMish|LINK
Ok, I beleive that one way to do so is through parameters, i added 2 parameters in my Report Wizard and fixed my selext statement to show where date >= @param1 and date <= @param2
but how to call those parameters and how to call my ReportViewer in my .aspx code behind page? please help...
Dec 03, 2011 10:35 AM|FileFoundException|LINK
Yes you can parameters to let the user control the filtering.
For now check out this walkthrough http://technet.microsoft.com/en-us/library/aa337091(SQL.90).aspx and also browse the available ReportView control's events.