Hello, I'm not sure if this is possible but I'm really stuck on how else to accomplish what I'm trying to do!!
I need to display all of a companies departments and summary data with them. I need to always display the department, even if there is no data and the number of departments is always different. My data needs to look something like this:
Dept Summary Field 1 Summary Field 2
-- ----- -----
1 100 100
2 200 200
3 0 0
etc..
Is it possible to take a formula that I wrote that reads in all of the departments and strings them together like 1,2,3,etc and dynamically write these values into text boxes in the report header? I know I could do this if I had a fixed number of departments but I don't know how to do this dynamically.
If this isn't possible, is it somehow possible for me to force a group to display departments that don't have any data to summarize? Thanks so much!
Steph-more details please|||What I need is a report that displays all of the department numbers along with a count of how many technical support issues they had each month and how many technical support resolutions they had each month.
Even if a department did not have any technical support issues, I still need to display that department with a value of zero for tech support issues and tech support issues resolved.
I've tried a bunch of different ways to accomplish this including using a group. Now I'm new at using crystal but it seems to me that if a department had no tech support issues then the department did not even show up in the group. I can't have this.
So essentially I'm trying to find a creative way to write my report so that I can always show all departments whether they had support issues or not. I'm open to any approaches that will get this done.
Thanks so much for helping a confused rookie!!
Stepanie.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment