Hi Steve,

Surely this can be achieved just by using a parent group over the details?

Right click Details in the row groups and Add Parent Group with a header row. ...

Hi,

You can just group on the Medication if it's enough and then use the First() summary for the other values in you header / footer rows.

Spiff

Hi Damian,

Cell width is not adjustable dynamically or by an expression.

My main suggestion would be to landscape the page and use the ruler to ensure the cells are...

Are you sure it's not as simple as you've turned off compatibility mode? SSRS (at least up to 2012) doesn't work well with anything above IE7 without using compatibility...

It stores it as a text value so wants 6 digits, #000000 will work for black.

After that I would suggest just using the colour picker and choosing different shades of...

You cannot change the opacity of the font colour. You can achieve transparency by setting the colour to Nothing but there are no ways of setting a level between...

Hi,

To divide output over different sheets you use the PageBreak property. To label the Sheets you can use the PageName property.

If the data and summary are different tablixes change...

Hi Kevin,

1. You should give the Users the Report Manager URL. It will enable them to use the report manager and associated features (e.g. subscriptions). The Report Server...

Hi Anthony,

You are using SSL. Try using the reportserver URL for the servername instead.

e.g. https://AAPPOLIS-M/ReportServer

or https://Customers/ReportServer

Are you using Basic Auth?

The parameters are just hidden on the Report Manager UI. There is a little arrow to expand the parameters again.

Between the toolbar and the top navigation (with the breadcrumbs)...

Hi,

I think this only happens when you are in Visual Studio.

Try deploying the report and running it on the report server. you should be able to change the values...

Hi,

There sure is. Multivalue parameters are arrays so the best way to do this is with IndexOf. e.g.

=Array.IndexOf(Parameters!Param1.Value, "myvalue") > -1

Array.IndexOf takes an array (your parameter) as...

Alan, if you use the pre /post 2012 last day of month calculations you posted you get different answers.

This is the problem I have with EOMONTH() is that it returns...

The curly braces are added by SSIS when you are converting from a Uniquidentifier to a string.

There's two ways to get around it really. Either convert your guid in...

You have an OR condition. It's saying return rows that match OR where CONSIGNEE_DUNS is null.

(CONSIGNEE_DUNS LIKE '%' + @conduns + '%') OR (CONSIGNEE_DUNS IS NULL) OR (CONSIGNEE_DUNS =...