problem with query in dasource (reporting service)

hi everybody,

well i have problem with a query in reporting service

for a one checkpoint

and for every classe in my table i want to extract the min_boundary and the max_boundary

[img=http://img222.imageshack.us/img222/2903/tabletz3.th.png]

the query i wrote is :

SELECT MIN_BOUNDARY, MAX_BOUNDARY
FROM CLASSES
WHERE (VCHKPTID =@CHECKPOINTSCHECKPOINTS)
ORDER BY MIN_BOUNDARY, MAX_BOUNDARY

@CHECKPOINTSCHECKPOINTS is the report parameters.

The problem is that this query is rendering à set of record and i want to extract the minBoundary and maxboundary for each classe (like array in c#sharp) MIN_BOUNDARY(j), MAX_BOUNDARY(j).

can you help me please

[902 byte] By [totocasagrandi] at [2007-12-22]

SQL Server

Site Classified