RS2K & Lines Chart

Hello,
I'm trying to make RS2K chart values from a SQL request.
Datas to chart are contained in the only row returned by a SQL request
like the following :
SELECT TOP 1 A.cyl, A.ind, A.usi, A.dt1, A.dt2, A.dt3, A.dt4, A.dt5,
A.dt6, A.dt7, A.dt8, A.dt9, A.dt10, A.dt11, A.dt12, B.tmin, B.tmax,
B.rmin, B.rmax
FROM A
INNER JOIN B ON A.mach = B.mach
WHERE (A.cyl = @.Cyl)
ORDER BY A.ind DESC, A.usi DESC
I'd like to make the Chart component draw a line using values A.dt1 to
A.dt12 and so far, I have not succeeded.
Any idea ?
Thanks in advance
RegardsWhere are you stuck trying to do that ?
"Emss" <emss@.free.fr> wrote in message
news:45ffcd66$0$21229$426a74cc@.news.free.fr...
> Hello,
> I'm trying to make RS2K chart values from a SQL request.
> Datas to chart are contained in the only row returned by a SQL request
> like the following :
> SELECT TOP 1 A.cyl, A.ind, A.usi, A.dt1, A.dt2, A.dt3, A.dt4, A.dt5,
> A.dt6, A.dt7, A.dt8, A.dt9, A.dt10, A.dt11, A.dt12, B.tmin, B.tmax,
> B.rmin, B.rmax
> FROM A
> INNER JOIN B ON A.mach = B.mach
> WHERE (A.cyl = @.Cyl)
> ORDER BY A.ind DESC, A.usi DESC
> I'd like to make the Chart component draw a line using values A.dt1 to
> A.dt12 and so far, I have not succeeded.
> Any idea ?
> Thanks in advance
> Regards|||Julien Bonnier a écrit :
Hello,
> Where are you stuck trying to do that ?
I've dragged the chart component on the report layout and dropped fields
in the Data Fields, Series Fields or Categories Fields without any result.
Regards