Hi All,
This is a kind of dilemma to me. I want Excel to display multiple tabs when I export my report to Excel with the name coming from the group
I have properly set the Page break location to be between but unfortunately under the page name , I cannot set the field as it is showing the report item not linked to a dataset even though the dataset name is properly set in the tablix. However, looking at Dataset in this set expression for page break, I could see the dataset there but the values are coming up as First(group) which is not what I want.
Any idea why this is happening and how to resolve this.