The following method will create a hyperlink for a text box that goes to a specified report, passing in particular parameters.

1) On the textbox, right-click, select properties, and go...

If you're up for using 3rd-party products, OfficeWriter from http://www.softartisans.com provides much more control over Excel output. Strictly spreaking, it uses Excel as the development environment for...

Steve,

You need to indicate an explicit sort for the matrix column headers. Otherwise, in my experience they simply are displayed in the order the data is returned from the...

I should have mentioned another possibility besides the ReportViewer control.

SSRS is also nicely addressable via URLs, so you could also simply build a page that collects parameters and passes...

One possibility is to use SSRS as a Report Server, and then use your own custom ASP.NET page hosting the ASP.NET 2.0 Report Viewer control as the UI. This...

I'm not quite sure what your objectives are.

Are you trying to create a web page that displays a report? If so, the ASP.NET ReportViewer control is an option.

Could you...

R. Black,

Managing Excel tab names is a common question, but until recently, the answer has always been that SSRS out-of-the-box does not provide this level of control for multi-page reports....

I've done this with a data-driven subscription in SSRS Enterprise editions. If the data-driven query returns zero rows, no emails / file drops will go out.

Are you using...

In the Format property for the textbox that displays the number, use N0 (N - zero). That displays a number with thousands separator and...

Jeffrey,

I do this by creating a datetime parameter, leaving "Available values" blank, and setting a Non-queries default value to "=Today" (without the quotes). This is in SSRS...

Yes, the solution I provided does entail a change in the report itself to set the dynamic default dates.

If this is not possible, an alternative would be to build your...

Scott B (10/26/2007)

---

Hi all,

I am setting up subscriptions for a number of reports I've created, and I've successfully managed to have them write to the fileshare folder. Some of the...

There are two items you need to look at:

1. Reporting Services needs to properly authenticate web user. How you maintain this depends on how authentication was handled originally...

Chip,

Don't know if you got this working yet. If not, a few questions:

1. Is your web app with ReportViewer control on a different server than SSRS?

2. What is...

Noelson,

Check out sp_table_ex in Books Online.  It will do exactly what you are trying to accomplish, and works for non-SQL Linked servers as well:

sp_tables_ex

Returns table information about the tables...