on 09-09-2007 6:57 PM
Post Author: cht104
CA Forum: Formula
I've created a report to show number, date and amount. It works, but I want the numbers to be changed to a names in the group header only. I"ve tried several if / then or case statements, but keep getting different errors. Where should I create the formula? Is it a formula field or a SQL expression field?
I'm pulling 3 fields from 1 table; number date amount. The number column has a header of Group 1 Name. Group 1 Name is what I would like to use the IF expression
IF number = "12345" then Sam IF number = "54321" than Tom I've got multiple number -> name changes to make.
I know that I'm over thinking or trying to make more difficult than it should be and would greatly appreciate any help or suggestions.
Post Author: cht104
CA Forum: Formula
Thanks. I finally got it. I just had my db and table in the wrong brackets.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post Author: bettername
CA Forum: Formula
Unless I misunderstand, it's pretty straightforward! Create a formula called "name_to_number":
if number = 12345 then "Sam" else
if number = 54321 then "Tom" else
...
else totext(number,0)
Then group by name_to_number, but leave in the details section.
This will give you:
Group Header: Sam
Details: 12345 01/01/2006 54
Details: 12345 02/04/2006 2
Details: 12345 16/06/2006 34
Group Footer: <empty>
Group Header: Tom
Details: 54321 11/01/2006 19
Details: 54321 07/02/2006 4
Details: 54321 10/03/2006 86
Group Footer: <empty>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.