C# Tutorial - How to create RDLC Report with parameters | FoxLearn

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ก.ย. 2024
  • How to create RDLC Report with parameters using Microsoft Report Viewer in C#.
    Northwind database: ouo.press/py3LO5
    RDLC Report with parameters (C# Code)
    How-to Pass Parameters to Report Viewer using WinForms
    How-to Pass Parameter to Report Viewer
    Create RDLC SubReport (C# Code)
    How to use Filters & Parameters in ReportViewer
    C# - How To Bind DataSource To RDLC Local Report (Easy Method)
    Report Generation from Data set in c# windows application
    RDLC reporting through WinForms C#
    How to create & View Simple RDLC Report in C#
    Creating reports using report viewer and passing parameter C#
    How to Create a Report with a Parameter using ReportViewer in Visual Studio

ความคิดเห็น • 125

  • @iwcreations5478
    @iwcreations5478 2 ปีที่แล้ว +1

    There can be an error if you Drag and drop the date. So copy and paste the date range. This video was beneficial to me. Thank you so much.

  • @Jotita22
    @Jotita22 6 ปีที่แล้ว +1

    I love that you're playing Christmas in minute 4 LOOL

  • @danielhidalgo1212
    @danielhidalgo1212 4 ปีที่แล้ว +4

    were you able to resolve the error? 'GetOrdersReport_ResultBindingSource'

  • @johnwakler9741
    @johnwakler9741 6 ปีที่แล้ว

    Great tutorial for beginner ,Clearly understandable. Thanks for posting

  • @virenderkaushik5510
    @virenderkaushik5510 5 ปีที่แล้ว +2

    Hi, your tutorials are really awesome, thanks man,
    Can u please make a tutorial on Bill Of Material (BOM) and
    How to create a Account Ledger Report.....
    Please i need.,. again thanks in Advance........

  • @danielpicker7030
    @danielpicker7030 6 ปีที่แล้ว +7

    Hi, i can fin only GetOrersReport_Result how can i find GetOrersReport_ResultBindingSource because is not autogenerate... You have an Idea?

  • @carlitallica
    @carlitallica 7 ปีที่แล้ว +6

    Hello, I am trying to make a report and I am getting stuck in the part where you add "GetOrdersReport_Result" I cant find that mine. Is there something you have have to do first to get that result??

    • @mahadyhasan2575
      @mahadyhasan2575 5 ปีที่แล้ว +1

      First you have to create a store procedure in SQL Server named GetOrdersReport and add that to your Project (in .edmx). Then you will get "GetOrdersReport_Result".

  • @hamoudajamal7706
    @hamoudajamal7706 4 ปีที่แล้ว +1

    not found GetStudentReport_ResultBindingSource !!!
    What is the problem

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      You should create GetStudent stored procedure, then add the GetStudent StoredProcedure to your Entity Framework Model

    • @zendyajah
      @zendyajah 4 ปีที่แล้ว

      @@foxlearn what get student i stuck in here too not found GetStudentReport_ResultBindingSource !!!

  • @feezankhattak1573
    @feezankhattak1573 3 ปีที่แล้ว

    A datasource instance has not been supplied for the data source 'DataSet1'.
    A follow your steps but when i run it, so instead of showing data it show the above message, how can i fix it.

  • @krismaly6300
    @krismaly6300 8 ปีที่แล้ว

    I enjoyed this video and recommend others
    Host seem to be very knowledgeable
    Audio is annoying or reduce the volume while recording.
    Host is too fast clicking the items while creating users/audience are unable to catch.
    Suggestion
    Slow down
    As many words as possible say it
    so that you can catch up large audience
    I know video is going to be taking long time but your idea is to tech and make understand.
    Another point is displaying over view of what you demonstrate would be very best
    Say
    Creating Form
    Creating Procedure
    Creating Viewer
    Adding Data Source
    adding Data Set
    Running report passing values
    so on
    Please please don't take it as criticism consider as suggestion only
    You can let me know I can test your video, write review/feedback. Feel free to share to educate the world.
    Thanks for educating the community and appreciate your volunteership.
    Thanks a bunch

    • @foxlearn
      @foxlearn  8 ปีที่แล้ว

      Thank you for your suggestion. I'll try to do better

  • @ANURURDRA
    @ANURURDRA 7 ปีที่แล้ว +1

    Very Nice report Design..thank u.

    • @foxlearn
      @foxlearn  7 ปีที่แล้ว

      Thank you !

  • @nouralhudamail
    @nouralhudamail ปีที่แล้ว

    The link to the database for practice seems need to be updated . Tried to go to link it didn't show any data .

  • @MuhammadAsim-wh9is
    @MuhammadAsim-wh9is 5 ปีที่แล้ว +1

    GetOrersReport_ResultBindingSource not auto-generated . Any solution????

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      You should create GetOrdersReport stored procedure

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      @@foxlearn were you able to resolve the error?

  • @MrPfpaau
    @MrPfpaau 2 ปีที่แล้ว

    I have on error in the line rpt_catalogo_articulos_ResultBindingSource = db.rpt_catalogo_articulos( nEmpresa).ToList();
    can not implicity convert type
    system.collection.genereric.list to system.windows.winform.bindingsource
    thanks

  • @rakeshpatel5791
    @rakeshpatel5791 6 ปีที่แล้ว +1

    Hello There. I am creating the windows form application. In that i have use the ReportViewer. Everything is OK, but i am facing the following error :-
    "An error occur during LocalReport processing"
    Please help me out. Its very urgent.
    Thankyou.

    • @nssramya8792
      @nssramya8792 2 ปีที่แล้ว

      I'm also having the same error 😭😭😭😭. I can't fix that error. could you find any solution for that sir.

  • @ejll
    @ejll 8 ปีที่แล้ว

    very Job, congragulations

  • @krismaly6300
    @krismaly6300 8 ปีที่แล้ว

    You are an AWESOME host

    • @foxlearn
      @foxlearn  8 ปีที่แล้ว

      thank you so much !

  • @АнтонМакаров-р8й
    @АнтонМакаров-р8й 6 ปีที่แล้ว +2

    WHat is GetOrderReport_ResultBuilding??

  • @phamgiaminh8241
    @phamgiaminh8241 5 ปีที่แล้ว

    Thanks a lot. I created the report successfully. However I have a problem, after I insert a new row and view report, but it's doesn't have newest data in report, old data still working, I must restart application it displays the data.

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      I think you should insert data into datagridview, then print report or you can refresh your report, refresh your datasource

  • @marjukrussel6312
    @marjukrussel6312 2 ปีที่แล้ว

    i did this but only run in my pc . i was changed ConnectionString but itwas not running another environment . Error 3 Error 146: Return type is not valid in FunctionImport 'rptReport'. The FunctionImport must return a collection of scalar values or a collection of entities. E:\SaddamReportBatch\SaddamReport\Model.edmx 19 11 SaddamReport

  • @ViccoxDxDxD
    @ViccoxDxDxD 6 ปีที่แล้ว

    Very Usefull, Thanks a lot :'3

  • @osamasajid553
    @osamasajid553 7 ปีที่แล้ว

    Excellent report with backend good music...
    if you never mind tell me the singer name or song name of the first part of the music of the video?

    • @foxlearn
      @foxlearn  7 ปีที่แล้ว

      Green leaves , you can find in youtube library, Thank you

  • @KevinAbramPiano
    @KevinAbramPiano 5 ปีที่แล้ว

    What is GetOrdersReport_ResultBindingSource? I'm stuck on that part as I don't know what that is.

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      GetOrdersReport is a stored procedure, you should create a stored procedure, then add to your project, please don't skip you can do that. all solution i've showed in this video

  • @gbmarshall
    @gbmarshall 3 ปีที่แล้ว

    Hi, this looks good. However, when I use on my own database server, and I check the stored procedure that I need to use, nothing happens - the dataset can't seem to read the stored procedure. Is there something I am missing?

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      You should write the code get data first, then you can bind to rdlc report

  • @JaimeChavarriaMartinez
    @JaimeChavarriaMartinez 7 ปีที่แล้ว

    Aplica hacer lo mismo con MySQL y Crystal Reports? Podría hacer un demo please? Thanks

  • @herberttabeta96
    @herberttabeta96 7 ปีที่แล้ว

    hi i cant ubdate report viewer on my visual studio
    is there any other way to create a report

  • @oliverrincon4226
    @oliverrincon4226 5 ปีที่แล้ว +1

    I think you skipped this step in your video. You did not show how to set up the GetOrdersReport_ResultBindingSource, which is causing a lot of confusion for your viewers. If this step is in fact in your video, please provide a time stamp so we can see this step.

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      GetOrdersReport is a stored procedure. you should add to entity framework, then add o bindingsource control. i've showed all

    • @kobeferran4390
      @kobeferran4390 4 ปีที่แล้ว

      then provide a timestamp of adding a binding source control, so your viewers won't be confused

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      were you able to resolve the error?

  • @Retro-x95
    @Retro-x95 3 ปีที่แล้ว

    Does rdlc report work for thermal print to print recipts? Because Crystal report is so slow please respond

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      I think no problem

  • @abdelrhmanelsaid4589
    @abdelrhmanelsaid4589 6 ปีที่แล้ว

    i made mine and got selectInvoice_Result but when choosing it got nothing in it

  • @jeffb1106
    @jeffb1106 ปีที่แล้ว +1

    Frustrating background music! Needing to find another video

  • @ubaidqureshi1451
    @ubaidqureshi1451 4 ปีที่แล้ว

    form loads correct but there appears a line on it "fromdate parameter is missing a value"......kindly help me out

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      I think you missing adding parameter

  • @PhoenixNinjas
    @PhoenixNinjas 4 ปีที่แล้ว

    And now please do the same (in VS 2019) with MySql, Dapper and without Entity Data Model. And two tables, you want not see the CustomersID, you want his name. I can the query, no problem, but I can't the stored procedure (query) become in VS.

  • @sumitmondal2885
    @sumitmondal2885 7 ปีที่แล้ว

    how to insert northwind data in my sql studio please tell me

  • @alexabc2012
    @alexabc2012 4 ปีที่แล้ว

    Hermano muy bueno, pero me gustaria saques uno lo mas pronto en ambiente web form con un procedimiento almacenado con varios parametros y rango de fecha ya que no hay nada de ejemplos buenos en google

  • @nitinpatil5700
    @nitinpatil5700 5 ปีที่แล้ว

    Can please anyone tell me what is the maximum limit for Data bind in RDLC report because when I am trying to bind data up to 85000 not operating

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      What error are you getting?

  • @kyvodaspammer9620
    @kyvodaspammer9620 6 ปีที่แล้ว

    Cool tutorial but chillout with this music pls

  • @paparntangsricharoen1522
    @paparntangsricharoen1522 8 ปีที่แล้ว +1

    sorry VS2015 in my toolbox is nothing reportviewer, how i can add it

    • @foxlearn
      @foxlearn  8 ปีที่แล้ว +2

      Hi, You need to install Microsoft report viewer, please try again. thanks

    • @paparntangsricharoen1522
      @paparntangsricharoen1522 8 ปีที่แล้ว

      Thank u so much
      if want to use reportviewer will install sqlserver tools

  • @anthonychukwujekwu4192
    @anthonychukwujekwu4192 5 ปีที่แล้ว

    I keep getting this error on my report viewer "the ToDate parameter is missing a value". What am I doing wrong?

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Please check your code again. in think you miss something

    • @anthonychukwujekwu4192
      @anthonychukwujekwu4192 5 ปีที่แล้ว

      @@foxlearn Thanks for the reply. I actually missed something. My report viewer was being refreshed before anything. I had to comment it out

  • @viddictify
    @viddictify 8 ปีที่แล้ว

    Thank you

    • @foxlearn
      @foxlearn  8 ปีที่แล้ว

      Thank you so much :)

  • @Dracometeor562
    @Dracometeor562 5 ปีที่แล้ว

    fox learn help me please i cant see on my visual studio the "parameters folder" for that , i cant add parameters help me please. please please :(

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Install report viewer for visual studio, then you can see

  • @babugenerous9034
    @babugenerous9034 6 ปีที่แล้ว

    how to generate this report using entity framework??

  • @onlydev4099
    @onlydev4099 4 ปีที่แล้ว

    I like it

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Thank you !

  • @ajitlimkar5382
    @ajitlimkar5382 7 ปีที่แล้ว

    Is this can be done with Visual Studio 2012 Ultimate. Please reply

    • @foxlearn
      @foxlearn  7 ปีที่แล้ว

      Yes, You can do with visual studio 2010/2012/2013/2015/2017

  • @feezankhattak1573
    @feezankhattak1573 3 ปีที่แล้ว

    An Error occurred during local report processing.
    An Error occurred during report processing.
    Cannot create a data reader for dataset 'DataSet1'.
    It's annoying..... 😤😤😤😤

  • @manishrathor9209
    @manishrathor9209 3 ปีที่แล้ว

    there is a error of source binding pls solve this issue its not a complete video please make new video for the Datasource error.

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว

      Please check your code again. I showed all the video.

  • @smok5121
    @smok5121 8 ปีที่แล้ว

    Hi, i can fin only GetOrersReport_Result how can i find GetOrersReport_ResultBindingSource please ?

    • @foxlearn
      @foxlearn  8 ปีที่แล้ว +1

      +Smok Ayoub Hi, It's auto create GetOrersReport_ResultBindingSource when you add a data source to report. Thanks

    • @danielpicker7030
      @danielpicker7030 6 ปีที่แล้ว +1

      In my side it's not auto generate... What I can do?

    • @rinnesm7419
      @rinnesm7419 6 ปีที่แล้ว +1

      @@danielpicker7030 i have the same issue :(

    • @verdigong1828
      @verdigong1828 5 ปีที่แล้ว +1

      me too no resultbindingsource

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      were you able to resolve the error?

  • @vusalakberov7422
    @vusalakberov7422 5 ปีที่แล้ว

    get_Result BindingSource is not running. I did everything step by step. But then ResultBindingSource doesn't come

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      You should create a stored procedure, then add your store to your project

    • @vusalakberov7422
      @vusalakberov7422 5 ปีที่แล้ว

      @@foxlearn I did the stored procedure and added it to the project.but Bindingsource isn't running

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      were you able to resolve the error?

  • @0105Alucard
    @0105Alucard 7 ปีที่แล้ว

    hi how can i insert my database from MySql Server ?

    • @foxlearn
      @foxlearn  7 ปีที่แล้ว

      Hi, You can view this video : th-cam.com/video/MSuKkF7Ff5g/w-d-xo.html , this video shows you how to insert update delete and view data from mysql server. Thank you

  • @WenzoTheDrummer
    @WenzoTheDrummer 5 ปีที่แล้ว

    Please i need the source code as i'm stuck in the part of getOrdersReport_Result

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      You need to create a store procedure, then add your store procedure to entity framework, then you can see the getOrdersReport_Result . Thank you !

    • @jmctx2005
      @jmctx2005 5 ปีที่แล้ว +4

      @SuperDesidude I agree... @FOX LEARN I think you skipped this step in your video. You did not show how to set up the GetOrdersReport_ResultBindingSource, which is causing a lot of confusion for your viewers. If this step is in fact in your video, please provide a time stamp so we can see this step.

  • @G11713
    @G11713 6 ปีที่แล้ว

    The background music was incredibly distracting. I'll try re-watching it muted.

  • @moradskiii
    @moradskiii 6 ปีที่แล้ว

    Why i cant download northwind?

  • @danielpicker7030
    @danielpicker7030 6 ปีที่แล้ว

    Are you know how to generate "GetOrersReport_ResultBindingSource" manualy? In my side, notthing to do for auto generate :-/

    • @Chehtishamulhassan
      @Chehtishamulhassan 6 ปีที่แล้ว

      yes me also generate manually

    • @Chehtishamulhassan
      @Chehtishamulhassan 6 ปีที่แล้ว

      but getting error "a data source instance has not been supplied for the data source"

    • @karend3390
      @karend3390 6 ปีที่แล้ว

      you need to add a dataset (data from your database table) to your report

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      were you able to resolve the error?

    • @fitzwilliamdarcy3328
      @fitzwilliamdarcy3328 3 ปีที่แล้ว

      ​@@danielhidalgo1212 Yes. The rdlc report has to be created first. It took me many hours but I figured it out. See my standalone post on how I did it.

  • @JM-sj4lf
    @JM-sj4lf 7 ปีที่แล้ว

    how to remove the time ?

  • @isuruabey
    @isuruabey 3 ปีที่แล้ว +1

    Is this work with asp.net mvc

    • @foxlearn
      @foxlearn  3 ปีที่แล้ว +1

      Yes, No problem

    • @isuruabey
      @isuruabey 3 ปีที่แล้ว

      @@foxlearn thanks 👌

  • @Dracometeor562
    @Dracometeor562 5 ปีที่แล้ว

    fox learn can you please make a tutorial without procedure, please please

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว +1

      OK. Thank you for your suggestion !

  • @lachielvaher9168
    @lachielvaher9168 4 ปีที่แล้ว

    oh my god the music is so freaking annoying..!@!!!!!

  • @vbprogramando
    @vbprogramando 4 ปีที่แล้ว

    my bien, pero no tenras desde codigo
    th-cam.com/video/xceXZR9aUCM/w-d-xo.html
    reporte desde codgo

  • @kobeferran4390
    @kobeferran4390 4 ปีที่แล้ว

    All your tutorials are very confusing..

    • @foxlearn
      @foxlearn  4 ปีที่แล้ว

      Do you have another idea? thank you

  • @verdigong1828
    @verdigong1828 5 ปีที่แล้ว +1

    i have an error in resultbindingsource. the error said that it doesnt exists in the context. what is the solution for this thank you pls answer. im a student

    • @verdigong1828
      @verdigong1828 5 ปีที่แล้ว

      pls help there is no resultbindingsource

    • @foxlearn
      @foxlearn  5 ปีที่แล้ว

      Have you added bindingsource to your project, please view don't skip you can do that

    • @jmctx2005
      @jmctx2005 5 ปีที่แล้ว +1

      @@foxlearn I think you skipped this step in your video. You did not show how to set up the GetOrdersReport_ResultBindingSource, which is causing a lot of confusion for your viewers. If this step is in fact in your video, please provide a time stamp so we can see this step.

    • @danielhidalgo1212
      @danielhidalgo1212 4 ปีที่แล้ว

      @@jmctx2005 were you able to resolve the error?