Hi Craig

not quite sure what you mean by that.

I'm creating the report in crystal. (Version 11)

The main report asks for start and end date and an organisation code as a parameter.

I want to use the same values in the sub report stored procedure.

I've added the stored procedure as as the data source for the sub report but I can't find where I can pass across and set the parameters for the stored procedure so I'm getting asked twice.

Thanks

(enjoy you holiday. I hope you're doing something nice.)

Nick



>I'm on vacation and don't have access to the docs right now but if you drill into the CR object model you'll find a parameter object. Populate that before accessing the data.
>
>>HI
>>
>> have a crystal report with some sub reports in it.
>>
>>I've altered one of the sub reports to use a stored procedure.
>>
>>The previous sub report accepted some parameters and I want to feed those parameters into my Stored procedure but I can't see how I establish that connection.
>>
>>At the moment the report prompts for the report parameters and additionally prompts for the stored procedure parameters.
>>
>>Anyone know ?
>>
>>Thanks
>>
>>Nick