Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

is there a Cross Tab alternative???? 1

Status
Not open for further replies.

mstelmac

Technical User
Oct 22, 2003
53
US
record_id priority
num00001 1
num00002 1
num00003 2
num00004 2

Hi guys, new CR developer here. I have 4 records that I created a group for. Now I want to subtotal the group (i.e. there are 2 priority 1 and 2 priority 2 records). I need to have the totals on the report footer page and the crosstabs functionality does not allow the format that I want. I figured that I could draw the figure that I wanted and insert two formula fields.
count ({table_name.sum_priority_1}) = "1"
count ({table_name.sum_priority_2}) = "2"
I was then going to insert these formula fields into my homemade chart, but the formula doesn't work!!!!!!
Any suggestions? Your help would be greatly appreciated.

 
I wonder what a homemade chart is...

Anyway, try using a Running Total Field, and in the Evaluate->Use a Formula place:

{table_name.sum_priority_1} = "1"

for the ones, and

({table_name.sum_priority_1}) = "2"

for the twos.

-k
 
synapsevampire,
Thanks very much for your response. It worked perfectly and was exactly what I needed.
-matt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top