Bar chart with row data

Hi,
I have a dataset with values for each month.
For example:
Jan Feb Mar Apr May Jun Jul
1200 1500 1420 1540 1450 1470 1467
I would like to create a Bar chart from this data. Is there a way to supply
the row as a source data? Since my data is in 12 columns, i have to add each
column as a data field to the chart and all bars show up in different colors
because of this.
Is there a way to provide the row a single series?
Thanks,If you have RS 2000 SP1 or SP2 installed, you could set the color to the
same identical value for all values (under appearance - series styles).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Prash" <Prash@.discussions.microsoft.com> wrote in message
news:06121C94-6D66-4BD6-9AFC-CA3E787723C7@.microsoft.com...
> Hi,
> I have a dataset with values for each month.
> For example:
> Jan Feb Mar Apr May Jun Jul
> 1200 1500 1420 1540 1450 1470 1467
> I would like to create a Bar chart from this data. Is there a way to
> supply
> the row as a source data? Since my data is in 12 columns, i have to add
> each
> column as a data field to the chart and all bars show up in different
> colors
> because of this.
> Is there a way to provide the row a single series?
> Thanks,

Backwards in a foreach for ADO?

I need to simulate cursor-type (groan) behavior in a dataset and am wondering if this is possible in the foreach task. Example - The user has the need to go through the data row-by-row, and if a certain value is missing in row 10 then go back to row 8, grab a value from that row, and plug it in the missing column in row 10. Then move on to row 11.

Is there a way to make the foreach ADO enumerator travel backwards? Is there a way to do this that will not be awfully inefficient? Any suggestions out there would be welcome.

I've advocated for set-based updates, and these simply aren't an option, as each successive row depends on the updates that may have happened above it in the sequence. Unless I hear of any other ideas out there I have to move forward with this sequential type operation.

This sounds like a script task to me... I don't believe that there is an effecient way to do this (if at all) with a for each loop...

|||

That's the headache I'm having - I don't see a good way to do this period, from a SQL/SSIS/relational perspective.

|||Not sure if this would meet your needs, but you can use a script transform to buffer rows. You'd have to create some structure to store the data in (an array or dataset would work) and then you can access the rows in any order you wish.|||

Sounds intriguing - do you happen to have an example handy?