July 21, 2015 at 12:56 pm
I have one original dataset that works fine in a tablix. I added a new dataset with one new field in there. However, this new field is not showing up when I click on the pull down menu in a tablix column. The pull down menu only shows the fields in my original dataset, but not the new field in my new dataset.
Any idea how to make my new field showing up? I tried clicking on "refresh field" and it didn't help. I am running SSRS 2014. Both datasets are embedded. Thanks.
July 21, 2015 at 1:05 pm
sounds like you have to change the dataset. If you drag a field from the list onto the tablix, it will bind the tablix to the dataset that the field belongs to. you could show the properties of the tablix and see which dataset it's bound to. I bet it's bound to the old one.
July 21, 2015 at 2:12 pm
I see. I guess a tablix can only bound to 1 dataset. I will just create a new tablix to use the 2nd dataset then.
July 21, 2015 at 2:37 pm
about the only thing you might be able to do is use LOOKUP to get data from the other dataset. Other than that, you'd have to combine them in a query if you absolutely had to have all the data from both in one tablix.
Here's the MS link... not my favorite:
https://msdn.microsoft.com/en-us/library/ee210531.aspx
There's one on YouTube that walks you through it (takes about 5 mins... )
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply