As per requirement i have created a report which has 2 Tablix's both have different data. Now i have to export tablix1 data to Excel(tablix2 should not come in excel) Tablix2 to .dat file/text file(tablix1 data should not come). Right now if i export to .dat file data from tablix1 also coming. Note:i have updated report server config to generate .dat file Please suggest how we can do this in ssrs.
