Bug? Legend values same color

I when setting the background color for a data point programatically, I want
two colors. 'Firebrick' for bad values and 'ForestGreen' for good. So I
have a simple global function to handle this. Sometimes though, for no
explainable reason, even though my bar chart has green and red series, the
legend shows red for each of the two existing series. How can this be? The
series colors on the chart should always by default correspond with the
colors rendered for the legend.
I will provide you any information required to get to the bottom of this.
For starters, I'm running Report Services SP2.Please someone help me on this one. I am fairly certain this is a bug in
reporting services but need help to confirm this.

bug: data file autogrowth set to 12800%

SQL2K5 SP1

the autogrowth setting in one of my database's primary filegroup data
file keeps having the value of 12800%, which was originally set to
100MB, everytime the service is restarted. the same occurs whenever i
restore a backup of this database in our development environment.

WTF? this issue does not happen to other filegroups. only on the
primary data file. whenever this happens the 4GB data file grows to
more than 70GB (even the math is incorrect) with about 95% of UNUSED
space.

has anyone else come accross this BS or anyone knows how to prevent
this from happening? is MS aware of this not-so-funny joke?

thankshi,
XNMB wrote:
> SQL2K5 SP1
> the autogrowth setting in one of my database's primary filegroup data
> file keeps having the value of 12800%, which was originally set to
> 100MB, everytime the service is restarted. the same occurs whenever i
> restore a backup of this database in our development environment.
> WTF? this issue does not happen to other filegroups. only on the
> primary data file. whenever this happens the 4GB data file grows to
> more than 70GB (even the math is incorrect) with about 95% of UNUSED
> space.
> has anyone else come accross this BS or anyone knows how to prevent
> this from happening? is MS aware of this not-so-funny joke?

unfortunately, it's a bug, already reported as you can see at
http://lab.msdn.microsoft.com/produ...62-729b178a7fa0
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply|||XNMB (ChristianBautista@.gmail.com) writes:
> the autogrowth setting in one of my database's primary filegroup data
> file keeps having the value of 12800%, which was originally set to
> 100MB, everytime the service is restarted. the same occurs whenever i
> restore a backup of this database in our development environment.
> WTF? this issue does not happen to other filegroups. only on the
> primary data file. whenever this happens the 4GB data file grows to
> more than 70GB (even the math is incorrect) with about 95% of UNUSED
> space.
> has anyone else come accross this BS or anyone knows how to prevent
> this from happening? is MS aware of this not-so-funny joke?

Yes, as Andrea said, this is a known issue.

It appears that the problem appears with databases from SQL 2000, and it's
old bug that causes problems.

Look at http://lab.msdn.microsoft.com/Produ...ackId=FDBK49455
for a way to fix the database while its on SQL 2000.

If the database is on SQL 2005, it may help to set an explicit growth to
a fixed size.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

BorderStyle not shown as Solid for Top ,Bottom & Right side of Reports.

HI ,

Although I am setting the Border Style for each & every cell and /or Merge cells ,But it is not reflected in the Reports Pre-view for Bottom ,Top & Right Sides in the Reports?Any clue why this is happening & for removing this & getting the right results would be helpful .

Thanks

I had an issue where the BorderStyle did not seem to change. I was attempting to set the border to None on the Bottom of a cell but did not change the BorderStyle of the cell below it. Once I changed the Top BorderStyle to None of the cell below then I saw the desired affect.

Hope this helps.

BorderStyle bug??

In RS 2005, I cannot hide a particular border by setting it to 'None' if the
Default border setting is 'Solid'.
I can get the desired result by setting the Default border to 'None' and
then setting only the borders I want to display to 'Solid', however, this is
not convenient to me as I have a large amount of reports where the Default is
solid and the borders I want hidden are set to 'None', which used to work
fine in RS 2000. Is this a bug? The control I am dealing with is a textbox,
but I have also tested a rectangle and the body of the report itself, and the
borderstyle is acting the same with all 3 objects. Also, let me add that in
layout mode while I am designing the report the borders appear to be
displaying/hiding as I would expect, but when the report is actually ran or
previewed is when the borders do not behave appropriately.
To be absolutely clear, here is an example:
The following does NOT hide the bottom border in RS 2005 like it did in RS
2000...
<BorderStyle>
<Bottom>None</Bottom>
<Default>Solid</Default>
</BorderStyle>
This does, however, work to hide the bottom border.. but very time-consuming
to try and change... (the default setting for the borderstyle in RS 2005 is
'None')
<BorderStyle>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
I appreciate your help in advance!On Mar 21, 4:13 pm, DBS5150 <DBS5...@.discussions.microsoft.com> wrote:
> In RS 2005, I cannot hide a particular border by setting it to 'None' if the
> Default border setting is 'Solid'.
> I can get the desired result by setting the Default border to 'None' and
> then setting only the borders I want to display to 'Solid', however, this is
> not convenient to me as I have a large amount of reports where the Default is
> solid and the borders I want hidden are set to 'None', which used to work
> fine in RS 2000. Is this a bug? The control I am dealing with is a textbox,
> but I have also tested a rectangle and the body of the report itself, and the
> borderstyle is acting the same with all 3 objects. Also, let me add that in
> layout mode while I am designing the report the borders appear to be
> displaying/hiding as I would expect, but when the report is actually ran or
> previewed is when the borders do not behave appropriately.
> To be absolutely clear, here is an example:
> The following does NOT hide the bottom border in RS 2005 like it did in RS
> 2000...
> <BorderStyle>
> <Bottom>None</Bottom>
> <Default>Solid</Default>
> </BorderStyle>
> This does, however, work to hide the bottom border.. but very time-consuming
> to try and change... (the default setting for the borderstyle in RS 2005 is
> 'None')
> <BorderStyle>
> <Top>Solid</Top>
> <Left>Solid</Left>
> <Right>Solid</Right>
> </BorderStyle>
> I appreciate your help in advance!
As far as I know, this is the only way to get the results you are
looking for; however, I can't say if it is a flaw or not: I guess we
would have to know MS's desired outcome to know. Sorry to not be of
more assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer