What would be the best was to use SSRS to export datasets to excel.
In some cases - I want to enter criteria - and only have the option to see the results as an excel file.
Or alternatively some reports will be formatted so certain fields of the dataset are textboxes on the rdl report. However I also want to be able to output the full dataset (with the same report parameters applied) to excel.
Thanks for any assistance in advance.