I am currently in the testing phase of WebFOCUS and am creating a test report.

I have an HTML file that links two accordion reports of Counts: Alumni by Geographic Region and Alumni by US State & City OR International City (the State / City = DM if / DM Label / DM Go to). I have a parameter that allows the user to filter the report with those coded "Do Not Mail".

How do I add a parameter to allow the user to filter the report by School (Business, Arts & Science, etc.) and Degree (Bachelor, Masters, etc.)?

I tried adding the following in the WHERE/IF of both reports, but it's not populating in the HTML (By School):

WHERE ( J1.USF_AA_DEGREE_USF.DEGREE_1 EQ &DEGREE_1.(OR(,,,,,,,,,)).Degree. ) OR ( J1.USF_AA_DEGREE_USF.DEGREE_2 EQ &DEGREE_2.(OR(,,,,,,,,,)).Degree. );

How do I get this parameter set into the HTML file for filtering the alumni counts?

This message has been edited. Last edited by: Kerry,

Do you have a parameter, i.e. amper variable for school?

Then re-import your report procedure into the HTML Composer.