Thanks for your sugestions Antonio, we've decided to use SSRS for the more MIS/BI type reporting but will come up with an alternative solution to using SSRS to create user-generated...

We are using SSRS as a mechanism for research teams to extract raw data from a variety of sources. The results are fed into 3rd party statistical analysis packages. I...

I'm not sure if I'm missing the point here, but have you considered placing a text box in the report with something along the lines of:

="End Date: "& Parameter!EndDate.Value

If your...

Right, what a dumb mistake.

Here's the solution:

The value field for the parameter that was misbehaving was the same for two of the labels (e.g. Parameters!ParameterA.Value = Parameters!ParameterB.Value). There must be...

Thanks for the response UncleJimBob, but I'm not passing anything in through the URL.

This is a straightforward Report Manager report.

Anybody else seen anything like this?

Result!

Thanks very much!

I've found two ways to transpose a list of values into a column. The first is by far the easiest, but what you use will be dependent on your individual...

Hi Michael,

Did you get anywhere with this?

I have some key users who are going to want to create their own reports, but then have these recreated with parameters instead of...

Remember your development ABC's:

Determine your requirements before you look to your solution. The best package may not do what you need.

How do you copy the Reports from the Test/UAT server where they've been deployed?

Great responses.

Thanks.

I have a similar issue. I've avoided this by telling users to export reports to CSV and then open in Excel. This strips out all of the Reporting Services formatting.

Sorry for the double post, just saw in another email that the wildcard for SSRS is * not %.

Not 100% on this, but try LIKE '%3%' rather than ='3'.

Good luck.

Using the properties for the report in question, you can set it to run using on schedule and use this cached report during the day.

The steps I think you need...

Try the ExecutionLog table on the ReportServer database.