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!
Pass parameters via URL
- Thread starter strom99
- Start date
Yes, it is possible to do so...
Here are the steps to do this :-
1. Create an object in the universe . The SELECT statement will be :
'<A HREF=" Unit')+'">+TableName.FieldName+</A>'
Doc1 = Name of the document
R= Type of document...R for BO Report W for WEBI report
9=Document ID
Document = name of the repository
Y=refresh when opening
Parameter1= This is the value of the field which is passed to another report (for example, this object is an account no. and for the child report u need to pass this a/c no. to show the details of that account)
Parameter2 = value based on the prompt from the parent table.(ie. in the above example, 'Business Unit' is a prompt in the parent report and is now passed as a parameter to the child report).
HTH....Let me know if it is not clear to u...
Vandys
Here are the steps to do this :-
1. Create an object in the universe . The SELECT statement will be :
'<A HREF=" Unit')+'">+TableName.FieldName+</A>'
Doc1 = Name of the document
R= Type of document...R for BO Report W for WEBI report
9=Document ID
Document = name of the repository
Y=refresh when opening
Parameter1= This is the value of the field which is passed to another report (for example, this object is an account no. and for the child report u need to pass this a/c no. to show the details of that account)
Parameter2 = value based on the prompt from the parent table.(ie. in the above example, 'Business Unit' is a prompt in the parent report and is now passed as a parameter to the child report).
HTH....Let me know if it is not clear to u...
Vandys
- Status