Chart Help! I must be stupid!

OK, I have done 1000s of excel charts. Paste in the data, select the
data, insert chart and it works.
I am trying to do a simple line chart in RS and can't figure it out
after two hours. Maybe it is time to quir coding! My query returns the
following:
Product, Month1, Month2, Month3, Month4, Month5 (There Are Column
Names)
Proda 123 222 454 126 322 (this is the sales
data, row 1)
Prodb 333 526 447 631 262 (this is the sales
data, row 2)
Prodc 143 242 344 126 229 (this is the sales
data, row 3)
Prodd 153 123 467 116 122 (this is the sales
data, row 4)
I want a simple line chart with month1 thru month 5 at the bottom axis
and the
sales scale on the left axis. The series would be of course
proda,b,c,d. So I
want 4 lines on the chart from left to right representing month 1 thru
5 and the line would chart up and down based on the sales number.
In excel I paste in the table, hightlight it and insert a line chart
and it is 100% right. I'll email anyone the excel file who wants it.
What am I missing on this deal. I have looked every where and tried a
dozen combos. Thanks for your time!!
SheilaWhat kind of charts did you choose?
"George" <geomanks@.yahoo.com> wrote in message
news:e9dff8e4.0408171641.71a8b619@.posting.google.com...
> OK, I have done 1000s of excel charts. Paste in the data, select the
> data, insert chart and it works.
> I am trying to do a simple line chart in RS and can't figure it out
> after two hours. Maybe it is time to quir coding! My query returns the
> following:
> Product, Month1, Month2, Month3, Month4, Month5 (There Are Column
> Names)
> Proda 123 222 454 126 322 (this is the sales
> data, row 1)
> Prodb 333 526 447 631 262 (this is the sales
> data, row 2)
> Prodc 143 242 344 126 229 (this is the sales
> data, row 3)
> Prodd 153 123 467 116 122 (this is the sales
> data, row 4)
> I want a simple line chart with month1 thru month 5 at the bottom axis
> and the
> sales scale on the left axis. The series would be of course
> proda,b,c,d. So I
> want 4 lines on the chart from left to right representing month 1 thru
> 5 and the line would chart up and down based on the sales number.
> In excel I paste in the table, hightlight it and insert a line chart
> and it is 100% right. I'll email anyone the excel file who wants it.
> What am I missing on this deal. I have looked every where and tried a
> dozen combos. Thanks for your time!!
> Sheila

Character limit on Data tab?

Does anyone know if there is a character limit on the data tab of SRS 2000? I have a report that requires a lottt of sql and when I copy and paste the sql from Query Analyzer to the data tab, not all of it gets copied there, and it will not let me enter another character.

Thanks,

Jeff

It may make more sense to encapsulate in a stored procedure if possible. It does sound like you have a limitation there.|||Yah...good thought...thanks.

chapter 3 page 44

I'm getting the following errow when I cut and paste script into the query design

There is an error in the query. Invalid object name 'FactResellerSales'.
Invalid object name 'DimEmployee'.
Invalid object name 'DimTime'.
Invalid object name 'DimSalesTerritory'.

I've tried some of everything to resolve this issue. Need help... Not sure what I'm doing wrong.

ThanksCheck your database connection "Data Source Properties" and give a Test connection