in

jetlounge

the minty fresh blog that whitens your teeth!
All Tags » Reporting Services (RSS)

Browse by Tags

    Reporting Services Data Source Connection Examples

    December 20, 2007
    The following table lists examples of connections string for various data sources. Data Source Example Description SQL Server OLTP database data source="(local)";initial catalog=AdventureWorks Set data source type to SQL Server . Analysis Services database data source=localhost;initial catalog...

Passing Parameters to Reporting Services using an URL

December 18, 2007
When launching SSRS reports by URL, it is often necessary to include parameters. To do so, simply include the parameter name, an equal sign, followed by the parameter. So param=value for a report where CustomerID is 1 would look like: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2ReportFolder...

Common SSRS URL Commands

December 17, 2007
&rc:Parameters=Collapsed • This collapses the parameter bar but sends the parameters in the URL in the browser &rc:Parameters=true • This shows the parameter bar and is the default &rc:Parameters=false • This prevents the parameters from being passed in the browser and expanded &rc:toolbar...

Get Ranking of Groups in SSRS - Top X Ranking

December 16, 2007
Often you'd like to view a row number, or rank on a report in SQL Server Reporting Services. This is simple enough on a line item detail report with the RowNumber function. The reference to Nothing sets our scope. Just use: =RowNumber(Nothing) But now how about something a little more challenging...

Enforce Perspective Use in SQL Report Builder Models

December 15, 2007
Typically you'll lock down access to a SQL Reporting Services Model by creating a Perspective, either for security or to limit the amount of attributes available for a report. By default, the main model will be available in Report Builder with children listed for your available Perspectives. But...

Strange Refresh of Parameters in SQL Reporting Services

December 13, 2007
Input Parameters should refresh on your SSRS report if there are dependencies, for instance a list of valid Sales Reps might be dependent upon a selection of Sales Territory first. It makes sense that a change in Territory would trigger a refresh or postback in order to regenerate a list of valid values...

Custom Totals in Reporting Services Matrix Reports

December 11, 2007
I've got an article titled "Advanced Matrix Reporting" over at Simple-Talk that was just published. The biggest issue I find with the Matrix control in SSRS is the difficulty in doing complex aggregates other than SUM. Sometimes you'd like to do variances of year over year totals. Check...

Problems With SSRS Report Server Management After Changing the Server Name

December 10, 2007
In the rare case that you change the database server name after installing SQL Server Reporting Services 2005, you may have difficulty connecting to it with SQL Server Management Studio. We successfully connected to the SSRS Server in Visual Studio to deploy reports and components, and accessed the IIS...

Dealing with Paging Problems in SSRS

December 09, 2007
So by now you've probably noticed problems with paging and conditional visibility on grouping in your SQL Server Reporting Services (2000, 2005) reports. Once you make a table row conditionally visible, paging goes out the window. So a 50,000 row report will render in a single page. Try scrolling...

Reporting Services Report will not Export to Excel

December 08, 2007
You may receive the error "Stack Empty" when trying to export your SQL Reporting Services report to Excel, while all other export methods work. This issue that causes this may be a divide by zero formula somewhere in your report. The deeper issue is how SSRS handles 0's in the divisors...
Page 2 of 3 (21 items) < Previous 1 2 3 Next >


Powered by Community Server (Non-Commercial Edition), by Telligent Systems