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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Passing Parameters in WebI Linked Reports
- Thread starter Gaye
- Start date
What problem are you having. Paste you link definition in here and we can help. Steve Krandel
BASE Consulting Group
BASE Consulting Group
- Thread starter
- #3
Steve,
The basis of our report is a drilldown on an object to x level and then using the link object, open the linked report.
We can open the report, however, the drilldown object remains at the top level of the hierarchy.
For example.
Organization Level 1 to 10 = hierarchy objects
Account number = linked object.
The main report allows the user to drilldown the hierarchy to the required level. Then using the account number open up the next report to view data by period.
Here is our linked object's definition
'<A HREF=" = "_Parent" >'+MAX_WRAP_TEST.dbo.tblFormLayout.vcrReportLineId+'</A>'
Do you know how we can pass the hierarchy parameter across at the same time without having to include it as a prompt in the linked report?
The basis of our report is a drilldown on an object to x level and then using the link object, open the linked report.
We can open the report, however, the drilldown object remains at the top level of the hierarchy.
For example.
Organization Level 1 to 10 = hierarchy objects
Account number = linked object.
The main report allows the user to drilldown the hierarchy to the required level. Then using the account number open up the next report to view data by period.
Here is our linked object's definition
'<A HREF=" = "_Parent" >'+MAX_WRAP_TEST.dbo.tblFormLayout.vcrReportLineId+'</A>'
Do you know how we can pass the hierarchy parameter across at the same time without having to include it as a prompt in the linked report?
- Thread starter
- #4
Steve,
The basis of our report is a drilldown on an object to x level and then using the link object, open the linked report.
We can open the report, however, the drilldown object remains at the top level of the hierarchy.
For example.
Organization Level 1 to 10 = hierarchy objects
Account number = linked object.
The main report allows the user to drilldown the hierarchy to the required level. Then using the account number open up the next report to view data by period.
Here is our linked object's definition
'<A HREF=" = "_Parent" >'+MAX_WRAP_TEST.dbo.tblFormLayout.vcrReportLineId+'</A>'
Do you know how we can pass the hierarchy parameter across at the same time without having to include it as a prompt in the linked report?
Thanks
Karen
The basis of our report is a drilldown on an object to x level and then using the link object, open the linked report.
We can open the report, however, the drilldown object remains at the top level of the hierarchy.
For example.
Organization Level 1 to 10 = hierarchy objects
Account number = linked object.
The main report allows the user to drilldown the hierarchy to the required level. Then using the account number open up the next report to view data by period.
Here is our linked object's definition
'<A HREF=" = "_Parent" >'+MAX_WRAP_TEST.dbo.tblFormLayout.vcrReportLineId+'</A>'
Do you know how we can pass the hierarchy parameter across at the same time without having to include it as a prompt in the linked report?
Thanks
Karen
The OpenDocument function only allows you to pass parameters via prompts. There really isn't any way around this unless you want to start getting into heavy SDK coding.
There has been a pretty good discussion of this on busobj.forumtopics.com Steve Krandel
BASE Consulting Group
There has been a pretty good discussion of this on busobj.forumtopics.com Steve Krandel
BASE Consulting Group
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question