There is no way to access the Hidden property of another report item.

You can usually create an expression in the second textbox that evaluates the same as...

It's the same issue, you are trying to compare a string to an array, which will not work.

If you are certain (as you can be) "No Audits selected" will be...

Hi David, this is to do with ACL. Try right clicking the browser icon and choose running it as Administrator and then navigate to the report manager.

No, you need to filter the dataset by the parameter in Filters. It would look like:

Expression = Fields!Type.Value (or just select the [Type] field in...

Hi Kat,

The native report manager does not store a version history of the report definitions. I think the Sharepoint versioning is all based on Sharepoint's internal document control.

Depending on...

The underlying structure of users, policies and roles is pretty complicated and everything is referenced via GUIDs. I've never really changed it by SQL and that's not supported by...

A multivalue parameter returns an array type, so it can't be directly compared with a string. You need to use an array method to find the value.

Try:

=Array.IndexOf(Parameters!audits.Value, "Member_Not_available_at_Time_of_Service") > -1

The...

It depends on what you want really, but you shouldn't need two datasets.

I think you need to remove the parameter from the query in the dataset, because that is filtering...

Sounds like you're most of the way there. What you could to do is to use the parameter in a Filter on the chart object rather then against the...

Excel doesn't really work like that, there isn't any schema for the data in the spreadsheet, it works on cell references so the worksheet headers will always be A-Z etc.

Some...

So you want to export as an Excel Table (https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c)?

If that is the case I do not think it is possible. You can use a report as a data...

Hi,

If you export to Excel the tablix heading will export too. CSV exports will only export with the Textbox Name properties as headings. Do you have a scenario...

Whatever, just be aware if you still have no transactions at all in the GiveTransactions table you won't get a result back as you are inner joining on it. ...

I'd suggest you break the report into a header report and a subreport for the transactions.

You can still have the date parameters etc in the header report, you just pass...

You'll need to show or explain how you are filtering the dataset or dataset results with the 3 parameters. It sounds like setting any of the parameters values...