Suppose a subreport calls a stored procedure. My Understanding is that regardless of the number of instances of the subreport in a given execution, the stored procedure gets called only once. Is there any way to change this configuration, such that I can pass subreport instance-specific parameters to the stored procedure, providing different results for each subreport instance?

Hi DBlank

Thanks for your reply.

Not too sure of what you mean by 'where', but if this helps: The report is an event calendar, in which each event is a record in the main report. One of the subreports is 'Sponsors' (optional) which sometimes has more than one record per event, which I'd like to group together as a comma separated sentence, but I'm finding that rather difficult. I'd hence like to just write a stored proc to do this for me, but to make the stored proc shorter, it'd be great if I could call it once per event rather than just once per report, but as I said, my understanding is that each stored proc associated with a report runs just once. Am I wrong? Or is this actually configurable? If the latter, how do I do it?

Cheers
Tristan