Post reply

usage of multiple datasets in a single table in ssrs

  • February 3, 2009 at 11:18 pm

    #218229

    hi,

    i have a table linked to a datest in ssrs . however there is another dataset which hast the formatting condition(dynamic) for formatting the table.how can data for the second dataset be used for formatting the original table

  • February 3, 2009 at 11:48 pm

    #937725

    Hello,

    You could base the report on a dataset that is formed by a join of the two tables, that way the report will have access to both the data and formatting conditions, for each record.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • February 4, 2009 at 2:50 am

    #937775

    thnx john for replying

    But the 2 tables do not have a common relationship. however i have resolved this problem by modifying the query of tjhe main dataset.

    still is it possible to use two datasets in a single table?

  • February 4, 2009 at 6:19 am

    #937872

    You can reference fields from a different dataset than the one your table is associated with, by specifying the dataset name when you reference the field. Like so -

    =First(Fields!Description.Value, "Company")

    Where "Company" is the name of the second dataset.

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

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