Line Chart Empty

I have a dataset that can be viewed as columns chart. But when I change to
line chart, the data is shown only partly, or not shown at all.
I noticed that if I have one set of data that covers the full lenght of
x-axis, and another set of data that covers only the right side of x-axis,
then what you will see will be the start of the line representing the first
set, then it stops completely and another line starts representing the second
set.
Anybody knows why it happends and how to fix it?
D>Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>I have a dataset that can be viewed as columns chart. But when I change to
> line chart, the data is shown only partly, or not shown at all.
> I noticed that if I have one set of data that covers the full lenght of
> x-axis, and another set of data that covers only the right side of x-axis,
> then what you will see will be the start of the line representing the
> first
> set, then it stops completely and another line starts representing the
> second
> set.
> Anybody knows why it happends and how to fix it?
> D>|||It is RS 2000, and I have only SP1 installed. Is it a problem?
"Robert Bruckner [MSFT]" wrote:
> Are you using the RTM version of RS 2000, and SP1 or SP2 is not installed?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
> >I have a dataset that can be viewed as columns chart. But when I change to
> > line chart, the data is shown only partly, or not shown at all.
> > I noticed that if I have one set of data that covers the full lenght of
> > x-axis, and another set of data that covers only the right side of x-axis,
> > then what you will see will be the start of the line representing the
> > first
> > set, then it stops completely and another line starts representing the
> > second
> > set.
> > Anybody knows why it happends and how to fix it?
> > D>
>
>|||Yes, you are running into a known issue with line charts using multiple data
series and the datapoints having interleaved category (x-axis) values. The
fix is available in RS 2000 SP2.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"uiwork" <uiwork@.discussions.microsoft.com> wrote in message
news:991368D7-2E58-4566-AB34-68027D9FC856@.microsoft.com...
> It is RS 2000, and I have only SP1 installed. Is it a problem?
> "Robert Bruckner [MSFT]" wrote:
>> Are you using the RTM version of RS 2000, and SP1 or SP2 is not
>> installed?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "uiwork" <uiwork@.discussions.microsoft.com> wrote in message
>> news:004E3B42-5CBE-4590-BC7D-28D15B266131@.microsoft.com...
>> >I have a dataset that can be viewed as columns chart. But when I change
>> >to
>> > line chart, the data is shown only partly, or not shown at all.
>> > I noticed that if I have one set of data that covers the full lenght of
>> > x-axis, and another set of data that covers only the right side of
>> > x-axis,
>> > then what you will see will be the start of the line representing the
>> > first
>> > set, then it stops completely and another line starts representing the
>> > second
>> > set.
>> > Anybody knows why it happends and how to fix it?
>> > D>
>>

limited resultset without SP

I have a search query on my page. However, since the resultset may be very large, I want to retreive only those results that are currently shown on the gridview page.
Often a user won't browse through more than a couple of pages, so it's b-*** to send all the records to the client.
I know that with a sp you can define that you want to retrieve the first or second x records, but I want to do this with SQL...is that possible?You could put a TOP 100 or something in your search query and page them at the client side or if you want to use SQL to do the paging, you'd be doing the search over and over again for each page. You *could* get a few duplicate records. since, I am assuming you'd do a top 10 or 20 from the query to show them on the page and when you do the search again, you are starting fresh and there isnt an easy way to remember the previous search. unles you store the result set you first got into some table (you could put the spid in one column) and use the spid to get the next result set. Obviously you'd have to worry about cleaning up the table periodically in such a case.