Friday, March 30, 2012

Report Parameters

Is there a way to force report designer overlook parameter dependencies, so that a report could be displayed by either of the two parameters although one parameter accepts but not requires the other?

For Example:

In my report I have two parameters, DeptID and ProjectID. The two drop downs display Departments and Projects respectively but only if the department is selected, the Projects list becomes active as its expecting a DepartmentID in the stored proc but accepts a null value as well. So, what I would like to achieve is display ALL projects in the Projects list, even if no department is selected. Any ideas how to do that?

Thanks.

Essentially what I need is to be able to filter the Projects List and not necessarily depend on the DepartmentID of the selected value in Department List. Kind of like filtering on Report Parameters without using Cascading Parameters?|||

Hello,

why can't you have all Departments selected as default. The the user does not have to select departments id actively in order to select projects.

No comments:

Post a Comment