how do i assing multiple datasources to a single report asp.net C#

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kd sial
    New Member
    • Mar 2011
    • 1

    how do i assing multiple datasources to a single report asp.net C#

    Actually i am new one for Reporting in asp.net C#

    I have 3 data sources.

    One data source I want to display on same report as DataList Format in Ractangele control of report.

    The other two data source I want to merge code behind and then assign it to the same report and display as a gird format in Table control of report.

    So how can I do this approach can any one paste code here where i get idea.

    Also I want to use input parameters for the report.
    Can I assign dynamically values from datatable to the report.rdlc TextBoxes like this

    Code:
    MyText = CType(ReportDocument.ReportDefinition.ReportObjects(Text3), TextObject);
    MyText.Text = ds.Table(0).Row(0).Item(0).ToString() ;
    Last edited by Frinavale; Jul 27 '11, 06:54 PM. Reason: Added punctuation and attempted to fix grammar as much as I could figure out. Also added code tags.
  • kadghar
    Recognized Expert Top Contributor
    • Apr 2007
    • 1302

    #2
    If the data comes from 3 different sources, i think you'll have to merge them manually via code in a fourth table or dataset, and then show that one in your grid.

    Comment

    Working...