The sheet_label option is the prefix portion of the sheet name. Setting it to ' ' will often get rid of the parts of the worksheet name that you don't want.
The sheet name is generated in the sheet_name event in the tagset. The worksheet naming varies depending upon the setting of the sheet_interval option.
The core of that event looks like this.
/*--------------------------------------------------------------------------eric-*/
/*-- Try to create a reasonable worksheet label based --*/
/*-- on the type of sheet interval we are using. --*/
/*--------------------------------------------------------------------4Jul 03-*/
set $worksheetName $sheet_label ' ' /if $sheet_label;
do /if cmp($sheet_interval, 'none');
set $worksheetName 'Job ' /if ^$sheet_label;
set $worksheetName $worksheetName $numberOfWorksheets ' - ' $label;
else /if cmp($sheet_interval, 'proc');
do /if $proc_label;
set $worksheetName $proc_label /if ^$sheet_label;
else;
set $worksheetName 'Proc ' /if ^$sheet_label;
set $worksheetName $worksheetName total_Proc_count ' - ' $label;
done;
else /if cmp($sheet_interval, 'page');
set $worksheetName 'Page ' /if ^$sheet_label;
set $worksheetName $worksheetName total_page_count ' - ' $label;
else /if cmp($sheet_interval, 'bygroup');
do /if ^$byval_name;
do /if $sheet_label;
set $worksheetName $label ' ' $byGroupLabel;
else;
set $worksheetName $byGroupLabel;
done;
else;
do /if $sheet_label;
set $worksheetName $sheet_label ' ' $last_byval;
else;
set $worksheetName $worksheetName $byval_name '=' $last_byval;
done;
done;
do /if ^$worksheetName;
set $worksheetName 'Table ' /if ^$sheet_label;
set $worksheetName $worksheetName $numberOfWorksheets ' - ' $label;
done;
else /if cmp($sheet_interval, 'table');
set $worksheetName 'Table ' /if ^$sheet_label;
set $worksheetName $worksheetName $numberOfWorksheets ' - ' $label;
done;
... View more
