sql server reporting services:
I have an Area Chart with four different values plotted on it, as 25th
Percentile, Median value, 75th Percentile and the Customer data.
Now that with SP1, we can specify FILL color, it has become very useful on
this Area chart. (mind you this is Simple Area chart).
However, in certain cases where the customer data completely falls above say
25th Percentile, the whole FILL area of 25th Percentile is overlapped with
the Customer data (and overtaken by Customer FIll color)
SO, I used for customer data, the background color as <Transparent>.
While chossing color and borders etc, the image that is brought up in the
<Layout> window matches with what selection I've made. However, in the
<Preview> window, the Chart takes GREEN fill-color (mind you, I've chosen
Transaparent color) and thus washes away the area for 25th Percentile
(considering the situation wher the customer data values fall above the 25th
Percentile)
jfyi: The palette I've chosen in this case is <Default> However, I've
already tried with all supported palettes..! They all result into some FILL
color for my customer data.
I do not understand, why is the display in <Preview Window> any different
from the <Layout window> ????
The other strategy I've tried is, to plot Customer data as a solid black
line, but seems that feature is not supported (<Plot data as a line>), as
well.
Pls. guide.