Can we change the style of reports just like css of html

it is stupidity to change color and background for each reports.."Template" report is provided so that you fix up all the things you require
for each report and then copy in a particular folder, so whenever you go for
creating a new report this template can be selected.
Amarnath
"lieshengren" wrote:
> it is stupidity to change color and background for each reports..
>
>|||thanks very much.
My friend give me another way to change the color some other options of
report.
"write the vb expression @.column color, put color configuration in database
"...
oh . so it is hard to write first time. but easy to change.
User's information is about 1000 reocords in the system, so i build a table
to save some color schemas then let user to save a schema to session
information which they want .
^_^!...
but low performance when there is a big user's information.
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:14D750CC-8A50-4CB6-A4FoA-D639AE6AA2DD@.microsoft.com...
> "Template" report is provided so that you fix up all the things you
> require
> for each report and then copy in a particular folder, so whenever you go
> for
> creating a new report this template can be selected.
> Amarnath
> "lieshengren" wrote:
>> it is stupidity to change color and background for each reports..
>>|||If you want to avoid the performance issue you could do something like this
instead of the dynamic vb expression:
* -- create the original report with a custom property indicating the "style
element" -- would be the class -- of as many individual textboxes and other
layout items as you want
* -- when a user wants to assign a color scheme, load the original RDL up as
XML and use the class information to adjust the color and any other
attributes you support in the RDL metadata. You can do this through the DOM
if you like -- I do it through XSLT but people here are probably tired of
hearing about that <g>. It doesn't matter how you implement it.
* -- save a copy of the RDL to a new name -- include a theme ID or something
concatenated with the original report name. Save the user's preference.
* -- at runtime, look up whether the user has a theme associated with that
report (or, if the user picks one theme for all reports, look up to see if
this user has picked a theme). If they have, swap the name of the report to
run for the correct "themed" version.
Now you have a very small hit at runtime and a very flexible reporting
application -- which can support anything that CSS can support and that is
also supported by RDL. You can choose to support more attributes over time,
if you like, even if you just start with color.
>L<
"lieshengren" <lieshengren@.163.com> wrote in message
news:uFhCZT7hHHA.3472@.TK2MSFTNGP04.phx.gbl...
> thanks very much.
> My friend give me another way to change the color some other options of
> report.
> "write the vb expression @.column color, put color configuration in
> database "...
> oh . so it is hard to write first time. but easy to change.
> User's information is about 1000 reocords in the system, so i build a
> table to save some color schemas then let user to save a schema to
> session information which they want .
> ^_^!...
> but low performance when there is a big user's information.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:14D750CC-8A50-4CB6-A4FoA-D639AE6AA2DD@.microsoft.com...
>> "Template" report is provided so that you fix up all the things you
>> require
>> for each report and then copy in a particular folder, so whenever you go
>> for
>> creating a new report this template can be selected.
>> Amarnath
>> "lieshengren" wrote:
>> it is stupidity to change color and background for each reports..
>>
>sql

Can someone provide some insight on this?

[url]http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html[/url
]
So is this saying I can purchase one license of SQL Enterprise 2005 and run
it on as many vm installs as I want? Example, I create 5 windows 2003 server
s
running on vmware and install SQL on each of them, am I'm still legal?ChrisR wrote:
> [url]http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html[/u
rl]
> So is this saying I can purchase one license of SQL Enterprise 2005 and ru
n
> it on as many vm installs as I want? Example, I create 5 windows 2003 serv
ers
> running on vmware and install SQL on each of them, am I'm still legal?
>
I think you're correct. We are also running a number of our servers on
VMWare, so I'll also keep this change in mind. How much it's worth
though is another question, since running SQL server on VMWare isn't
always the best choice. We have some SQL servers on VMWare and some on
physical machines and generally the ones on physical machines runs
better, so I'd be hesitant running to many SQL servers on the same
VMWare box.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Agreed. We haven't even started our SQL on VMWare testing yet, so we
certainly won't be loading up a bunch of them any time soon.
""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%236cU7mEXHHA.496@.TK2MSFTNGP06.phx.gbl...
> ChrisR wrote:
> I think you're correct. We are also running a number of our servers on
> VMWare, so I'll also keep this change in mind. How much it's worth though
> is another question, since running SQL server on VMWare isn't always the
> best choice. We have some SQL servers on VMWare and some on physical
> machines and generally the ones on physical machines runs better, so I'd
> be hesitant running to many SQL servers on the same VMWare box.
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Can someone provide some insight on this?

http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
So is this saying I can purchase one license of SQL Enterprise 2005 and run
it on as many vm installs as I want? Example, I create 5 windows 2003 servers
running on vmware and install SQL on each of them, am I'm still legal?ChrisR wrote:
> http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
> So is this saying I can purchase one license of SQL Enterprise 2005 and run
> it on as many vm installs as I want? Example, I create 5 windows 2003 servers
> running on vmware and install SQL on each of them, am I'm still legal?
>
I think you're correct. We are also running a number of our servers on
VMWare, so I'll also keep this change in mind. How much it's worth
though is another question, since running SQL server on VMWare isn't
always the best choice. We have some SQL servers on VMWare and some on
physical machines and generally the ones on physical machines runs
better, so I'd be hesitant running to many SQL servers on the same
VMWare box.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Agreed. We haven't even started our SQL on VMWare testing yet, so we
certainly won't be loading up a bunch of them any time soon.
""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:%236cU7mEXHHA.496@.TK2MSFTNGP06.phx.gbl...
> ChrisR wrote:
>> http://www.virtualization.info/2007/02/microsoft-unlocks-sql-server-2005.html
>> So is this saying I can purchase one license of SQL Enterprise 2005 and
>> run it on as many vm installs as I want? Example, I create 5 windows 2003
>> servers running on vmware and install SQL on each of them, am I'm still
>> legal?
> I think you're correct. We are also running a number of our servers on
> VMWare, so I'll also keep this change in mind. How much it's worth though
> is another question, since running SQL server on VMWare isn't always the
> best choice. We have some SQL servers on VMWare and some on physical
> machines and generally the ones on physical machines runs better, so I'd
> be hesitant running to many SQL servers on the same VMWare box.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator