great question....

I"m actually thinking of writing a follow up article on the CodeGen'd sprocs.

so we basically have an xml file that lists all reports by name and it lists the parameters for the report, the select(s) for the report, the where clause, the sort and the group by

we then read this xml file and for each report node in the xml we run the report data through a code gen template using Nant.

you should be able to read up on the Use of Nant and CodeGen Templates to get a start. I wish I could just send you our xml and our template file but that might get me in a little hot water here......

please feel free to email me if you have more questions (my email is listed in my profile page).

cheers,

GAJ