The page break will not get you around the problem of max rows in excel. If you could maybe post some screen shots we might be able to offer...

Also watch out for any default values or calculated values in the parameters. Those can cause problems recalculating each time one of the other parameters is clicked

dknaus,

I like your method better....

Thanks!

What I've done in the past is to simply make a copy of the report. One version is for subscriptions and the other to run manually. You can...

I found the article about the ability to backup snapshots using a third party tool (ttp://technet.microsoft.com/en-us/library/ms189548.aspx) which led me to choose the wrong answer.....Oh well...the point is to think about...

The graphic used for the chart probably has some permissions problems from within the web app....Can you get a non graphical report to work? Are the report server website...

Jack is right....something is too big within the report...either the size of the overall spreadsheet or maybe a super large number within one of the cells....

I'm running ie7 with no ill effects...my security settings are at the default level....

Go to the RSReportServer.config file and find the "Render" section...check to see if the Extension node is set to Visible="false"....if so change it to "true"

A couple of thoughts

1) Here is the sql equivalent to the Excel Rank function:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/2d96f6d2-5db7-4b3c-a63e-213c58e4af55.htm

2) if that doesn't work try placing the excel formula within the ssrs report including the =...

The authentication has to do with what type of environment you are deploying to....if it's within a windows domain inside a firewall or to the external world....Best case is that...

This doesn't answer your specific question, but this functionality is available in SQL Server Reporting Services. After creating the report based on the SQL code you already have, SSRS...

Are you creating a new ssrs environment or trying to take over an existing SSRS setup?

If new:

Install the SSRS package from scratch on the webserver you are deploying...

SSRS 2005 has an ALL option built in. Without that, consider creating a table with your states in it. Also include and additional entry in the table for...

Good bad or ugly, I think the reason for the sql 2008 version was to be in sync with the server operating system features coming out Windows Server 2008 making...