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

Group Naming

Status
Not open for further replies.

3dthies

Programmer
Mar 12, 2003
77
0
0
DE
I have a group which shows the years in a monthly order in the format mm/yy (01/07 .. 02/07 and so on)

For a specific date range (06/07,07/07 and 08/07 I have to put in text "blabla" instead of the normal group name
 
Go to report->group expert->date group->options->customize group name->use a formula for the group name->x+2 and enter:

if month({table.date}) in 6 to 8 then
"Summer Session" else
totext(month({table.date}),"00")+"/"+ right(totext(year({table.date}),0,""),2)

-LB
 
in the section where u have your group name use this formula insted of the group name.

create a formula liek this and replace with the group name.
if {Command.field_on_which_group_is_made} = 06/07
or
if {Command.field_on_which_group_is_made} = 07/07
or
if {Command.field_on_which_group_is_made} = 08/07

then
"blabla"
else {Command.field_on_which_group_is_made}

Let me know if it works.

pkra.
 
I have to make changes to an old system written in Crystal Reports 8.5. We had the old install CD, but I am recieving error crw32.exe when connecting to the database. It looks like I need 8.5.3.975 to fix this. Business Objects no longer supports this version. Is there anywhere I can get this service pack?
omoralez
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top