SSRS Complex chart with StripLines

One of my demands was to develop a report with a chart like this:

To do that, we have to use Striplines on SSRS chart (Here is Microsoft definition of Striplines).

1St : Select your chart on Report Designer (BIDS OR Report Builder)

Crete your dataset:

Set you Values and your category Groups:

2nd: Here is the section to define Striplines

We start by horizontal ones:

Select your vertical axis properties and go to Strip lines

On collation, click on add and configure your stripline:

Now you can add as many stripline as you want, (for my article, I have added Four striplines):

Configure color on: BackgroundColor
Configure width on: Stripwidth

For vertical ones:

Select your Horizontal axis properties and go to Strip lines

And here just select BackgroundColor (No Color) and BackgroundPatternType (BackwardDiagonal)

That It

Advertisements
This entry was posted in SSRS and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s