We currently have a report that shows details of purchase orders, which looks something like this: <table> <tr> <td>PO Number</td> <td>PO Status</td> <td>Amount</td> <td>Expense Type</td> <td>Customer</td> </tr> <tr> <td>1</td> <td>Pending</td> <td>300</td> <td>Utilities</td> <td>IBM</td> </tr> <tr> <td>2</td> <td>Completed</td> <td>300</td> <td>Utilities</td> <td>Microsoft</td> </tr> </table> Each PO has one or more PO items. I have been tasked with adding some of the PO Item details to the report. Most of the PO's will only have a single item,but in some cases, there may be more than one. There are a few things I am trying to do that I don't know how to do: 1)How do I add column data to the row that the row group is on? The actual report contains about 10 columns of data, and I would like to display it on the same row as the group by column. 2) Is it possible to orchestrate the drilldown so that if there is only one child item, it gets displayed on the group by row, and there is no expand/collapse icon on the group, and if there are multiple child items then the grouping works normally? 3) In some cases, the child data will not contain something I need to show, so in those cases, is it possible to just ignore it based on some value in the query?

Hi Jimsurf, For the first one, if we want to add column data to the row that the row group is on, we can just add a column to the corresponding position and then drag the field to the column. For the second one, in a drill-down report, the child items display or not when previewing report depend on the setting when the report initially run. If you set it to hidden, so when you previewing the child items will not be displayed no matter how many child items it has. For more information about drill-down report, please see: http://msdn.microsoft.com/en-us/library/aa255841(v=sql.80).aspx For the third one, you can set the visibility on the report items base on some special conditions. If you want to ignore some values, so you can set the visibility of them to hidden base on your condition. Hope this helps. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Hi Jimsurf, For the first one, if we want to add column data to the row that the row group is on, we can just add a column to the corresponding position and then drag the field to the column. For the second one, in a drill-down report, the child items display or not when previewing report depend on the setting when the report initially run. If you set it to hidden, so when you previewing the child items will not be displayed no matter how many child items it has. For more information about drill-down report, please see: http://msdn.microsoft.com/en-us/library/aa255841(v=sql.80).aspx For the third one, you can set the visibility on the report items base on some special conditions. If you want to ignore some values, so you can set the visibility of them to hidden base on your condition. Hope this helps. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.