In SSRS 2005, I have a report defined with 2 data sets and 2 tables as follows:
table tblYtd uses dataset ytd_ia_rep
table tblFytd uses dataset fytd_ia_rep
Each of these data sets returns the same field list, i just run them with different parameters.
When I go into the Expressions window on the table tblFytd to try to add a field to one of the tables, the only fields listed are those from the first table. So the windows displays Fields (ytd_ia_rep), but not Fields (fytd_ia_rep).
How do I get the fields to show up from the dataset this table uses? fytd_ia_rep