Showing posts with label accomplish. Show all posts
Showing posts with label accomplish. Show all posts

Sunday, March 11, 2012

Dynamically Create Text Objects

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.