There is a free report generator task https://reportgeneratortask.codeplex.com/ for SSIS that I've used before, it's pretty smart and well maintained. The one thing to be aware of is that...

You can use the following expression in the Group footer where Cusotmer is the grouping value and DataSet1 is the name of your dataset.

=RunningValue(Fields!Customer.Value, CountDistinct,"DataSet1")

I'm assuming your earlier example is...

Your bracketing is a bit off and you need an And in there (it's easier to read then nested iif's when there are only two outcomes) - this should work:

=sum(

iif(

Fields!Month_Place_Test.Value...

It looks like your script file "c:\Deployment\PUBLISHREPORT.rss" doesn't exist or you have typed the path incorrectly. If you remove the -t switch, the error message is much clearer.

Hi Kocheese,

This looks like your report is using a Report Model (https://technet.microsoft.com/en-us/library/dd220475%28v=sql.105%29.aspx) as a datasource.

There wont be a SQL query in the report as it queries the semantic layer...

.

Scratch that.

You need to date twice once for the parameter value, as a date, and once for the parameter label as formatted text.

You can add another field to your dataset where...

If you can open it in BIDS / SSDT the Document Outline window is the way to find these things.

Ahh. I see what you mean, unfortunately I'm stumped on this one, not sure it is possible with how SSRS line charts work.

Soz, hopefully someone else can help.

You can achieve this by using an expression in the Fill property of the Series.

Right click the Series -> Series Properties -> Fill -> Color.

An expression like =Iif(Fields!yval.Value > 50,...

Hi Renzo,

If the fields of the returns datasets are not identical it will not be possible. SSRS cannot dynamically generate a dataset.

The reason it returns the first dataset when...

Hi Dee,

The function you are looking for is LookupSet. You can lookup a set of values in your dataset via a lookup value, like your invoice number. This...

Hi Christian,

It's not too hard to do this and you can genericise it to a point. You can use the globals to put together the URL but you need...

Hi,

If you are using Enterprise Edition this is a perfect use-case for Data Driven Subscriptions.

Check out the MSDN article for more details: https://msdn.microsoft.com/en-us/library/ms159150.aspx

Hi Bob,

If your application is using Basic Authentication you need to enable this in the rsreportserver.config file. It is not enabled by default.

Here is the msdn link that explains...