Tuesday, April 1, 2014

Formatting output so that data repeated between rows is not shown

Hi Everyone,


Here is a snippet of some sample data from a report that I have just written -



Notice above that the 'Item Code', 'Item Description', and 'Order Qty' all repeat for rows 2 and 3.


I would like to remove the repeated data (and ideally replace it with 'empty' cells), similar to the snippet below -



I am connecting to an MS SQL Server 2008 R2 database, and therefore I have come to believe I cannot use the IIF(...) function, as detailed in this link.


How can I go about formatting the data as indicated above?


Any help will be greatly appreciated.


Kind Regards,


David


No comments:

Post a Comment