Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts

Tuesday, March 27, 2012

Changing color of the report parameter viewer tool bar

Hey peeps,
I am wondering to know if there is a way to change the color of the SQL
Report parameter strip when the report is rendered. I tried changing a few
classes in the Reportingservice.css file but those changes reflect only in
the outer region(the container of the report, not the frame). When the report
is rendered, a new css file named "8.00.743.00HtmlViewer.css" is generated
dynamically which is holding control to the class files used by different
items in that tool bar. How would I get access to this newly generated css
file or howelse could I change the color of the tool bar that contains items
like "Find", "Export" buttons. Awaiting your suggestion.
Thanks
BalajiThis is a multi-part message in MIME format.
--=_NextPart_000_007D_01C534BB.3A051EF0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
RS SP1 has additional url access parameter Stylesheet that specifies a =style sheet to be applied to the HTML viewer..
You need to make your own file and save it to 'C:\Program =Files\Microsoft SQL Server\MSSQL\Reporting =Services\ReportServer\styles\custom.css'
Here is example:
http://servername/reportserver?/SampleReports/Report1&rs:Command=3DRender=
&rc:Stylesheet=3DCustom
The following style makes parameters row blue:
.MenuBarBkGnd
{
background-color: blue
}
PS:
New in SP2. The <HTMLViewerStyleSheet> property has been added to the =Reporting Services configuration file so that you can specify a new =default style sheet for your HTML viewer.
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message =news:C57EAA6A-1B94-4DF4-9F13-01E3CD433401@.microsoft.com...
> Hey peeps,
> > I am wondering to know if there is a way to change the color of the =SQL > Report parameter strip when the report is rendered. I tried changing a =few > classes in the Reportingservice.css file but those changes reflect =only in > the outer region(the container of the report, not the frame). When the =report > is rendered, a new css file named "8.00.743.00HtmlViewer.css" is =generated > dynamically which is holding control to the class files used by =different > items in that tool bar. How would I get access to this newly generated =css > file or howelse could I change the color of the tool bar that contains =items > like "Find", "Export" buttons. Awaiting your suggestion.
> > Thanks
> Balaji
--=_NextPart_000_007D_01C534BB.3A051EF0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

RS SP1 has additional url access =parameter Stylesheet that specifies a style sheet to be applied to the HTML viewer..
You need to make your own file and save =it to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles\custom.css'
Here is example:
http://servername/reportserver?/SampleReports/Report1&rs:Com=mand=3DRender&rc:Stylesheet=3DCustom
The following style makes parameters =row blue:
.MenuBarBkGnd{ background-color: blue}
PS:
New in SP2. The property has =been added to the Reporting Services configuration file so that you can =specify a new default style sheet for your HTML viewer.
"Balaji" wrote in message news:C57EAA6A-1B94-4DF4-9F13-01E3CD433401@.microsoft.com...> =Hey peeps,> > I am wondering to know if there is a way to =change the color of the SQL > Report parameter strip when the report is =rendered. I tried changing a few > classes in the Reportingservice.css file =but those changes reflect only in > the outer region(the container of the =report, not the frame). When the report > is rendered, a new css file =named "8.00.743.00HtmlViewer.css" is generated > dynamically which is =holding control to the class files used by different > items in that tool =bar. How would I get access to this newly generated css > file or =howelse could I change the color of the tool bar that contains items > =like "Find", "Export" buttons. Awaiting your =suggestion.> > Thanks> Balaji

--=_NextPart_000_007D_01C534BB.3A051EF0--

Thursday, March 8, 2012

change tracking for SQL Server

Has anyone come across a change tracking tool for SQL Server. Specifically
the scenario I want is the following :

A Production DB needs some modifications to its content.
This tool will copy the DB to a dev environment.
The Dev environment will be 2 copies of the DB, 1 as a control set and the
other the change DB.
The developer makes their changes in the Change DB. They test them out and
then when they decide the changes are ready to pushto production they hit
the "go" button on the tool.
The tool calculates the delta between the Control and the Change DB and then
pushes the changes to produciton

Any ideas

Thanks

s"Steve Mew" <steve_mew@.hotmail.com> wrote in message news:<wWnib.8720$843.5779@.nwrddc03.gnilink.net>...
> Has anyone come across a change tracking tool for SQL Server. Specifically
> the scenario I want is the following :
> A Production DB needs some modifications to its content.
> This tool will copy the DB to a dev environment.
> The Dev environment will be 2 copies of the DB, 1 as a control set and the
> other the change DB.
> The developer makes their changes in the Change DB. They test them out and
> then when they decide the changes are ready to pushto production they hit
> the "go" button on the tool.
> The tool calculates the delta between the Control and the Change DB and then
> pushes the changes to produciton
> Any ideas
> Thanks
> s

I'm not aware of a single tool that would do exactly what you want,
however you could start by looking at the Red Gate SQL tools
(http://www.red-gate.com), which can compare two databases and
generate scripts to synchronize them. There are similar tools from
other vendors.

Copying the databases is easily automated (backup/restore, SQLDMO,
DTS), but you might want to consider the permissions involved. Many
sites do not allow developers to backup/restore databases or push code
directly to production (although to be fair, there are certainly many
that do).

Simon|||Steve Mew (steve_mew@.hotmail.com) writes:
> Has anyone come across a change tracking tool for SQL Server. Specifically
> the scenario I want is the following :
> A Production DB needs some modifications to its content.
> This tool will copy the DB to a dev environment.
> The Dev environment will be 2 copies of the DB, 1 as a control set and the
> other the change DB.
> The developer makes their changes in the Change DB. They test them out and
> then when they decide the changes are ready to pushto production they hit
> the "go" button on the tool.
> The tool calculates the delta between the Control and the Change DB and
> then pushes the changes to produciton

For the scenario you describe it sounds like SQL Compare from Red Gate
is the tool to use. However, I have never used this tool myself.

I cannot escape to take the occassion to point out that the best strategy
would be have all your source in a version control system, and then have
controlled procedures from building update scrtips from the version-
control system.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp