Viewing 15 posts - 16 through 30 (of 119 total)
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...
November 7, 2007 at 2:07 am
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...
November 3, 2007 at 3:53 pm
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...
November 2, 2007 at 6:43 pm
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...
October 31, 2007 at 2:22 pm
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...
October 31, 2007 at 2:18 pm
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.
October 30, 2007 at 8:11 pm
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....
October 30, 2007 at 2:56 am
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...
October 30, 2007 at 2:44 am
In the Format property for the textbox that displays the number, use N0 (N - zero). That displays a number with thousands separator and...
October 30, 2007 at 2:40 am
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...
October 30, 2007 at 2:30 am
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...
October 29, 2007 at 10:15 am
Scott B (10/26/2007)
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...
October 27, 2007 at 10:34 pm
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...
October 13, 2007 at 7:09 pm
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...
October 3, 2007 at 8:15 pm
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_exReturns table information about the tables...
Returns table information about the tables...
July 7, 2007 at 11:23 pm