Joined: 22 Feb 2012
Online Status: Offline
Posts: 1
Topic: Execute stored procedure with parameters Posted: 22 Feb 2012 at 6:44am
Hello, in my first post here i'd like to expose a problem with a stored procedure with parameters.
The fact is that i need to execute a sp with 2 parameters. Both are taken from the report's result and one is a summatory from a field given in the header's group section.
The SP returns a date for each new group. I hope someone can help me. Thanks for your time.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 23 Feb 2012 at 4:57am
you could only do this in a subreport...CR doesn't reselect data after the initial select. The only way to read data again is to use a subreport, as CR sees this as a new report and needs to select data for it.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum