Line Chart with a "Single Category Group"

Hi Folks
I have a line chart showing some data vs time. The chart is okay when
we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
is empty when only period (the category group) is being displayed.
This leaves me with two questions...,
1. is this because line charts are supposed to show trends over
multiple category groups and thus are Not applicable for a single
category group?
2. is there a fix for this?
Any help would be greatly appreciated :)
Thnx a ton.Oops..., I meant the chart is empty when only a single period (say only
Q1 2006) is selected (i.e. is to be displayed).
> I have a line chart showing some data vs time. The chart is okay when
> we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
> is empty when only period (the category group) is being displayed.|||Allright, the problem has been solved :D
Turns out I need to edit the data field, and enable the "Show Markers"
checkbox :)
Profundus wrote:
> Hi Folks
> I have a line chart showing some data vs time. The chart is okay when
> we have multiple periods (say Q1 2006 and Q2 2006). However, the chart
> is empty when only period (the category group) is being displayed.
> This leaves me with two questions...,
> 1. is this because line charts are supposed to show trends over
> multiple category groups and thus are Not applicable for a single
> category group?
> 2. is there a fix for this?
> Any help would be greatly appreciated :)
> Thnx a ton.

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)

Line Chart Color

Hello,

My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?

Michael

To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||

Merin,

I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?

Michael

|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||

Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.

Michael

|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.

i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).

however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x

(refer to code snippet)

and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.

rev-boy

=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)

LIMITs on MIRROR with SQL Server SE

Hi folks. I'm trying to clear up some licensing confusion I"ve come across. First, if I use MIRROR on SS SE I am limited to a single REDO thread and Sycn mode. I see that on the Web. Will the singel REDO thread hurt the ability for the Secondary to keep up? Any one done any tests?

My confusion comes from a document that came across my desk a long time ago that showed that if you use MIRROR on SQL Server SE you are limited to 4 processors for the entire cluster. So if you wanted a balanced failover you would have to have two 2-ways in essence. Is this true? Is it not longer true? I can't seem to find any mention of this....did someone give me bad advice? Help! Thanks.

Licensing will not hurt any performance, only the number of transactions will have the recovery of REDO and UNDO process during the recovery.

|||In standard edition you wont get parallel redo and database snapshots features in the case of database mirroring.

Limiting Number of Items Displayed in Report

ey there, quick question...

is there any way to limit the number of items displayed in a single page?

say i want to display up to 10 items, and then the rest of the items are then displayed on the next page?

any help and suggestions would be greatly appreciated.

thanks!

Tim

It's possible if you group on an expression rather than a field:

nest your table inside a list control|||thanks for replying sir

i got it already. thanks very much for your help|||I posted a working example in the other thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=157571&SiteID=1

Limiting Dataset for Chart but not Table

I have a report that has a single dataset that is used to populate both a
chart and a table. I want to limit the rows used by the chart but I want
the table to display all rows. I'm having difficulty determining how to
apply some sort of "rowcount <=10" condition to the chart's dataset. I
would like to avoid executing the same query twice.
I have been unable to find any references to this searching through this
group or the web (via google). Nor could I find anything in the Books
Online.
Is this possible or must I create two datasets, one that limits the number
of rows returned and another that returns all rows? If this can be done,
can someone please point me to an article that explains how?
Thanks,
ChrisChristopher,
SQL Server 2000 Reporting Services supports filtering on data regions
(table, matrix, list, and chart). Please see Reporting Services Books On
Line (BOL) for more information.
To access the filtering option for charts:
* Open the chart properties dialog
* Click on the Data tab
* Add or Edit a Category group (same applies to Series groups)
* Click on the Filtering tab
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> I have a report that has a single dataset that is used to populate both a
> chart and a table. I want to limit the rows used by the chart but I want
> the table to display all rows. I'm having difficulty determining how to
> apply some sort of "rowcount <=10" condition to the chart's dataset. I
> would like to avoid executing the same query twice.
> I have been unable to find any references to this searching through this
> group or the web (via google). Nor could I find anything in the Books
> Online.
> Is this possible or must I create two datasets, one that limits the number
> of rows returned and another that returns all rows? If this can be done,
> can someone please point me to an article that explains how?
> Thanks,
> Chris
>|||My category is on a field named "TargetOpenDate", so how do I setup the
filter? I cannot find any guidance either in the BOL or searching on Google
(web or groups).
I just want to limit the number of rows to the Top 5. I cannot leave the
Expression field blank. It seems no matter which field I select (either the
field I'm using for the category or some other arbitrary field), I get an
error "Fail to evaluate FilterExpression/FilterValues".
Expression: =Fields!TargetOpenDate.Value
Operator: Top N
Value: 3
Thanks,
Chris
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Christopher,
> SQL Server 2000 Reporting Services supports filtering on data regions
> (table, matrix, list, and chart). Please see Reporting Services Books On
> Line (BOL) for more information.
> To access the filtering option for charts:
> * Open the chart properties dialog
> * Click on the Data tab
> * Add or Edit a Category group (same applies to Series groups)
> * Click on the Filtering tab
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > I have a report that has a single dataset that is used to populate both
a
> > chart and a table. I want to limit the rows used by the chart but I
want
> > the table to display all rows. I'm having difficulty determining how to
> > apply some sort of "rowcount <=10" condition to the chart's dataset. I
> > would like to avoid executing the same query twice.
> >
> > I have been unable to find any references to this searching through this
> > group or the web (via google). Nor could I find anything in the Books
> > Online.
> >
> > Is this possible or must I create two datasets, one that limits the
number
> > of rows returned and another that returns all rows? If this can be
done,
> > can someone please point me to an article that explains how?
> >
> > Thanks,
> > Chris
> >
> >
>|||There is a trick. You need the value to be =3 instead of just 3. The
expression evaluator guesses that 3 is a string.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:Or7f3JwVEHA.644@.tk2msftngp13.phx.gbl...
> My category is on a field named "TargetOpenDate", so how do I setup the
> filter? I cannot find any guidance either in the BOL or searching on
Google
> (web or groups).
> I just want to limit the number of rows to the Top 5. I cannot leave the
> Expression field blank. It seems no matter which field I select (either
the
> field I'm using for the category or some other arbitrary field), I get an
> error "Fail to evaluate FilterExpression/FilterValues".
> Expression: =Fields!TargetOpenDate.Value
> Operator: Top N
> Value: 3
>
> Thanks,
> Chris
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > Christopher,
> >
> > SQL Server 2000 Reporting Services supports filtering on data regions
> > (table, matrix, list, and chart). Please see Reporting Services Books On
> > Line (BOL) for more information.
> >
> > To access the filtering option for charts:
> >
> > * Open the chart properties dialog
> > * Click on the Data tab
> > * Add or Edit a Category group (same applies to Series groups)
> > * Click on the Filtering tab
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> > news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > I have a report that has a single dataset that is used to populate
both
> a
> > > chart and a table. I want to limit the rows used by the chart but I
> want
> > > the table to display all rows. I'm having difficulty determining how
to
> > > apply some sort of "rowcount <=10" condition to the chart's dataset.
I
> > > would like to avoid executing the same query twice.
> > >
> > > I have been unable to find any references to this searching through
this
> > > group or the web (via google). Nor could I find anything in the Books
> > > Online.
> > >
> > > Is this possible or must I create two datasets, one that limits the
> number
> > > of rows returned and another that returns all rows? If this can be
> done,
> > > can someone please point me to an article that explains how?
> > >
> > > Thanks,
> > > Chris
> > >
> > >
> >
> >
>|||Thanks, that worked.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ub6EY%23wVEHA.1656@.TK2MSFTNGP09.phx.gbl...
> There is a trick. You need the value to be =3 instead of just 3. The
> expression evaluator guesses that 3 is a string.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> news:Or7f3JwVEHA.644@.tk2msftngp13.phx.gbl...
> > My category is on a field named "TargetOpenDate", so how do I setup the
> > filter? I cannot find any guidance either in the BOL or searching on
> Google
> > (web or groups).
> >
> > I just want to limit the number of rows to the Top 5. I cannot leave
the
> > Expression field blank. It seems no matter which field I select (either
> the
> > field I'm using for the category or some other arbitrary field), I get
an
> > error "Fail to evaluate FilterExpression/FilterValues".
> >
> > Expression: =Fields!TargetOpenDate.Value
> > Operator: Top N
> > Value: 3
> >
> >
> > Thanks,
> > Chris
> >
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> > news:u7%23BJyVVEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > > Christopher,
> > >
> > > SQL Server 2000 Reporting Services supports filtering on data regions
> > > (table, matrix, list, and chart). Please see Reporting Services Books
On
> > > Line (BOL) for more information.
> > >
> > > To access the filtering option for charts:
> > >
> > > * Open the chart properties dialog
> > > * Click on the Data tab
> > > * Add or Edit a Category group (same applies to Series groups)
> > > * Click on the Filtering tab
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Christopher Walls" <msnews@.travantsolutions.com> wrote in message
> > > news:uYHUnKUVEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > > I have a report that has a single dataset that is used to populate
> both
> > a
> > > > chart and a table. I want to limit the rows used by the chart but I
> > want
> > > > the table to display all rows. I'm having difficulty determining
how
> to
> > > > apply some sort of "rowcount <=10" condition to the chart's dataset.
> I
> > > > would like to avoid executing the same query twice.
> > > >
> > > > I have been unable to find any references to this searching through
> this
> > > > group or the web (via google). Nor could I find anything in the
Books
> > > > Online.
> > > >
> > > > Is this possible or must I create two datasets, one that limits the
> > number
> > > > of rows returned and another that returns all rows? If this can be
> > done,
> > > > can someone please point me to an article that explains how?
> > > >
> > > > Thanks,
> > > > Chris
> > > >
> > > >
> > >
> > >
> >
> >
>

limit the select to single row

Hello,
How can I limit the select statement to 1 single row ?
How can I limit the select statement to specific no. of rows ?
Thanks :)SELECT TOP 1
FROM ...
ORDER BY ...
SELECT TOP 10
FROM ...
ORDER BY ...
Note that without ORDER BY, which rows that are returned is undefined.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Eitan M" <no_spam_please@.nospam_please.com> wrote in message
news:%23lJnZbwoFHA.860@.TK2MSFTNGP12.phx.gbl...
> Hello,
> How can I limit the select statement to 1 single row ?
> How can I limit the select statement to specific no. of rows ?
> Thanks :)
>|||The obvious answer to your first question is to use a WHERE clause that
references a unique key.
In the second case you'll probably want to take a look at the SELECT
TOP n feature or use SET ROWCOUNT.
With TOP and ROWCOUNT be aware that unless you specify a unique key in
the ORDER BY clause or use the TOP WITH TIES modifier you may get
undefined results. That ought to be common sense but too many times I
see people omit to specify a well-defined criteria for a top n subset.
David Portas
SQL Server MVP
--