Sql-server – SSRS Reports on WUXGA Displays

You mentioned that you have the table (technically clustered index) partitioned.

Does your query use the clustered key(s) as part of the search predicate? If not, you are going to get scans, as opposed to seeks, against the partitioned index.

Do you have any nonclustered indexes? Are they also partition-aligned?

Have you investigated your query execution plan to see what is happening under the hood of your poorly performing query?

Could you post your DDL, sample data, and your query, so we can better help you?

You could use a RS.exe script. This would allow you to create a script, a batch file and a set of .rdl files. Then you just call rs.exe with the script you created to upload the files to the report server.

You can find an example here

There is also a tool called rsscripter.exe created Jasper Smith, a SQL Server MVP. Apparently it is now included in finebuild and the zip is still archived. See this link for the original article.