I have a summary and detailed WebI reports with location as the prompt in the detailed report.
I have set up a hyperlink on this column in the first report using Open Document URL syntax.
The problem here the location is not getting passed as the prompt value to the second report.
What could be the issue here ? I have also tried passing hard coded location value but still I get "No data to retrieve in Query 1" message
Following is the syntax I'm using :
Let me know if something is wrong here.