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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: