Report Designer and External Text RRS feed

  • Question

  • Hi:

       In Vb6, this can be easily done:

     Adodc4.RecordSource = "Select Seq,Reading,UCL,Nom, LCL,Round((Noml-Reading),1) As Descrepencies,IIF(Descrepencies <= UCL AND Descrepencies >=LCL, 'Passed', 'FAILED') as Status From HistoryReading_R Where T_ID='" & Text1.Text & "' And PPoint ='" & Text2.Text & "' Order By Seq"
        load DataReport3
        Set DataReport3.DataSource = Adodc4
        DataReport3.Sections("Section4").Controls("Label8").Caption = Text1.Text
        DataReport3.Sections("Section4").Controls("Label10").Caption = Text3.Text
        DataReport3.Sections("Section4").Controls("Label13").Caption = Text2.Text
        DataReport3.Sections("Section4").Controls("Label15").Caption = Text4.Text
        DataReport3.Sections("Section4").Controls("Label17").Caption = Text5.Text
        DataReport3.Sections("Section4").Controls("Label19").Caption = Text6.Text

    Can I do the same with VS2005/2008 Report Designer?




    Davinci Blurr
    Tuesday, July 27, 2010 5:53 AM


  • You can configure report parameters in your RDLC report in Report Designer and use the parameters in your report. Then, supply the values at run time using the LocalReport.SetParameters(name, value) method.
    Cephas Lin This posting is provided "AS IS" with no warranties.
    • Marked as answer by JetEan Wednesday, July 28, 2010 1:44 AM
    Tuesday, July 27, 2010 2:57 PM