I am creating a Webi XIR2 report where I want to link two tabs (Summary and Detail) in the same report and I am able to do it successfully but the problem is when I click on the Hyperlink Object in Summary tab ,the Detail tab opens with correct data , but then the Summary tab drills down to the same data and eventually you land up refreshing the entire report again to click on different Value
Ex:
There is a variable with name Account
="<a href=“servername
sWindow=New&iDocID=1922963&sReportName=“URLEncode(“Detail”)”&sType=wid
&sRefresh=N&lsM2.Please+enter+Account+Number=“Account Number”&lsM3.Enter+Product+Category=“Product Category”
&lsS1.Enter+Report+Date=“Effective Date”&lsM4.Enter+Custodian=“Custodian Name””>“Account Number”"
Now there are 4 values in Summary tab under Account column
Account
AC100
R2000
ASW11
ADR12
When I click on AC100 the Detail tab displays required data. But in Summary the table drills down to AC100 row only and I have to refresh again the report to see other data.
Account
AC100
Is there any way were the Summary tab is not changed when clicked on the values.
I have gone thru forum also but dint find anything. Can someone please help me if I am missing something?
Also if this doesnt work then can anyone suggest me any other way to achieve this requirement.
I am not sure if I understood your problem correctly. Let me explain to you what my understanding is
Basically you have a hyperlink and also a drilldown on a same column and hence when you click on a cell in the column, the underlying hyperlink opens correctly but the report also drillsdown and there is no way of coming back up because the drill up arrow disappears and hence why you need to refresh the report again?
Is that correct?
If it is, you can prevent the disappearning of the drill up button by using an alert. The solution is described in this topic.
Actually my bad…I shouldnt have used drill word… i am not using any drill… its just simple hyperlinking of SUmmary and Detail tab on a column… So when I click on any value in that column in Summary Tab it goes to Detail tab correctly and shows that vaue details… but my problem now is whn I come back to Summary tab I see the report is filtered to that value that I had clicked . I want to see all values in Summary tab…
It something like the report is hitting database whenever u click on value… and both Summary and Detail tab displays the same value
(BOB member since 2010-04-29)