on 05-14-2009 8:35 AM
Hi,
I have a report with following layout:
City- Restaurant
City1 Rest1
City1 Rest2
City1 Rest3
There is an option to suppress duplicate records and now my report looks like:
City- Restaurant
City1 Rest1
-
Rest2
-
Rest3
But I want it to look like below (basically vertically central align the City1):
City- Restaurant
-
Rest1
City1 Rest2
-
Rest3
Can it be achieved while exporting to excel.
Please ignore the (----), it actually means the cell is empty
try using this suppress formula in the for the field.
but first you need to create a summary field that get the count of the records in you group
now create the following formula
place this formula in the group header
whileprintingrecords;
global numbervar counter:=0;
place this formula in the detail section
whileprintingrecords;
global numbervar counter;
counter:= counter + 1
place this formula in the suppress for for the field
whileprintingrecords;
global numbervar counter;
counter <> int(Count ({group summary field)/2+.5)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.