<div>
Don't use a crosstab. <br />
The first image above is just a simple listing with no crosstab.
</div>


Don't use a crosstab.
The first image above is just a simple listing with no crosstab.

<div>
How do I get column A into the Type column
</div>


How do I get column A into the Type column

<div>
You need to use a list object, not a crosstab.
</div>


You need to use a list object, not a crosstab.

<div>
I'm using a list but Type field text so how do I update . How do I populate that field. Can you provide an example?
</div>


I'm using a list but Type field text so how do I update . How do I populate that field. Can you provide an example?

<div>
Which DB are you using ? <br />
<br />
You can convert your query to get your output using Unpivot if you are using SQL Server.
</div>


Which DB are you using ?

You can convert your query to get your output using Unpivot if you are using SQL Server.

<div>
<div class="content wysiwyg-content">
I'm trying to create a report in Cognos with the following format:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212719/Dessired-output.png" target="_blank" title="Output (13 KB)"><img alt="Output" class="file-block lazyload" style="max-width: 295px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212719/Dessired-output.png" /></a><br />
My current output is a crosstab query below:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212720/crosstab-query-output.png" target="_blank" title="Crosstab Output (13 KB)"><img alt="Crosstab Output" class="file-block lazyload" style="max-width: 550px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212720/crosstab-query-output.png" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212721/crosstab-query.png" target="_blank" title="Actual CT query (9 KB)"><img alt="Actual CT query" class="file-block lazyload" style="max-width: 404px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212721/crosstab-query.png" /></a>
</div>
</div>


crosstab-query.png

crosstab-query-output.png

Dessired-output.png

I'm trying to create a report in Cognos with the following format:



My current output is a crosstab query below:





Cognos Reporting

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.