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
Software/Hardware used:
ASKED:
September 28, 2010 4:02 AM
UPDATED:
September 28, 2010 10:03 AM