locked
RDLC how to? RRS feed

  • Question

  • User-1131752344 posted

    Hello all,

    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.

    Thanks,

    Leo 

    Thursday, July 30, 2015 11:32 AM

Answers

  • User-219423983 posted

    Hi Leo,

    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.

    https://msdn.microsoft.com/en-us/library/k10148y1.aspx?f=255&MSPPError=-2147217396

    https://gallery.technet.microsoft.com/scriptcenter/Insert-Update-Delete-In-d5c32f69

    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.

    http://www.aspsnippets.com/Articles/Create-RDLC-Report-using-Stored-Procedure-in-ASPNet-with-C-and-VBNet.aspx

    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 of them.

    I hope it’s useful to you.

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 31, 2015 3:24 AM
  • User-698989805 posted
    I think this would work: m.youtube.com/watch?v=txYnDrdO8FM&itct=CAgQpDAYACITCPyKmqydhccCFROMfgod2lYA81IVUkRMQyBSZXBvcnQgLSBCYXNlbSBI&hl=en-GB&gl=US&client=mv-google
    To me this is the best example to create RDLC report.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 31, 2015 7:14 AM

All replies

  • User-698989805 posted
    Try this tutorial: http://www.youtube.com/watch?v=4jWo4Blh44U
    Thursday, July 30, 2015 1:05 PM
  • User-1131752344 posted

    Hello TechView,

    Thanks for the information, but it seems this is a bad link. Is it missing something or server is just down?

    Leo

    Thursday, July 30, 2015 1:07 PM
  • User-219423983 posted

    Hi Leo,

    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.

    https://msdn.microsoft.com/en-us/library/k10148y1.aspx?f=255&MSPPError=-2147217396

    https://gallery.technet.microsoft.com/scriptcenter/Insert-Update-Delete-In-d5c32f69

    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.

    http://www.aspsnippets.com/Articles/Create-RDLC-Report-using-Stored-Procedure-in-ASPNet-with-C-and-VBNet.aspx

    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 of them.

    I hope it’s useful to you.

    Best Regards,

    Weibo Zhang

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 31, 2015 3:24 AM
  • User-698989805 posted
    I think this would work: m.youtube.com/watch?v=txYnDrdO8FM&itct=CAgQpDAYACITCPyKmqydhccCFROMfgod2lYA81IVUkRMQyBSZXBvcnQgLSBCYXNlbSBI&hl=en-GB&gl=US&client=mv-google
    To me this is the best example to create RDLC report.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 31, 2015 7:14 AM