Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a stored procedure parameter from a main report to subreport?

Status
Not open for further replies.
shadow902

shadow902

Programmer
Apr 27, 2001
1
US
I have created a subreport based upon an Oracle 8.1.6 stored procedure with one parameter which is vital to the selection formula for the subreport. The stored procedure parameter is equal to the primary key value from the main report. I have the primary key value of the main report on the main report - I wish to pass this information to the subreport and have the stored procedure use it to select which data to return to the subreport display. Is this possible? If so, tell me how it is done?

Thank You
 
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
401
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
259
SoftwareRT
SoftwareRT
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
359
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
482
hilfy
hilfy
Ajmal N
  • Locked
  • Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
344
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top