TH-Soft wrote:
PDFsharp and MigraDoc show the data as you feed it.
Simply group the data before feeding it into PDFsharp or MigraDoc.
Thank you for the reply! I have to admit it left me scratching my head for a moment, but it got me thinking about the query. To make it work as expected I run a query to grab the first item of each category by the lowest ID number creating a temporary table:
Code:
SELECT
ID,
item,
category
FROM
Table
WHERE
ID IN (SELECT min(ID) FROM Table GROUP BY category)
I then Joined the temporary table and used it in a CASE statement to manipulate the output.
Code:
(CASE WHEN t1.item = _tmp.item THEN category ELSE '' END) AS Category