Line Chart data points

Hello all,
I hope one of the gurus here can help me out.
I have a line chart in reporting services (sp2) with month on x-axis, year on
y-axis with aggregate monthly totals for datapoints. The user selects a date
range, say January 2004 to June 2005. The chart produces one line for each
year but since 2005 has not ended yet, there should be no data for the end of
the year but the chart is putting datapoints with a zero value on the chart.
When I put the same query in a matrix, those months don't show up because
there is no data (duh). How can I get those data points off the chart?
Looking forward to any help and many thanks in advance.
Cheers!Hi Wendy, I am still pretty new at this. But I would think an IIF statement
in the Filter tab of the Chart properties might work. I guessing here, but
that is the first thing that pop in my head when I read your post. Thanks and
have a great day, Kerrie
Wendy j wrote:
>Hello all,
>I hope one of the gurus here can help me out.
>I have a line chart in reporting services (sp2) with month on x-axis, year on
>y-axis with aggregate monthly totals for datapoints. The user selects a date
>range, say January 2004 to June 2005. The chart produces one line for each
>year but since 2005 has not ended yet, there should be no data for the end of
>the year but the chart is putting datapoints with a zero value on the chart.
>When I put the same query in a matrix, those months don't show up because
>there is no data (duh). How can I get those data points off the chart?
>Looking forward to any help and many thanks in advance.
>Cheers!
Message posted via http://www.sqlmonster.com|||Hi Kerrie,
Thanks for your reply! I thought the same thing initially but since the
points technically don't exist they cannot be filtered out. It is almost as
if the chart is 'filling in the blank' with a value of zero.
Wendy
Kerrie S wrote:
>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>in the Filter tab of the Chart properties might work. I guessing here, but
>that is the first thing that pop in my head when I read your post. Thanks and
>have a great day, Kerrie
>>Hello all,
>>I hope one of the gurus here can help me out.
>[quoted text clipped - 7 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||Sorry I could not be more help. I hope someone answer you, I am curious to
know.
Wendy j wrote:
>Hi Kerrie,
>Thanks for your reply! I thought the same thing initially but since the
>points technically don't exist they cannot be filtered out. It is almost as
>if the chart is 'filling in the blank' with a value of zero.
>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>>in the Filter tab of the Chart properties might work. I guessing here, but
>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||It sounds like you are running into the issue described in the following KB
article: http://support.microsoft.com/kb/883675
However, this was definitely fixed on RS 2000 SP2. Are you sure you have SP2
installed for Report Designer and on the report server?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:541C109219A03@.SQLMonster.com...
> Sorry I could not be more help. I hope someone answer you, I am curious to
> know.
> Wendy j wrote:
>>Hi Kerrie,
>>Thanks for your reply! I thought the same thing initially but since the
>>points technically don't exist they cannot be filtered out. It is almost
>>as
>>if the chart is 'filling in the blank' with a value of zero.
>>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF
>>statement
>>in the Filter tab of the Chart properties might work. I guessing here,
>>but
>>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
>
> --
> Message posted via http://www.sqlmonster.com

limit on sp's through an odbc connection

To all the gurus,
Is there a limit on the number of queries that can be run through an
odbc connection to another SQL server?
The primary server is running abinitio to query a sql server.
When we run the set of sps that is needed the server essetially grind to
a halt...
thanx
Bill
*** Sent via Developersdex http://www.codecomments.com ***ok how about this one,
is there a limit on the number of threads that can be used on one odbc
source?
Bill
*** Sent via Developersdex http://www.codecomments.com ***|||Does this article from MSoft help you at all...
http://msdn2.microsoft.com/en-us/library/ms187024.aspx
Should help you get the Maximum out of worker threads.
thanks,
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Bill" <nospam@.devdex.com> wrote in message
news:ustGql01GHA.4924@.TK2MSFTNGP05.phx.gbl...
> ok how about this one,
> is there a limit on the number of threads that can be used on one odbc
> source?
>
> Bill
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Bill,
Regarding this:
>When we run the set of sps that is needed the server essetially grind to
>a halt...
My question is what diagnostics, monitoring were done to
determine that this was related to some type of limits on
connections? That would really be the starting point -
monitoring where the bottlenecks are, monitoring for
locking/blocking issues, what's going on in SQL Server when
these are run, etc. Were those done?
-Sue
On Wed, 13 Sep 2006 07:29:56 -0700, Bill <nospam@.devdex.com>
wrote:

>To all the gurus,
>Is there a limit on the number of queries that can be run through an
>odbc connection to another SQL server?
>The primary server is running abinitio to query a sql server.
>When we run the set of sps that is needed the server essetially grind to
>a halt...
>
>thanx
>Bill
>
>*** Sent via Developersdex http://www.codecomments.com ***|||Mr. Brunk,
thank you very much
this answered my question totally
BillO
*** Sent via Developersdex http://www.codecomments.com ***