bar chart problem

I have read through all posts regarding 'bar chart" or "column chart", but
did not find simliar situation which would resolve my problem, although it
looks simple.
A table/dataset cotains two columns, first ProductID, second
SalesAmountPercentageChange. I linked the bar chart with the dataset, I added
in "values" =!Field.SalesAmountPercentageChange, I added in "series groups"
=!Fields.ProductID. This way, I can have the bars displayed in different
color, which would be the same color if I add the !Fileds.ProductID into
"Category group".
Now the trouble is this, although the SalesAmoutPercentageChange is SAME for
different ProductID ( I have 5 product with 39% change for each) as designed,
the bar length VARIES (!!!) for different ProductID, which does not make
sense. Also, there are five 39% change corresponding to 5 products spread out
along the horizontal-axis (in my opinion should be named as X-axis, yet funny
enough it is actually Y-axis in RS).
I am quite confused. I tried many different combinations, turning things on
and off, still can not make it work. Any help will be greatly appreciated.
Also, I am trying to add into the bar chart another element
"TotalPercentageChange", not sure how to do that. It looks I can not simply
add a value2 on top of the value "!Field.SalesAmountPercentageChange". I
figured that it is necessary to pass a new dataset into chart, this new
dataset would contain the total + original table. Total is something
accessible in the report scope, the question is, where does it reside, how
can I use select statement to pick it out and combine it with original table
into a new one?
$10 for solving this problem, just give me your paypal account :).
--
SincerelyDid you get this resolved?
If not, can you post your RDL? In addition, if you have SP1 installed, there
should be a data cache file (.rdl.data) in the same directory as your .rdl
file. The .rdl.data would show the actual data values you are using.
Alternatively, it would help if you can reproduce the issue with the sample
databases (Northwind or Adventure Works) and post the corresponding RDL
file.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:247C97F2-9783-45C2-8ACA-E085075AFBDE@.microsoft.com...
> I have read through all posts regarding 'bar chart" or "column chart", but
> did not find simliar situation which would resolve my problem, although it
> looks simple.
> A table/dataset cotains two columns, first ProductID, second
> SalesAmountPercentageChange. I linked the bar chart with the dataset, I
added
> in "values" =!Field.SalesAmountPercentageChange, I added in "series
groups"
> =!Fields.ProductID. This way, I can have the bars displayed in different
> color, which would be the same color if I add the !Fileds.ProductID into
> "Category group".
> Now the trouble is this, although the SalesAmoutPercentageChange is SAME
for
> different ProductID ( I have 5 product with 39% change for each) as
designed,
> the bar length VARIES (!!!) for different ProductID, which does not make
> sense. Also, there are five 39% change corresponding to 5 products spread
out
> along the horizontal-axis (in my opinion should be named as X-axis, yet
funny
> enough it is actually Y-axis in RS).
> I am quite confused. I tried many different combinations, turning things
on
> and off, still can not make it work. Any help will be greatly appreciated.
> Also, I am trying to add into the bar chart another element
> "TotalPercentageChange", not sure how to do that. It looks I can not
simply
> add a value2 on top of the value "!Field.SalesAmountPercentageChange". I
> figured that it is necessary to pass a new dataset into chart, this new
> dataset would contain the total + original table. Total is something
> accessible in the report scope, the question is, where does it reside,
how
> can I use select statement to pick it out and combine it with original
table
> into a new one?
> $10 for solving this problem, just give me your paypal account :).
>
>
> --
> Sincerely|||If the <Min></Min> element is missing in the RDL file, then the chart will
use the "autoscale" mode. I.e. the minimum value of all datapoints in the
chart will become the minimum value for the y-axis.
If a Min element is present (but the content is not a valid number), then
the chart control will not use the autoscale mode.
Note: removing a previously specified Min-value in the chart properties
dialog in report designer will only remove the Min element in the underlying
RDL file if the Min-field in the dialog is completely cleared out before
hitting OK.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:E59D78EF-7B4C-4B33-8C3E-3C5D649674DF@.microsoft.com...
> This is an absolute bug. I digged more.
> I made a new chart, adding data set, then value, then series, and it
works,
> But the old chart with problem is still there. I compared the xml section
for
> these two charts side by side, line by line.
> I found only one line of difference, the working chart's rdl has <Min>
> </Min>, the other does not. I went to the report layout and accessed the
> chart property of not working one. in "Y axis" --> "Scale" --> "minimum",
I
> typed in a space, (any other character works two), then it works. all bar
> length goes back to normal. If I do not type anything, then it won't work.
> I believe under the hood, there is no default setting for min, and this
> causes serious problem.
> I am going to reproduce this problem in Northwind db and post the rdl. I
> hope it will be reproduced soon.
> By far, this is a bug in bar chart, I am pretty sure.
>
> "Robert Bruckner [MSFT]" wrote:
> > Did you get this resolved?
> > If not, can you post your RDL? In addition, if you have SP1 installed,
there
> > should be a data cache file (.rdl.data) in the same directory as your
.rdl
> > file. The .rdl.data would show the actual data values you are using.
> > Alternatively, it would help if you can reproduce the issue with the
sample
> > databases (Northwind or Adventure Works) and post the corresponding RDL
> > file.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
> > news:247C97F2-9783-45C2-8ACA-E085075AFBDE@.microsoft.com...
> > >
> > > I have read through all posts regarding 'bar chart" or "column chart",
but
> > > did not find simliar situation which would resolve my problem,
although it
> > > looks simple.
> > >
> > > A table/dataset cotains two columns, first ProductID, second
> > > SalesAmountPercentageChange. I linked the bar chart with the dataset,
I
> > added
> > > in "values" =!Field.SalesAmountPercentageChange, I added in "series
> > groups"
> > > =!Fields.ProductID. This way, I can have the bars displayed in
different
> > > color, which would be the same color if I add the !Fileds.ProductID
into
> > > "Category group".
> > >
> > > Now the trouble is this, although the SalesAmoutPercentageChange is
SAME
> > for
> > > different ProductID ( I have 5 product with 39% change for each) as
> > designed,
> > > the bar length VARIES (!!!) for different ProductID, which does not
make
> > > sense. Also, there are five 39% change corresponding to 5 products
spread
> > out
> > > along the horizontal-axis (in my opinion should be named as X-axis,
yet
> > funny
> > > enough it is actually Y-axis in RS).
> > >
> > > I am quite confused. I tried many different combinations, turning
things
> > on
> > > and off, still can not make it work. Any help will be greatly
appreciated.
> > >
> > > Also, I am trying to add into the bar chart another element
> > > "TotalPercentageChange", not sure how to do that. It looks I can not
> > simply
> > > add a value2 on top of the value "!Field.SalesAmountPercentageChange".
I
> > > figured that it is necessary to pass a new dataset into chart, this
new
> > > dataset would contain the total + original table. Total is something
> > > accessible in the report scope, the question is, where does it reside,
> > how
> > > can I use select statement to pick it out and combine it with original
> > table
> > > into a new one?
> > >
> > > $10 for solving this problem, just give me your paypal account :).
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Sincerely
> >
> >
> >

Bad Installation But Cannot Uninstall Reporting Services - Need He

I seem to have had a problem regarding my installation of SQL Server 2005 -
Developer Edition on my Windows XP Pro machine. I have tried to uninstall
either Reporting Services or all of SQL Server. However, it keeps getting
stuck in the Uninstall of Reporting Services and then does a rollback.
The error that I am getting in each case is as follows:
Setup failed to read IISMEMMAP TABLE. The Errorcode is -2147024893.
Does anyone know how to get out of this so I can try to fix the installation?
Thanks for any advice.
--
John GallagherHi John,
You may try using the tools below to remove SQL Server 2005 manually
Description of the Windows Installer CleanUp Utility
http://support.microsoft.com/kb/290301/en-us
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Backups

Hi Guys,

I'm pretty new to SQL Server. I have a ? regarding backups.

I have a database which I'm backing up everyday using BACKUP DATABASE db TO db_bak WITH INIT. This job runs everyday successfully, but I'm having an evergrowing transaction log file. I presumed a full database backup will apply transaction logs and will truncate the log files. Isnt it so, or am i missing some concepts? This database can have a data loss of 1 day which is covered by my full database backup job. I dont need a transaction log backup. But to reduce log file size should I do a log backup?

-Sunil.Depends...(love that answer)

What's your recovery model? Simple would do what you're thinking...

I have a feeling it's FULL...in which case you need to dump the tranny too...

Look at the maint plan wizard to help you out

Also you need to determine what type of strategy you need to employ...

Basically, how much time/data can you afford to lose...|||Thanks Brett,

My recovery model is FULL and i prefer to keep it that way. So, i reckon I should set transaction log backups aswell. I have set database backup to run every 6PM, if i create another job to backup transaction logs at 7PM, will it do? Also, since my database is big (It is MSProject database) database backup is done everyday in overwrite mode to avoid appending 200MB everyday to the backup file. Could transaction log backup be done in overwrite mode aswell or is it necessary to be appended every day? If there is a recovery scenario, will it all add well?

I'm still wondering why isnt transaction log truncated after a successful full backup. Why do we need transaction logs if the database itself is fully backed up.

-Sunil.|||Originally posted by sunilthomas98
I'm still wondering why isnt transaction log truncated after a successful full backup. Why do we need transaction logs if the database itself is fully backed up.
-Sunil.

Because it is a point in time backup...logs are usually dumped periodically to recover data throughout the daya (I do mine every 10 minutes)

Why not first go through the db maint wizard...it'll show you all the things you can do, without having to code them in T-SQL...it'll even schedule the jobs...

Then by a book...one of my favorites is SQL Server 911 by Brian Knight..good book

Here's a real story...

HR "dba" (the quotes are on purpose) had the type of scenario you mention..

It was time to enter in all the work for the bonuses...which got done...

Now scrub boy messed something up...we think he had a glitch a decided to recover the db from last nights dump...effectivley wiping out all the work the clerks had enetered...soooooo no bonuses...right?

Wrong...the vp called ALL of the clerks in plus IT staff to re-enter the data...so at about 4:00 am it was done...and the file went out the next day...

He's not with us anymore...|||Thanks Brett, I'll do that not to miss my next bonus (if it comes)

Backup troubles

Hi,
I need some help with a logic for a important document I need to create. Its
regarding my Backup procedures that require me to test my database backups
every 3 months. The problem occurs that I do not have another server to test
out the database. So my solution was the following:
* Backup DB
* Restore DB redirected towards another DB
Now the problem is that QA doesnt think that is enough. I noticed that SQL
2005 (starting since SQL 2000) has this option which alot of 3rd party
Backup application use (my case backup exec 10d) "consistency check".
I am wondering if I set a consistency check at Backup and then at restore
with consistency check, could I absolutely prove that both databases are
EXACTLY the same.
Example using MD5 for comparing 2 files.
"Consistency check is the MD5 for the DB"
Thank you so much,
George S.Hi
The restoration of the database will only prove that you can backup and
restore that backup i.e. the backup was not corrupted. It does not mean to
say that the restored database is the one that you backed up i.e. the backup
was not subsequently overwritten with a different backup. Therefore the issue
is one for protecting the backup and making sure it is not tampered with. A
checksum of the backup file may help, but then it doesn't mean that someone
has not tampered with where that is stored either!! If checking consistency
is the same as a DBCC CHECKDB it is not a comparison of the two databases.
HTH
John
"George Spiro" wrote:
> Hi,
> I need some help with a logic for a important document I need to create. Its
> regarding my Backup procedures that require me to test my database backups
> every 3 months. The problem occurs that I do not have another server to test
> out the database. So my solution was the following:
> * Backup DB
> * Restore DB redirected towards another DB
> Now the problem is that QA doesnt think that is enough. I noticed that SQL
> 2005 (starting since SQL 2000) has this option which alot of 3rd party
> Backup application use (my case backup exec 10d) "consistency check".
> I am wondering if I set a consistency check at Backup and then at restore
> with consistency check, could I absolutely prove that both databases are
> EXACTLY the same.
> Example using MD5 for comparing 2 files.
> "Consistency check is the MD5 for the DB"
> Thank you so much,
> George S.
>
>|||So what exactly is the Check consistency option on SQL 2000 / 2005?
G.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6D092594-641C-46D3-92ED-78F3D0E13678@.microsoft.com...
> Hi
> The restoration of the database will only prove that you can backup and
> restore that backup i.e. the backup was not corrupted. It does not mean to
> say that the restored database is the one that you backed up i.e. the
> backup
> was not subsequently overwritten with a different backup. Therefore the
> issue
> is one for protecting the backup and making sure it is not tampered with.
> A
> checksum of the backup file may help, but then it doesn't mean that
> someone
> has not tampered with where that is stored either!! If checking
> consistency
> is the same as a DBCC CHECKDB it is not a comparison of the two databases.
> HTH
> John
> "George Spiro" wrote:
>> Hi,
>> I need some help with a logic for a important document I need to create.
>> Its
>> regarding my Backup procedures that require me to test my database
>> backups
>> every 3 months. The problem occurs that I do not have another server to
>> test
>> out the database. So my solution was the following:
>> * Backup DB
>> * Restore DB redirected towards another DB
>> Now the problem is that QA doesnt think that is enough. I noticed that
>> SQL
>> 2005 (starting since SQL 2000) has this option which alot of 3rd party
>> Backup application use (my case backup exec 10d) "consistency check".
>> I am wondering if I set a consistency check at Backup and then at restore
>> with consistency check, could I absolutely prove that both databases are
>> EXACTLY the same.
>> Example using MD5 for comparing 2 files.
>> "Consistency check is the MD5 for the DB"
>> Thank you so much,
>> George S.
>>|||Hi George
I don't use backup exec so I can not be sure, but the sales literature does
talk about performing DBCC commands, I don't think that it is anything that
will help you, although you may want to check with Symantic directly.
John
"George Spiro" wrote:
> So what exactly is the Check consistency option on SQL 2000 / 2005?
> G.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:6D092594-641C-46D3-92ED-78F3D0E13678@.microsoft.com...
> > Hi
> >
> > The restoration of the database will only prove that you can backup and
> > restore that backup i.e. the backup was not corrupted. It does not mean to
> > say that the restored database is the one that you backed up i.e. the
> > backup
> > was not subsequently overwritten with a different backup. Therefore the
> > issue
> > is one for protecting the backup and making sure it is not tampered with.
> > A
> > checksum of the backup file may help, but then it doesn't mean that
> > someone
> > has not tampered with where that is stored either!! If checking
> > consistency
> > is the same as a DBCC CHECKDB it is not a comparison of the two databases.
> >
> > HTH
> >
> > John
> >
> > "George Spiro" wrote:
> >
> >> Hi,
> >>
> >> I need some help with a logic for a important document I need to create.
> >> Its
> >> regarding my Backup procedures that require me to test my database
> >> backups
> >> every 3 months. The problem occurs that I do not have another server to
> >> test
> >> out the database. So my solution was the following:
> >>
> >> * Backup DB
> >> * Restore DB redirected towards another DB
> >>
> >> Now the problem is that QA doesnt think that is enough. I noticed that
> >> SQL
> >> 2005 (starting since SQL 2000) has this option which alot of 3rd party
> >> Backup application use (my case backup exec 10d) "consistency check".
> >>
> >> I am wondering if I set a consistency check at Backup and then at restore
> >> with consistency check, could I absolutely prove that both databases are
> >> EXACTLY the same.
> >>
> >> Example using MD5 for comparing 2 files.
> >> "Consistency check is the MD5 for the DB"
> >>
> >> Thank you so much,
> >>
> >> George S.
> >>
> >>
> >>
>
>