Loop Stored Procedure?

[Icarus050]

Hey all.

Not idea if what I need it possible.. but here goes.

There is a stored procedure which does exactly what I need, but the results it produces are not separated by month (so if I ask for 3 months of data, it gives an over all result, not one split into months).

Is there a way I can have Crystal run the procedure say 3 times (for 3 separate months) and then display the results?

Cheers,
Ic.

 

[IanWaterman]

YOu can have a mian report which is just a container for 3 sub reports each running your sp for the month you require.

You can do this by either have 3 parameters in the main report which then link to the month input parameter of your SP.

Or you can have one parameter and then use formula to determine other two months from this parameter and then link formula to SP parameters.

Ian