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

Display text in a crosstab

Started by SCI Guy, 09 Aug 2013 03:25:36 PM

Previous topic - Next topic

SCI Guy

I'm new to Cognos and have a request.

Background - distribution system query shipping lane, batch, and then data about each store

Need to turn this into a crosstab so that the lanes are the columns, the batch are rows and then each intersection is a table.  The table would actually be the result of an html string expression.  I can write the expression.  Just don't know how I can get it into the crosstab intersection and display.

See attached image of query output and intended layout design.

Already tried repeater table, which would have been perfect but I need the columns and rows to be controlled like a crosstab

Again, I'm a newbie.  Please be specific if providing instructions.  I have found several posts on the internet that tell you how to do this for a single field value, but none of the instructions are specific enough (to much ambiguity) to actually read and execute.

Really appreciate any help.