Document link prompt issues in webi reports

[rameshparchuri5]

Hi Team,

in my webi report master and child report . once click the master report value (12345), based on the child report refresh .

my scenario is like this ...if click (12345) we have added documents link in master report

user request to click 12345 ,in report pick the the LOT and Sub_lot information for that (12345).

but in both columns we don't have 12345 value .so we are created =substr([LOT];1;5] variable .

in child report we are calling that variable (substg([LOT];1;5]) but it's not working .because in DB don't have (12345)value. so we get not data message . how to fix this problem.

in document link prompt not matching master (substr([LOT];1;5]) /child lot

master report:

LOT

12345 (user click this )

12346 (user click this )

out put for child report:

LOT Sub_Lot
---- --------
12345-A 12345-A-1
12345-B 12345-B-2
12345-C 12345-C-3
12346-A 12346-A-1
12346-B 12346-B-2
12346-C 12346-C-3

any one help on this

Thanks

[jyothirmayee_s]

Hi,

What is your Database?. Are you expecting the data to populate which is not in DB?.

How is your Document link properties are?.

Thanks,

Jothi