I thought it wasn't possible to dynamically name the worksheets from a report studio output.
However I have seen a option on 10.2.2 that if you do something
https://www-304.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_frmat_rep_create_page_sets.html%23cr_rptstd_frmat_rep_create_page_sets
you can
I am only using 10.1.1 so first is this an option, and secondly if it is how?
Not in 10.1...you need to go up to 10.2.2
thanks,