1. I have a livereport which selects distinct aduditstr from dauditnew
2. I have a web report which has the above livereport as its souce. I have created a drop down assosiating the auditstr in the webreport and the drop down has the distinct auditstr values from dauditnew table.
Till here it is fine
3. I have a main web report which has a custom parameter to which the above webreport is assosiated.
My aim is to get a report(select dataid,auditstr from llw.dauditnew where auditstr=user selection from the drop down) based on the user selection in the drop down.
For which, I have put the below piece of code in the LL_WebReport_StartRow
[LL_WEBREPORT_INCLUDEIF "[LL_REPTAG_2 /]" IN "[LL_REPTAG_&AUDITSTRP1 /]" /]
where LL_REPTAG_2 is the auditstr column name and
AUDITSTRP1 is the name of the custom parameter in the main web report.
I am not getting any results when I select one value from the drop down and click on RunReport. But I know that there are records in the database for the selection made.
I appreciate your help.Looking forward for a reply.
Thank You,
Sunu
2. I have a web report which has the above livereport as its souce. I have created a drop down assosiating the auditstr in the webreport and the drop down has the distinct auditstr values from dauditnew table.
Till here it is fine
3. I have a main web report which has a custom parameter to which the above webreport is assosiated.
My aim is to get a report(select dataid,auditstr from llw.dauditnew where auditstr=user selection from the drop down) based on the user selection in the drop down.
For which, I have put the below piece of code in the LL_WebReport_StartRow
[LL_WEBREPORT_INCLUDEIF "[LL_REPTAG_2 /]" IN "[LL_REPTAG_&AUDITSTRP1 /]" /]
where LL_REPTAG_2 is the auditstr column name and
AUDITSTRP1 is the name of the custom parameter in the main web report.
I am not getting any results when I select one value from the drop down and click on RunReport. But I know that there are records in the database for the selection made.
I appreciate your help.Looking forward for a reply.
Thank You,
Sunu