Manage style of reports from one place?

Is it possible to maintain the style of all of my reports from one place,
say by using a style sheet or by applying a template?
--
McGeeky
http://mcgeeky.blogspot.comThis will help you:
http://www.databasejournal.com/features/mssql/article.php/3422801
It´s a nice guide.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> Is it possible to maintain the style of all of my reports from one place,
> say by using a style sheet or by applying a template?
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>|||Hi Jens,
Thanks for getting back to me with the link. It is useful but it doesn't
quite fit my requirements. The template approach helps when creating a new
report but what if you already have existing reports and you want to change
their look? It seems overly labourious to go in to every report and manually
change all the fonts, colours etc.
Thanks
--
McGeeky
http://mcgeeky.blogspot.com
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> This will help you:
> http://www.databasejournal.com/features/mssql/article.php/3422801
> It´s a nice guide.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> Is it possible to maintain the style of all of my reports from one place,
>> say by using a style sheet or by applying a template?
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>|||If all your reports are the same layout e.g. excel style, you could write
something to parse the reports & apply in your fonts, colours etc. using
xpath. The report would have to be published as a new report, but you could
always delete the old one or move it to a new folder.
Obviously if all the reports are different layouts, then this technique
won't be so good as you'd end up writing a parser for each report!
"McGeeky" wrote:
> Hi Jens,
> Thanks for getting back to me with the link. It is useful but it doesn't
> quite fit my requirements. The template approach helps when creating a new
> report but what if you already have existing reports and you want to change
> their look? It seems overly labourious to go in to every report and manually
> change all the fonts, colours etc.
> Thanks
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> > This will help you:
> >
> > http://www.databasejournal.com/features/mssql/article.php/3422801
> >
> > It´s a nice guide.
> >
> > HTH, Jens Suessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> >> Is it possible to maintain the style of all of my reports from one place,
> >> say by using a style sheet or by applying a template?
> >>
> >> --
> >> McGeeky
> >> http://mcgeeky.blogspot.com
> >>
> >>
> >>
> >
> >
>
>|||Thanks for your suggestion. As the number of reports increases I may need to
do something like that.
I found an article since posting this question that said that stylesheets
are not supported in this version of reporting services but will be
introduced in a later version. I suppose you don't know which version that
would be?
Thanks.
--
McGeeky
http://mcgeeky.blogspot.com
"mark-s" <marks@.discussions.microsoft.com> wrote in message
news:F261DC6E-E8CA-428F-A765-5C4688BE4CD4@.microsoft.com...
> If all your reports are the same layout e.g. excel style, you could write
> something to parse the reports & apply in your fonts, colours etc. using
> xpath. The report would have to be published as a new report, but you
> could
> always delete the old one or move it to a new folder.
> Obviously if all the reports are different layouts, then this technique
> won't be so good as you'd end up writing a parser for each report!
> "McGeeky" wrote:
>> Hi Jens,
>> Thanks for getting back to me with the link. It is useful but it doesn't
>> quite fit my requirements. The template approach helps when creating a
>> new
>> report but what if you already have existing reports and you want to
>> change
>> their look? It seems overly labourious to go in to every report and
>> manually
>> change all the fonts, colours etc.
>> Thanks
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in
>> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> > This will help you:
>> >
>> > http://www.databasejournal.com/features/mssql/article.php/3422801
>> >
>> > It´s a nice guide.
>> >
>> > HTH, Jens Suessmeyer.
>> >
>> > --
>> > http://www.sqlserver2005.de
>> > --
>> >
>> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
>> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> >> Is it possible to maintain the style of all of my reports from one
>> >> place,
>> >> say by using a style sheet or by applying a template?
>> >>
>> >> --
>> >> McGeeky
>> >> http://mcgeeky.blogspot.com
>> >>
>> >>
>> >>
>> >
>> >
>>

manage Data replicated

I have two Db with Merge Transactional replication.
I would like to delete some data in Db replicated but maintain in the
principal DB.
what i can do, what tunig for this feature ?
thanks in advance
stper
maybe one solution is to create NOT a Merge replication but a Transactinal
replication ?
thanks
stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:#mhABKBlEHA.3544@.TK2MSFTNGP15.phx.gbl...
> I have two Db with Merge Transactional replication.
> I would like to delete some data in Db replicated but maintain in the
> principal DB.
> what i can do, what tunig for this feature ?
> thanks in advance
> stper
>

manage Data replicated

I have two Db with Merge Transactional replication.
I would like to delete some data in Db replicated but maintain in the
principal DB.
what i can do, what tunig for this feature ?
thanks in advance
stpermaybe one solution is to create NOT a Merge replication but a Transactinal
replication ?
thanks
stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:#mhABKBlEHA.3544@.TK2MSFTNGP15.phx.gbl...
> I have two Db with Merge Transactional replication.
> I would like to delete some data in Db replicated but maintain in the
> principal DB.
> what i can do, what tunig for this feature ?
> thanks in advance
> stper
>sql

Making small database on iPaq

Hello

I am trying to maintain a small database on my iPAQ, can somebody tell me that would database be created in SQL Server Mobile on my iPaq and can my VB.net based Windows CE application can access data from the database on my iPAQ

tHNAKS

if your iPaq runs Pocket PC 2003 or Windows Mobile 5, then yes, you can create a VB.NET application using Visual Studio 2005 and the .NET Compact Framework 2.0 that can work with data in a SQL Mobile database on your device.

Darren