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

RS2k - Display text to say there are no rows?

Hi,

This is probably an easy one, but its been bugging me.

If I have no rows for a particular table, is there any way that I can simply display some text saying something like 'no data available for report' ?

Similarly, I was thinking I could hider certain controls on the report if there are no rows available by using an expression in the Visible property of the control.

Any suggestions are appreciated.

Regards.

MrPeds

In the VS Properties (not the Properties from the context menu) there is a NoRows property that is the Text you want displayed when the dataset returns no rows. There is not a way to determine from the table at run time if there are any rows or not, but you can get a row count on DataSet1 like:

Code Snippet

=CountRows("DataSet1")

Hope this helps.

Larry