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 IamaSherpa 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
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