Post reply

Using multiple datasets in SSRS

  • November 4, 2009 at 5:55 am

    #213186

    Hi users..

    Is there any way to refer data from morethan one dataset to a single table..? When I tried the second dataset value is coming as =First(Fields!fieldname.Value, "sdataset2") , so it gives the first value only..

    Is there any other way to get it done , other than using two table in the report.

    Thanks,

    MC

    Thanks & Regards,
    MC

  • November 8, 2009 at 8:31 am

    #1076454

    Hi ,

    If it s neccessary to use two dataset,then Use the concept of Subreports

    Place a subreport in the table of ur First report

    Create another Report with the Invoice Details Dataset with Invoice No as ur Parameter (Inv Detail report)

    Link the Subreport in First report with the second report (Inv detail Report)

    Define Parameter as InvoiceNo in first report.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • November 9, 2009 at 5:26 am

    #1076600

    Hi Thanks for reply,

    In my case the situation is I need to make use of a filed from the second dataset, in the expresion of a details field in a table (which is using first dataset).

    Regards,

    MC

    Thanks & Regards,
    MC

  • November 9, 2009 at 11:02 am

    #1076797

    It is possible to use multiple datasets in a single report table, but only one dataset can be for detailed data; All other datasets can be used to get aggregated values.

    Could you elaborate your requirement.

    Some more information at this article:

  • November 9, 2009 at 11:03 am

    #1076798

    http://sqlandssrs.blogspot.com/2009/11/single-report-table-fetching-data-from.html

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply