usage of multiple datasets in a single table in ssrs

Question

usage of multiple datasets in a single table in ssrs

rohan_kir

SSC Enthusiast

Points: 109
More actions
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

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

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

John H Marsh SSChampion Points: 11671 More actions · Answer 1

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

rohan_kir SSC Enthusiast Points: 109 More actions · Answer 2

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?

TKD-BB SSC Eights! Points: 993 More actions · Answer 3

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.