11-11-2009 10:39 AM
I hope some can help. I have a pipe line report that reflects the following information in 5 Stages:
1) Purchased last week 100%
2) Commitment to buy this week 99%
3) Commitment to buy in future 75%
4) Quoted and working. 40%
5) Initial communication 10%
In each stage is the Company Name, Contact, Product Name, Total amount of sale, Probability of close (100% 99% 75% 40%) and 10%), Est close date, & Record manager. Here is my problem, I need this report to print starting with the stages:
Purchased last week then By commitment to buy this week and to end with initial communications 10%
I have tried changing the ascending, descending, adding the sort option of probability, page break etc in the Define Sections to no avail. It seems it sorts by the total of the dollar amounts in each stage. How can get it to sort by either the stage or by the probability in %.
11-11-2009 11:23 AM
11-11-2009 12:59 PM
Yes I have done this. "Sort Assending" I can get it to sort starting from the smallest 10% on the 1st page and up to to 100% on the last page. I need this to sort from 100% 1st page down to 10% last page. When I change to decending it mixes it all up.
My work around has been putting page breaks in for each stage so that each stage is printed on it's own sheet of paper. When I print it I simply hand sort the 4 or 5 paged in the correct order. The issue with doing that is the the report header is now on the last page.
If we can't solve the sort decending problem, is there any way to put the report header with total of combined stages on each page as a header? I have tried to do this but it picks up the total for each stage rather than the total for the entire pipline.
11-11-2009 04:48 PM
11-12-2009 05:46 AM
11-12-2009 10:13 AM
11-12-2009 10:27 AM
11-12-2009 10:56 AM
11-12-2009 11:39 AM