Adding individual data items to list

[intrepid402]

Hi
I would like to add individual data items to each list cells in a list. I am only able to drag and drop columns. If I drag a data item, that data item is being displayed in the entire column, instead, I want it to be displayed in a single cell.

Thank you!

[tjohnson3050]

There is an icon that looks like a padlock on the toolbar.  If you click that icon, it will 'unlock' the report and allow you to put more than a single data item in a column.

[intrepid402]

Hi TJjohnson!
Thank you for your reply. I did that and I added Data Item 1 in a cell, and the entire column is displaying Data Item 1. I only want data item to be displayed in one specific cell instead of the entire column.

[blom0344]

Check out the use of singletons..  (And by the way, this is not a spreadsheet , but a BI tool) combining them with additional header lines within a list

[intrepid402]

Hi Blom,
My understanding is that using so many singletons will affect the performance of the report?I am going to have 13 x 12 number of cells.

[tjohnson3050]

It sounds like what you want is a cross tab instead of a list.

[intrepid402]

Again the problem with that is not all the values are numeric. Half of them are varchar and half of them are numeric.

[blom0344]

A table within a list would be another solution, though it requires fetching everything within 1 query (the one associated with the list) Still feel you are trying to mimic a spreadsheet though..