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!

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

Subreport with parameter on WEB

Status
Not open for further replies.

marina

Technical User
Nov 20, 2000
1
GB
My subreport uses data from stored procedure with input parameter. In turn the subreport has to use the parameter also. It workes until I try to put main report on WEB. The question is : How to pass parameter to subreport on the WEB?
It is not posible to do through Link, and subreport's parameter is not the element of main report's parameter Collection.
 
Have you figured this one out yet? I've been away from this forum for a while.

I do have a report that passes a stored procedure parameter value as a subreport link, but I have not put it on the Web yet. If the parameter is not in the main report's parameter list, have you tried adding a corresponding parameter (same data type) to the main report's list, and linking from there?

Mary
 
I use the following below when I need to pass user/pass to a subform, it should work for parameters also I would think. I added what the parameter passing inputs would look like.

<form method=&quot;post&quot; action=&quot;blah.rpt&quot;>
...
<input type=&quot;hidden&quot; name=&quot;USER0@subreportname&quot; value=&quot;crystal&quot; />
<input type=&quot;hidden&quot; name=&quot;PASSWORD0@subreportname&quot; value=&quot;reports&quot; />
<input type=&quot;hidden&quot; name=&quot;prompt0&quot; value=&quot;value&quot; />
<input type=&quot;hidden&quot; name=&quot;prompt0@subreportname&quot; value=&quot;value&quot; />
...
</form>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top