"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:88466F59-5231-402D-957F-4B5E2370F5A9@microsoft.com...
> This is just a matter of formatting for dsiplay or printing. Any report
> writing tool will put in banding and breaks for you so there's no need to
do
> it in the database. In N-Tier architectures the idea is to separate the
data
> retrieval and data presentation/UI functionality into different tiers.
> Presentation belongs client-side.
>
> --
> David Portas
> SQL Server MVP
> --
>
>
>
> "Dvanderm" wrote:
>
> > strSQL = "SELECT SA, ProblemType, Count(ProblemType) as ProbType FROM
> > Problems WHERE RptDate >= " & sIn(bDate) & " AND RptDate <= " &
sIn(eDate) &
> > " GROUP BY SA, ProblemType ORDER BY SA"
> >
> > Results Look like this - no space in between different SAs.
> >
> > Steve Monitor 1
> > Steve Printer 1
> > John Montiro 2
> > John Printer 5
> > Lisa Monitor 4
> > Lisa Monitor 3
> >
> > I would like to see, can I do this?
> >
> > Steve Monitor 1
> > Steve Printer 1
> > (blank line)
> > John Montiro 2
> > John Printer 5
> > (blank line)
> > Lisa Monitor 4
> > Lisa Monitor 3
> >
> >
> >

"Dvanderm" wrote:

> strSQL = "SELECT SA, ProblemType, Count(ProblemType) as ProbType FROM
> Problems WHERE RptDate >= " & sIn(bDate) & " AND RptDate <= " & sIn(eDate) &
> " GROUP BY SA, ProblemType ORDER BY SA"
>
> Results Look like this - no space in between different SAs.
>
> Steve Monitor 1
> Steve Printer 1
> John Montiro 2
> John Printer 5
> Lisa Monitor 4
> Lisa Monitor 3
>
> I would like to see, can I do this?
>
> Steve Monitor 1
> Steve Printer 1
> (blank line)
> John Montiro 2
> John Printer 5
> (blank line)
> Lisa Monitor 4
> Lisa Monitor 3
>
>