Hi,

What you are looking for is cascading parameters.

There are stacks of tutorials about for this that explain it better than I ever could, here's a couple to start.

http://msdn.microsoft.com/en-us/library/aa337498%28v=sql.105%29.aspx

http://sql-bi-dev.blogspot.co.uk/2010/08/cascading-parameters-in-ssrs-2008.html

Your example sounds...

Hi Tim,

The different rendering extensions support different levels of interactivity. Toggle items are not supported in MHTML rendering it just exports the report as you see it, i.e. expanded...

Hi,

The number of columns for your report can be adjusted with the Columns property of the Report.

When you have an open report click on the yellow area surrounding and press...

You can use an expression for the indicator value to return a value in the right range for your indicator.

E.g. =Iif(Fields!fld.Value = "True",75,20)

would give you green for true or...

Nicely done, it's not dynamic though 🙂

I did say to add a row group, with a header row.

You need to delete the Details group from the Row Groups box at the bottom of BIDS (I only...

Hi,

As far as I am aware it's not possible to dynamically hide a column based on groups in a single tablix due to how it is rendered. You can...

I think you need to be putting the Iif statement in the Sum i.e.

=SUM(IIF(Fields!acct.Value >= 40000 and Fields!acct.Value <= 50000,Fields!amt.Value,0))

This way it evaluautes the Iif statement for each row and...

Look at using a group by:

SELECT State.StateAbbr, COUNT(*) AS [Total]

FROM Address INNER JOIN

Station ON Address.AddressKey = Station.AddressKey INNER JOIN

State ON Address.StateOrProvince = State.StateID

GROUP BY State.StateAbbr

I suspect your groupings might not be right.

You are not dealing with one series, you are dealing with two.

7/10/2006 - 9/1/07 is one

9/3/2007 - 9/1/2013 is two.

Have a...

Indeed there is.

Not sure how you are doing your categories/series groups.

You need to have a ID for a series group so min/max on the dates breaks up correctly. This...

Try looking at the STRTOMEMBER function.

e.g.

STRTOMEMBER("[Date].[Calendar Year].&[" + CSTR(YEAR(NOW())) + "]")

Tillman Eitelberg has created a useful set of SSIS components that includes a report generator task. I recently used it to do something similar.

http://www.ssis-components.net/page/Komponenten.aspx

I created a resultset...

Sound like you want to look at reportitems.

Try:

ReportItems!txtboxYTD_AvailabilityRate.value

The users probably have their default browser language settings as en-US and yours is en-GB so it messes up the date conversion.