I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 - CA User2 - CA User3 - CA N/A User1 - CO User2 - CO User3 - CO and so on. I am hard coding N/A as the default value for each and every state, as crystal reports XI does not accept a blank value as the default. Is there a way to eliminate multiple occurrences of N/A from the input parameter? Is there a workaround where I can display only the users from each and every state, like User1 - CA User2 - CA User3 - CA User1 - CO User2 - CO User3 - CO and so on? Any help on this is greatly appreciated. Thank you! K