I have a crosstab column whose title is defined by a report expression
substring ( [Query1].[Grade Header] , position('G', [Query1].[Grade Header] ),7)+
substring ( [Query1].[Grade Header] ,2, position('C', [Query1].[Grade Header] )-3)
which gives Grade A Excellent, Grade B Good etc...
I want to display this in two separate lines in Excel
for eg:
Grade A | Grade B
Excellent | Good
Like that... Is there any possible way to crack this?
Try unlocking the report and adding either two blocks (or a two-row table). Then include your expressions separately in each block (or row).