Last post Jul 31, 2015 07:14 AM by TechView
Jul 30, 2015 11:32 AM|Leo D.|LINK
I am totally new to RDLC and reporting in general. In reading some articles about this topic, I came to get some interest on it and decided to give a shot on a side project that I have been working on it for learning purposes. However, I would like to have
some guidance from the experts on this forum. Please find below, some of the things I would like to get accomplished on this report.
1)- I have a DB with a few tables and Stored Procedures that gets data from the user on a Gridview (it can also be edited and deleted from there and it works just fine). This DB collects fields such as Date, Supplier, Activities, etc.
2)- To generate the report I am using a Date Range (From/To) and based on the user input, the first column that I would like to show is the Month/Year(Jul-2015). On the second column I'd like to display the WEEKS of the Month selected starting on MONDAY
(Week Of 07/06, 07/13, 07/20 and 07/27). Then, finally I would like to display the data from the other fields (Suppliers, Orders, Activities, etc.) based on the dates on the Gridview and GROUPED by that WEEK and show on the same ROW and then do the same if
User selects more than 1 Month on his/her selection.
I know I would probably have to set some Parameters and different Stored Procedures but I don't have a clue on how to start.
Can I do it from Code behind? Is it possible to do from the DataSet/Parameters Wizard?
I appreciate the tips that you may eventually have and will take every input in consideration.
Jul 30, 2015 01:05 PM|TechView|LINK
Jul 30, 2015 01:07 PM|Leo D.|LINK
Thanks for the information, but it seems this is a bad link. Is it missing something or server is just down?
Jul 31, 2015 03:24 AM|Weibo Zhang|LINK
About how to use stored procedure and how to pass parameter values to a stored procedure to get data, you could refer to the following links. They all provide you a detailed tutorial and you should read them carefully.
About how to create RDLC Reprot, I think you could refer to the following link, it provides a detailed demo about how to use stored procedures to create an RDLC Report. You could refer to it step by step to create a demo, and then maybe you could have an
intuitive understanding. About the columns you want to build, I think when you know how to create the report, it’s not difficult for you to achieve it. First, define the title and then bind the data that comes from DB to the report.
Besides, I think you’d better first to learn how to use stored procedure in asp.net and then learn how to create the report. You could also search some free video tutorials by yourself. According to the videos, maybe you could have a better understanding
I hope it’s useful to you.
Jul 31, 2015 07:14 AM|TechView|LINK