Tricky Recordset Question: HELP!

[Bob Barrows]

I'm not sure where your problem is. You describe some things you've tried,
but you don't explain what goes wrong when you try them ...

I think we are going to need to see a little bit of the code used to build
the graphs.

Bob Barrows

qnal wrote:

> I have a bit of a situation.
>
> I have a recordset that can return anywhere from 1 to 250 rows.
>
> I take this recordset and pass it to a CreateChart Function on an ASP
> Page like so:
>
> CreateChart (objRs)
>
> The CreateChart function takes the recordset and creates an Excel Bar
> Chart using Office Web Components.
> This works fine for low numbers. The chart looks clean.
>
> However, when I get 250 rows, the Chart looks terrible because of
> jumbling and extremely thin lines.
>
> What I am attempting to do is: if I detect a record count of greater
> than say 30, I want to create multiple graphs in batches of 30 until
> the end of the recordset is reached.
>
> I have tried a bunch of ways, but have come up empty, tried paging
> techniques, cloning the recordset, clearing it, and adding values
> from the original etc etc, with no success.
>
> I hope someone can help me.
>
> Again to review:
> 1) Detect Recordcount ( I checked this and it is working correctly, I
> don't get -1 , I get the correct number of records)
> 2) If the recordcount is greater than 30, take the first thirty, pass
> these records to CreateChart(recordset),
> 3) Come back where we left off, i.e. 31st record...process 30 more,
> CreateChart (recordset), like this until End of Recordset is reached.
>
> HELP me Obi Wan Kenobi, you're my only hope...

[qnal]

The function that generates the graph doesn't do anything special, it just
takes a recordset and creates a Graph.

The problem is the recordset. I would post the code, but its at work and I
have no way to access it currently.

The problem is extracting 30 records, passing them as a recordset to the
Chart Function, coming back where I left off, getting the next 30 and
repeating the process until EOF....

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:%23ILFUw$RDHA.1324@TK2MSFTNGP11.phx.gbl...

> I'm not sure where your problem is. You describe some things you've tried,
> but you don't explain what goes wrong when you try them ...
>
> I think we are going to need to see a little bit of the code used to build
> the graphs.
>
> Bob Barrows
>
> qnal wrote:

> > I have a bit of a situation.
> >
> > I have a recordset that can return anywhere from 1 to 250 rows.
> >
> > I take this recordset and pass it to a CreateChart Function on an ASP
> > Page like so:
> >
> > CreateChart (objRs)
> >
> > The CreateChart function takes the recordset and creates an Excel Bar
> > Chart using Office Web Components.
> > This works fine for low numbers. The chart looks clean.
> >
> > However, when I get 250 rows, the Chart looks terrible because of
> > jumbling and extremely thin lines.
> >
> > What I am attempting to do is: if I detect a record count of greater
> > than say 30, I want to create multiple graphs in batches of 30 until
> > the end of the recordset is reached.
> >
> > I have tried a bunch of ways, but have come up empty, tried paging
> > techniques, cloning the recordset, clearing it, and adding values
> > from the original etc etc, with no success.
> >
> > I hope someone can help me.
> >
> > Again to review:
> > 1) Detect Recordcount ( I checked this and it is working correctly, I
> > don't get -1 , I get the correct number of records)
> > 2) If the recordcount is greater than 30, take the first thirty, pass
> > these records to CreateChart(recordset),
> > 3) Come back where we left off, i.e. 31st record...process 30 more,
> > CreateChart (recordset), like this until End of Recordset is reached.
> >
> > HELP me Obi Wan Kenobi, you're my only hope...

>
>
>

[Bob Barrows]

qnal wrote:

> The function that generates the graph doesn't do anything special, it
> just takes a recordset and creates a Graph.
>
> The problem is the recordset. I would post the code, but its at work
> and I have no way to access it currently.
>
> The problem is extracting 30 records, passing them as a recordset to
> the Chart Function, coming back where I left off, getting the next 30
> and repeating the process until EOF....
>

So what goes wrong with the thing you've tried ... ? This sounds like a real
good occasion to use recordset paging. You say you've tried that. What
happened when you did?

Bob

[Tim Williams]

"GetRows" can retrieve a set number of rows for each call - pass the
resulting array(s) to your graphing function (instead of the recordset), or
modify your graphing function to accept an additional parameter for the
number of records to add to each plot.

tim


"qnal" <qnal@dontspam.qnal.net> wrote in message
news:OXtF1b$RDHA.212@TK2MSFTNGP10.phx.gbl...

> I have a bit of a situation.
>
> I have a recordset that can return anywhere from 1 to 250 rows.
>
> I take this recordset and pass it to a CreateChart Function on an ASP Page
> like so:
>
> CreateChart (objRs)
>
> The CreateChart function takes the recordset and creates an Excel Bar

Chart

> using Office Web Components.
> This works fine for low numbers. The chart looks clean.
>
> However, when I get 250 rows, the Chart looks terrible because of jumbling
> and extremely thin lines.
>
> What I am attempting to do is: if I detect a record count of greater than
> say 30, I want to create multiple graphs in batches of 30 until the end of
> the recordset is reached.
>
> I have tried a bunch of ways, but have come up empty, tried paging
> techniques, cloning the recordset, clearing it, and adding values from the
> original etc etc, with no success.
>
> I hope someone can help me.
>
> Again to review:
> 1) Detect Recordcount ( I checked this and it is working correctly, I

don't

> get -1 , I get the correct number of records)
> 2) If the recordcount is greater than 30, take the first thirty, pass

these

> records to CreateChart(recordset),
> 3) Come back where we left off, i.e. 31st record...process 30 more,
> CreateChart (recordset), like this until End of Recordset is reached.
>
> HELP me Obi Wan Kenobi, you're my only hope...
>
>