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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add subtitle in a group

Status
Not open for further replies.

jcao0000

MIS
Jun 4, 2007
12
CA
Can anyone help how to add subtitle inside a group?

Currently the report shows:
Dept A
Dept B
Dept C
Dept D
...
They are all in the Group Header showing Command.Dept.

Now I want to add subtitle so that the report shows:
Subtitle 1
Dept A
Dept B
Subtitle
Dept C
Dept D

How can i do it?
Any help is appreciated!
 
Create a formula like:

if {table.dept} in ["A","B"] then "Subtitle 1" else
if {table.dept} in {"C","D"] then "Subtitle 2"

Then insert a group on this and make it your group #1.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top