problem with datasource-query (reporting service)

hi everybody,

well i have problem with a query in reporting service

• for a one checkpoint (fiels VCHKPID for example CHCKPOINT =2)
• and for every classe in my table This checkpoint (field ID or NAME it's the same) i want to extract the min_boundary and the max_boundary

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).

remark: idont whant to use assembly or embeded function.

can you help me please

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