Hi, the only work around I can think of is to make sure that the report properties layout is set to the portrait (w 8.5in x h 11.27in) or landscape...

Hi, I assume you are referring to a chart?, if so then you can dynamically change the axis by either creating min and max fields in your dataset and then...

Basically you will need to create a custom table which contains the dates you want the report to run.

Then you will need to create a simple sql script which will...

Hi,

My approach would be to filter out the group data within the sql script and then your normal total sum expression will be correct as you have filtered out...

Hi,

You need to check to see if the standard subscription schedule fits your requirements.

If this does not then it is probably best to do a data driven subscription with...

Hi,

It looks like you need to do a left join rather than an equal join.

This will return all the data from the first table (derived query) and then only...

Hi,

I think there are 2 ways of dealing with this. You can either create a separate query and add this to a separate dataset and then show the tax...

Hi,

I think it is best practice to create a test dds scubscription before creating a live version. That way any mistakes that happen can be rectified before the subscription...

Hi, just a suggestion you could call it REPS short for Reporting Server, as long as the name has a meaning to it and is easy to remember.

🙂

Hi, this works well in 2005 and is a fine distinction between data driven subscriptions as they are time based wheras with this script you can fire your reports based...

Hi, is it not possible to amend you data set so that it groups the data in the format you want it?

Hi there,

Have you tried changing the time out for your report.

In report manager under the properties for the report under execution, change the report execution timeout from default to...

Hi,

I don't think it is possible to dynamically change the report name for an email schedule.

The only possible workaround I can think of is to schedule the report to...

Hi, I think you might want to elaborate.

In the data tab of the chart properties you can specify the dataset and it looks like it is only one.

Hi,

This does not work in reporting services 2005. The export only renames the sheet when the report is a single page.

We have basically hidden (changed the font colour...