Reporting Services - Looping SQL w/o Stored Proc?

bassist695

New member
Joined
Mar 25, 2005
Messages
1
Programming Experience
3-5
I need to loop an entire SQL statement so that it runs for each month in an accounting range. I can accomplish this in a stored procedure, but that just adds another level of complexity.

What syntax capabilities do we have in the Free SQL area when you're building datasets? What I mean by that is the dataset SQL that looks like:

=IIF(Parameters!code.Value=1,"SELECT code FROM t_code","SELECT other FROM t_code")

Can this SQL be looped based on parameters?

Thanks
 
Top Bottom