Constrain your dataset not to show the next month. If you can't do that, then put a filter the graph.

eclipse

How about a filter on the chart of something like

WHERE Year > @YearParameter - 3

peel

Looks like it will use JPEG, GIF, PNG, and BMP.

Easiest is to drag an image object from the toolbox onto the header (or where ever you want it), name the...

When you create the dataset, there is an option to use a SQL Command/query or a stored procedure. Choose stored procedure and you will get a drop down box...

I don't know that you will actually find what you need there, but I would start with the reporting services config files on the server.

ByronOne (5/17/2012)

---

Thanks everyone.

I'm currently using the foloowing switch function:

=Switch(sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 > -2.5, "Green",sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 < -5.0 , "Red", 1=1, "Yellow")

This is returning GRENN for each of my indicators (they are...

SSRS will not build a stored procedure for you. First you have to build the SP in SSMS or somewhere and then use it in your report. I...

You have two options for show details, neither of which is a radio button.

The first would be to hide all the details on the report and allow the visibility to...

anti-tagonist

A row number would be a useful addition to the flat file source component.

I think your best approach is another script component.

I am looking in BIDS for SQL 2005 right now and I see a fuzzy grouping transform.

I think one of these might give you what you want:

http://www.bidn.com/blogs/briankmcdonald/bidn-blog/717/alternating-group-colors-and-alternating-row-colors

http://www.bidn.com/forums/microsoft-business-intelligence/reporting-services/1189/alternating-color-on-rows

Jr.