Skip to Content
0
Former Member
Feb 24, 2011 at 10:04 AM

open a subreport from an existing report without hitting the database

32 Views

Hello Experts,

I want to open a webi subreport with the data from an exisiting webi report directly not from database.currently i am using hyperlink on some measure values and in theses hyperlink, i am using opendocument query and passing the values in the filters created at subreport side,but every time i clicked on hyperlink its opening the subreport but taking data from data base instead of existing report.

i also tried in this way by passing a context from parent report :

I am having country column in my report which is having many countries, i want that when i click on england it should open the subreport with the data only for england from parent report not from database.

="<a href=\"http://server:port/OpenDocument/opendoc/openDocument.jsp?sType=wid&sDocName="URLEncode("aaa")"&sReportName="URLEncode("aaa")"&sReportPart=table name at subreprt""&sPartContext=/country[england]""&sWindow=New""&sRefresh=N""\" title=\"click\" target=\"_new\" nav=\"web\">"[country]"</a>"

Thanks in Advance:)