If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to display text in Column heade in two lines for excel format?

Started by semsel, 11 Apr 2013 06:05:18 AM

Previous topic - Next topic

semsel

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?

Lynn

Try unlocking the report and adding either two blocks (or a two-row table). Then include your expressions separately in each block (or row).