Issue in linking webi reports

[Former Member]

Hi Experts,

I tried linking two reports using document linking, but when I enter the date values in the document prompt (as highlighted in the fig 2) in the 'Edit Hyperlink window' the 'Reason for Returns' column is getting expanded corresponding to the Start date and End date (as shown in fig 3). My requirement is to show only distinct values in the 'Reason for Returns' column (as shown in fig 1). Kindly help me in resolving this issue.

   fig.1

   fig.2

   fig.3

[tanveer1]

Hi Abin,

In the Table for the column Returns Quantity, instead of measure use this formula

= [Returns Quantity] IN (Reasons for Return)

Also why are you trying to pass the start date and end date ? how are they linked to the detail report ?

Many Thanks,

Tanveer.

[Former Member]

Hi Tanveer,

In the first WEBI report I am filtering the data according to the start date and end date. So the second report which is linked to the first one also required the date filtering.

As you suggested I tried using the formula instead of measure, unfortunately it's also showing the same output as before.

[Former Member]

Hi,

Try Formula instead of object

Min([StartDate])

And

Max([EndDate])

[Former Member]

Hi Nikhil,

I tried the logic you mentioned, but the same problem happened when I am trying to apply the link.Kindly suggested the solution for that.