Styles for reports to Reporting Services 2005?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ayos - 02 Oct 2006 09:23 GMT

Hi,

We are currently working on a project where we need to have all our reports
to have a common style
(Reporting Services 2005), but we struggling to find out how to find a way
where we can have a common style
implemented for all our reports.

For example if I need all tables to have the same font size and colour. If I
had a style
where I can change the colour and font for the tables.

Our aim is to be able to change the style at one place and then all the
reports are updated.

How and can I implement styles to the reports?

Kind Regards

Ayman

Reply to this Message

Michael Morisoli - 02 Oct 2006 14:27 GMT

You know I have pondered this very thing myself. There is nothing built
into SSRS to handle this but the method I have begun to implement is to
first start with a detailed "style" document that details each attribute and
the values to be used. Things like detail row height, fonts, background
colors, header sizes.

You might want to take a look at the Microsoft CRM v3.0 SDK. It has a
killer document that tells developers how to build reports that match the MS
supplied SSRS reports in CRM.

From there my idea was to store these values into a database and then simply
have a dataset that reads the values for the specific report using some
numbering convention.

The problem I am running into is little things like where you can use field
names and where you can't. My next proof of concept that I have not done
yet will be to create a custom class assembly that does the heavy lifting
and returns values, but I need to make sure these class objects can be
referenced from all of the areas of a report that is required.

I know this doesn't solve your question, but I thought sharing ideas might
be of use too. Please take the time to look at the CRM document, it really
is a great example of how detailed you can get in your specifications.

Hth, Mike

> Hi,
>
[quoted text clipped - 16 lines]
>
> Ayman

Reply to this Message

Chris - 02 Oct 2006 15:38 GMT

I haven't implemented this, but someone posted this a while back.

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_f
rm/thread/3ff51b1a93b98d87/a6b124d4161834d4?lnk=gst&q=template&rnum=11#a6b124d41
61834d4

> Hi,
>
[quoted text clipped - 16 lines]
>
> Ayman

Reply to this Message

Alex Jenkins - 03 Oct 2006 00:57 GMT

We are currently working on an in-house tool to create this
functionality, with the possibility of a commercial release.

Please check this post, and add anything you think we are missing!

http://groups.google.com.au/group/microsoft.public.sqlserver.reportingsvcs/brows
e_thread/thread/3513af4b1ade067c/5cb6a58d094f0507?lnk=st&q=google+groups+stylesh
eet+XML+interest&rnum=7#5cb6a58d094f0507

> Hi,
>
[quoted text clipped - 16 lines]
>
> Ayman

Reply to this Message

mauliko@gmail.com - 31 Oct 2006 19:02 GMT

Alex -

It certainly would be a great help when one could apply a certain style
to multiple reports.

Maybe a command line utility that takes in a report directory and
applies the style across all the reports.

Regards,
Maulik

> We are currently working on an in-house tool to create this
> functionality, with the possibility of a commercial release.
[quoted text clipped - 23 lines]
> >
> > Ayman

Reply to this Message

aaron.kempf@gmail.com - 31 Oct 2006 22:10 GMT

I just think that we all should move back to Crystal; Microsoft isn't
taking this market seriously

but thank god they came out with the xbox 360!

ROFL

On Oct 31, 10:02 am, "maul...@gmail.com" <maul...@gmail.com> wrote:

> Alex -
>
[quoted text clipped - 34 lines]
>
> > > Ayman- Hide quoted text -- Show quoted text -

Reply to this Message