ok, I've got a report on the report server that gets clients by state, either individual or all. very simple report, client name and state.
they would like this report monthly, so I wanted to email it, probably by using subscription on report server, but here's the kicker. they want each state in a separate excel file.
any suggestions on the best way to do that? can be script or whatever. i don't know if maybe a script that calls for each state in state column do an excel sheet?