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

Поділитися
Вставка
  • Опубліковано 10 гру 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.

  • @danielhidalgo1212
    @danielhidalgo1212 4 роки тому +4

    were you able to resolve the error? 'GetOrdersReport_ResultBindingSource'

  • @danielpicker7030
    @danielpicker7030 6 років тому +6

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

  • @Jotita22
    @Jotita22 6 років тому +1

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

  • @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........

  • @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 6 років тому +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".

  • @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.

  • @rakeshpatel5791
    @rakeshpatel5791 7 років тому +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.

  • @hamoudajamal7706
    @hamoudajamal7706 5 років тому +1

    not found GetStudentReport_ResultBindingSource !!!
    What is the problem

    • @foxlearn
      @foxlearn  5 років тому

      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 !!!

  • @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 3 роки тому

    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

  • @RetroFortniteZB
    @RetroFortniteZB 4 роки тому

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

    • @foxlearn
      @foxlearn  4 роки тому

      I think no problem

  • @АнтонМакаров-р8й
    @АнтонМакаров-р8й 6 років тому +2

    WHat is GetOrderReport_ResultBuilding??

  • @KevinAbramPiano
    @KevinAbramPiano 6 років тому

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

    • @foxlearn
      @foxlearn  6 років тому

      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

  • @krismaly6300
    @krismaly6300 8 років тому

    You are an AWESOME host

    • @foxlearn
      @foxlearn  8 років тому

      thank you so much !

  • @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

  • @JaimeChavarriaMartinez
    @JaimeChavarriaMartinez 8 років тому

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

  • @ANURURDRA
    @ANURURDRA 8 років тому +1

    Very Nice report Design..thank u.

  • @gbmarshall
    @gbmarshall 4 роки тому

    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  4 роки тому

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

  • @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

  • @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

  • @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

  • @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

  • @herberttabeta96
    @herberttabeta96 7 років тому

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

  • @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?

  • @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

  • @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

  • @isuruabey
    @isuruabey 4 роки тому +1

    Is this work with asp.net mvc

    • @foxlearn
      @foxlearn  4 роки тому +1

      Yes, No problem

    • @isuruabey
      @isuruabey 4 роки тому

      @@foxlearn thanks 👌

  • @ejll
    @ejll 8 років тому

    very Job, congragulations

  • @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

  • @Dracometeor562
    @Dracometeor562 6 років тому

    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  6 років тому

      Install report viewer for visual studio, then you can see

  • @sumitmondal2885
    @sumitmondal2885 7 років тому

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

  • @abdelrhmanelsaid4589
    @abdelrhmanelsaid4589 6 років тому

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

  • @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.

  • @alexabc2012
    @alexabc2012 5 років тому

    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

  • @babugenerous9034
    @babugenerous9034 7 років тому

    how to generate this report using entity framework??

  • @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 5 років тому

      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?

  • @WenzoTheDrummer
    @WenzoTheDrummer 6 років тому

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

    • @foxlearn
      @foxlearn  6 років тому

      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.

  • @0105Alucard
    @0105Alucard 7 років тому

    hi how can i insert my database from MySql Server ?

    • @foxlearn
      @foxlearn  7 років тому

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

  • @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 6 років тому +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?

  • @kyvodaspammer9620
    @kyvodaspammer9620 6 років тому

    Cool tutorial but chillout with this music pls

  • @manishrathor9209
    @manishrathor9209 4 роки тому

    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  4 роки тому

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

  • @moradskiii
    @moradskiii 7 років тому

    Why i cant download northwind?

  • @jeffb1106
    @jeffb1106 2 роки тому +1

    Frustrating background music! Needing to find another video

  • @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..... 😤😤😤😤

  • @JM-sj4lf
    @JM-sj4lf 7 років тому

    how to remove the time ?

  • @G11713
    @G11713 7 років тому

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

  • @viddictify
    @viddictify 8 років тому

    Thank you

    • @foxlearn
      @foxlearn  8 років тому

      Thank you so much :)

  • @onlydev4099
    @onlydev4099 4 роки тому

    I like it

  • @Dracometeor562
    @Dracometeor562 6 років тому

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

    • @foxlearn
      @foxlearn  6 років тому +1

      OK. Thank you for your suggestion !

  • @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.

  • @lachielvaher9168
    @lachielvaher9168 4 роки тому

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

  • @vbprogramando
    @vbprogramando 4 роки тому

    my bien, pero no tenras desde codigo
    ua-cam.com/video/xceXZR9aUCM/v-deo.html
    reporte desde codgo

  • @kobeferran4390
    @kobeferran4390 5 років тому

    All your tutorials are very confusing..

    • @foxlearn
      @foxlearn  5 років тому

      Do you have another idea? thank you

  • @verdigong1828
    @verdigong1828 6 років тому +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 6 років тому

      pls help there is no resultbindingsource

    • @foxlearn
      @foxlearn  6 років тому

      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?