Hi Neophilius,

I think you are referring to a Data Virtualisation solution like Teiid (open source) or Denodo. These allow you to model a layer over disparate sources, so you...

"D:\SSIS\Arisys_DB_Import\Integration Services Project1\Arisys_DBA_SSIS.dtsx"

Does this path exist on the server or is this on your local machine?

When you add a SSIS job step the file browser opens to your local machine,...

.

What were you trying to change it to? Do you have another instance of Reporting Services running on the same machine?

That expression looks mighty complicated.

Something like this should work:

=Sum(Iif(Year(Fields!FULLDATE.Value) & "-" & DatePart(DateInterval.Quarter,Fields!FULLDATE.Value) = Year(Now()) & "-" & DatePart(DateInterval.Quarter,Now()),Fields!GA_VISITS.Value, 0))

I haven't really used report models, presumably they have data source deployed on the report manager.

Could you not just find the data source and use "View Dependent Items"?

You need to connect to the Reporting Services instance, not the SQL Server instance that contains the ReportServer db.

If you go to the Object Explorer and click Connect you'll see...

Ahh I see.

I have a feeling I either managed this once or failed - can't remember which but I have tried something similar before.

However, I've had a quick attempt and...

You can do this with striplines. These can be found in the axis properties, by which I mean selecting the axis and pressing F4, not through the right click...

You can use the function as an expression in the Visible property for the row and it will get evaluated for each row. If you can set it to...

This should do it, you just need to add the Compare := CompareMethod.Text to each replace function you use.

=Replace(

Replace(

Fields!Report_of_Progress.Value,"cancel", "<span style='color:red;'>cancel</span>", Compare := CompareMethod.Text

)

,"no show", "<span style='color:red;'>no show</span>", Compare...

You could create it in the reporting services javascript. Put your favicon in the images folder under report manager (Program Files\Microsoft SQL Server\MSRS11.SQL2012\Reporting Services\ReportManager), then add the following to...

Replace can be made case insensitive by setting the CompareMethod to Text (it defaults to Binary which is case sensitive).

One thing that catches people out is that there are two...

If you are using Enterprise edition you can set the file name via a data driven subscription.

If you are on Standard you can use the @Timestamp placeholder in your filename...

The project configuration mode mainly determines the deployment options for your project so shouldn't really affect this.

I'm slightly unclear about the issue now - is it the data itself that...