I want to use a dropdown parameter to actually populate another dropdown parameter ? As in department dropdown parameter populates the division dropdown parameter. Is it possible to do this in SQL Reporting Services 2000 ?

Sure. To create cascading parameters, simply reference the first parameter in the dataset query (i.e. ...where department=@Department) for the second parameter list. Make sure parameters are arranged in the right order in the Report Parameters dialog. This is on page 106 in the 2000 book and on page 138 in the 2005 book.

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner