I think I have read every thread on this subject but none really pertain to what I am trying to accomplish.
I have a report that uses 2 subreports, one that totals all unposted sales and one that totals posted sales. I set up shared variables in both reports that i use to creates a total in the main report of these 2 variables.
Is there anyway I can set up a ranking formula or system to rank the Total of these 2 shared variables?
I am trying to think if it can be done with an array or running totals, but my ears are smoking, and I don't want to bog down the report anymore than it already is.
I know how to do it with an export to excel, but that would require user interaction, and we can't really have that.
Thanks in advance!!
I have a report that uses 2 subreports, one that totals all unposted sales and one that totals posted sales. I set up shared variables in both reports that i use to creates a total in the main report of these 2 variables.
Is there anyway I can set up a ranking formula or system to rank the Total of these 2 shared variables?
I am trying to think if it can be done with an array or running totals, but my ears are smoking, and I don't want to bog down the report anymore than it already is.
I know how to do it with an export to excel, but that would require user interaction, and we can't really have that.
Thanks in advance!!