need values in single row

[madhancog]

Hi gurus,
  I need a report that should show the values in single row.
  i am attaching the current output and expected output along with it.

Thanks in advance
K.M

[Arsenal]

doubt you can get what you need without creating a huge concatenated list of every product that your client has and that too it better have a separate column for each product or have a cube

when you group a list, then every column is grouped and rolled up under the appropriate value till a "break" occurs. That is, till it comes across values which are different but have the same preceeding columns, In your case, it is the Products column. At this point, products will be listed in separate rows. At best, you can control the way the preceeding columns have row reptitions (so for example, you can get Apr 2011 to repeat for each row of the products column).

Would be interested to know if someone else knows of a way somehow

[madhancog]

Hi,
  I have done this with the help of repeater,but still my problem is i am having comma at the end of the last product.

Thanks
K.M

[Lynn]

You can suppress the last column if you add a total count and a running count data item to your query. Include them in the properties of the repeater. Then create an advanced conditional style on the comma text item.

You'd have one expression for "all other values" that would be the default style (no need to edit the style). Then add an expression e.g.,

Code Select Expand


[ReportQuery].[MyTotalCount] = [ReportQuery].[MyRunningCount]

Then edit the style for that expression to be box type none.

If you looked at the tabular data that has Product, MyRunningCount and MyTotalCount you'd see:

Code Select Expand


A   1   3
B   2   3
C   3   3


The comma would appear after A and B because running count is not equal to total count. It would be supressed after C because the two figures are equal.

[CognosPaul]

Instead of doing it like that, put the ' ,' in front of the item and put a render variable where RowNumber<>1.

Total counts are expensive.

[Lynn]

 8) 8) 8) 8)

Paul is awesome! Much better!!