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

