THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSRS   (RSS)
Showing page 2 of 3 (30 total posts)
  • Working with Reporting Services Filters – Part 3: The TOP and BOTTOM Operators

    Thus far in this series, I have described using the IN operator and the LIKE operator. Today, I’ll continue the series by reviewing the TOP and BOTTOM operators. Today, I happened to be working on an example of using the TOP N operator and was not successful on my first try because the behavior is just a bit different than we find when using an ...
    Posted to Stacia Misner (Weblog) by smisner on January 7, 2011
  • Working with Reporting Services Filters – Part 2: The LIKE Operator

    In the first post of this series, I introduced the use of filters within the report rather than in the query. I included a list of filter operators, and then focused on the use of the IN operator. As I mentioned in the previous post, the use of some of these operators is not obvious, so I'm going to spend some time explaining them as well as ...
    Posted to Stacia Misner (Weblog) by smisner on December 30, 2010
  • Uninstalling Reporting Server 2008 on Windows Server 2008

    Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar to some more unfortunate developers and admins ...
    Posted to Piotr Rodak (Weblog) by on December 22, 2010
  • Working with Reporting Services Filters–Part 1

    There are two ways that you can filter data in Reporting Services. The first way, which usually provides a faster performance, is to use query parameters to apply a filter using the WHERE clause in a SQL statement. In that case, the structure of the filter depends upon the syntax recognized by the source database. Another way to filter data in ...
    Posted to Stacia Misner (Weblog) by smisner on December 21, 2010
  • Here Comes the FY11 Earmarks Database

    I'm really interested in politics (don't worry, I'm not going to start bashing politicians and hammering you with political rage).  The point is when the U.S. FY11 Omnibus Spending Bill (the bill to fund the U.S. Government for another year) was announced it piqued my interest.  I'm fascinated by ''earmarks'' (also ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on December 18, 2010
  • Build-time dependency resolving coming to Entity Framework. Now, how about those BI tools too?

    Three months ago I wrote a blog post entitled Some thoughts on Visual Studio database references and how they should be used for SQL Server BI where I shared some thoughts on a feature available to database developers in Visual Studio 2010 that I would love to see added to SQL Server Integration Services (SSIS), Analysis ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 7, 2010
  • SQL Server v.Next (Denali) : Launch point for BI resources

    Microsoft's new data platform vision for BI is called BISM - Business Intelligence Semantic Model.  While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can help you out with their input on the other aspects I rarely touch - Analysis Services (SSAS), Integration Services (SSIS), and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 30, 2010
  • Setting reporting database–what happens behind the scenes

    When you install reporting server, you have in general two options available – either you install the reporting server and configure its database at the same time, or install just reporting service and point it to an existing database later. We had recently opportunity to configure server to point to existing reporting database. We encountered a ...
    Posted to Piotr Rodak (Weblog) by on November 28, 2010
  • PASS Summit 2010: Epilogue

    Another PASS Summit has come and gone, and a good time was had by all. The song at the opening keynote sums up the experience quite nicely, ''Simply the Best.'' My favorite quote of the week comes from Andy Leonard (blog| twitter) who tweeted on November 9, ''#sqlpass is a family reunion. :{>'' Oddly enough, Andy is one of the few people that I ...
    Posted to Stacia Misner (Weblog) by smisner on November 15, 2010
  • Convert an integer seconds value into words in VBScript : Reporting Services

    Occasionally I stick random bits of code up on this blog because (a) I know I’ll need it again someday and (b) maybe it’ll be useful for someone else. This particular VBScript function called TimeInWords can be used in SQL Server Reporting Services to turn a numerical value representing number of seconds into a meaningful string. For ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 14, 2010
Privacy Statement