We need to develop a Crystal Report that is dynamic in nature. The user will choose a marketing regional sales manager. We'll need to query the source database to pull the data saved at the division, region, and state level; as well as saved data for the territory sales managers reporting to that regional sales manager. I can see us using the Command object to control the SQL and retreive all relavant data.
My problem is how to dynamically display the data on the report. The business specifications are to show header/column information for each state and regional sales manager within the state. RSM Steve may cover 3 states with 6 TSMs - so his columns would need (for example) 'state 1', 'TSM 1', 'TSM 2', 'state 2', 'TSM 3', 'state 3', 'TSM 4', 'TSM 5', 'TSM 6'. RSM Bill may cover only a different state with 2 TSMs - so his columns might be 'state 4', 'TSM 7', 'TSM 8'. Again the data in the columns isn't the headache right now, it's how to dynamically exhibit the columns.
I'm not even sure if Crystal XI could handle this. Let's say there is a maximum of 60 possible columns (for each possible state and TSM). Is there a way to suppress the columns with no corresponding data returned from the Command object query?
Thanks for viewing this post!
IP Logged
