Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Web Report with drop down

Status
Not open for further replies.

hanreb

Technical User
Jan 23, 2008
90
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top