June 15, 2015 at 5:34 am
Hi everyone,
I've tried various methods to get this to work, but in each case run into an issue. I have a simple table within a report, which has a single row group, with 3 "group on" fields. The rest of the fields are either summing the group, or an expression for percentages. The data once grouped looks something like:
COUNRY, MONTH, CODE, OTHER COLUMNS (SUMS AND PERCENTAGES).....
UK, MARCH, 1,
UK, MARCH, 2,
UK, APRIL, 1,
USA, MARCH, 1,
USA, APRIL, 2,
USA, MAY, 1,
FRANCE, MAY, 1,
FRANCE, MAY, 2,
Currently, there is a border around each cell once the report is run. I want a bolder line, under each overall group (COUNTRY is the outermost member in the group). So between, UK and USA I want a line going all the way across. Also the same between USA and FRANCE.
I don't think I can use the ROW_NUMBER() method in the dataset, due to me using a shared dataset, with calculated fields in the report, which form 2 of the 3 "group on" fields. So I cant add this into the source.
I've tried the IIF expression with the Previous(), First(), methods, but I get a "has a scope parameter that is not valid for an aggregate function" error.
Should I be using Parent/Child row groups? Can anyone provide some guidance or tips?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply