Dynamically Create Text Objects

[StephanieHarris]

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-

[harmonycitra]

more details please

[StephanieHarris]

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.