SqlServerKudos

SSRS

1
kudos

Kudos

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

published 1 day, 9 hours, 20 minutes ago posted by

sa 10 days, 11 hours, 16 minutes ago

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

The above error is presented on the instance which has got SQL Server 2008 R2 Reporting Services and used Windows Authentication to connect. The newest additon to SQL Server 2008 R2 architecture is Extended Protection authentication , which is a set of enhancements to Windows Authentication. A brief referral on Technet reveals that the main authentication enhancements that are part of extended protection are service binding and channel binding. Channel binding uses a channel binding token (CBT),...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: config file, extended protection, report viewer, Security, SQL Server, SQL Server 2008 R2, SSRS, tags, web service

1
kudos

Kudos

Creating reports that the end user can customize

published 69 days, 14 hours, 12 minutes ago posted by

sa 77 days, 14 hours, 37 minutes ago

Creating reports that the end user can customize

This is the 15th year in my career building serious business applications using various technologies (starting from DBase, going through Clipper, Foxpro, Visual Basic, Visual C++, and finally sticking to SQL Server) and one of the points I observed is Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #STA, Custom Reports, Izenda, reporting, SQL Tools, SQLServer, SSRS

1
kudos

Kudos

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

published 82 days, 15 hours, 12 minutes ago posted by

jacobsebastian 91 days, 16 hours, 58 minutes ago

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

beyondrelational.comSign in | Join | Help HomeBlogsForumsBIXMLTCSQL Tools Visit the new SQL Server Tools and Utilities section and see the products that can make your database administration and development lives easier! First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. Some Random ThoughtsHomeContactRSS for PostsRecent Blog PostsCalculat... (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: Custom Functions, reporting, SQL Server, SSRS

2
kudos

Kudos

Display Total on top of Stacked Chart - Some Random Thoughts

published 88 days, 15 hours, 38 minutes ago posted by

jacobsebastian 97 days, 21 hours, 6 minutes ago

Display Total on top of Stacked Chart - Some Random Thoughts

It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog readers sent me a mail asking how to display the total on top of a stacked chart in SSRS. The first time I read it, I was almost going to blurt - just enable some property to display subtotals. But the more I thought about it, the more elusive the property became and that is when I realized there is no such property. So for the benefit of all, I thought about posting the workaround that ... (more)

category: Reporting | clicked: 0 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

2
kudos

Kudos

Report selection in parameter toolbar - Some Random Thoughts

published 124 days, 18 hours, 17 minutes ago posted by

jacobsebastian 133 days, 15 hours, 17 minutes ago

Report selection in parameter toolbar - Some Random Thoughts

The MSDN forum has been the inspiration for most of my blogs, but in all those cases, I was sure that I could attain the end result and my blogs were usually a graphical step by step depiction of what needs to be done, so that I could post it as an answer to the question. But this blog is quite different, I almost wrote a no saying that it is not possible. And that was when I decided to give it a try before replying No :) (more)

category: Community | clicked: 1 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

1
kudos

Kudos

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

published 138 days, 19 hours, 23 minutes ago posted by

sa 142 days, 21 hours, 34 minutes ago

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services http://support.microsoft.com/kb/980142/en-US FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005 http://support.microsoft.com/kb/98... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, database mail, dbcc checkdb, enterprise edition, kba, Performance, SQL Server, SSAS, ssiss, SSRS, standard edition, x64

1
kudos

Kudos

SQLBI - Marco Russo : Permissions to display a report in SharePoint Services (SSRS integrated mode)

published 336 days, 12 hours, 46 minutes ago posted by

sa 345 days, 13 hours, 39 minutes ago

SQLBI - Marco Russo : Permissions to display a report in SharePoint Services (SSRS integrated mode)

This is the type of blog posts you write after you spent hours on a stupid issue and you want to remind what’s happened. And may be it will help someone else in the future. Scenario: you have a MOSS 2007 with SSRS 2008 in SharePoint integrated mode. You already installed the Reporting Services Addin for SharePoint 2007, everything is right, you create a report and you can see the report. But, another user, who has the rights to view the report (but that cannot change it) is not able to display the repo... (more)

category: Reporting | clicked: 2 | comment | | source: sqlblog.com

tags: MOSS, SSRS

1
kudos

Kudos

How to secure a new SQL Server Reporting Services farm

published 379 days, 14 hours ago posted by

sa 385 days, 5 hours, 34 minutes ago

How to secure a new SQL Server Reporting Services farm

Last month, I talked about the licensing model for the "Scale Out" Reporting Services model. It is expensive. Well, this month I am building a proof-of-concept for a customer. Luckily, we can use the Developer edition until we go into production. I feel much more comfortable dealing with technical issues versus licensing issues. Let's take a look... (more)

category: Security | clicked: 1 | comment | | source: www.networkworld.com

tags: Scale Out, Security, SSRS, Web Farm

1
kudos

Kudos

A Wrapper for Running SQL Server 2008 Reporting Services Anonymously

published 384 days, 12 hours ago posted by

sa 388 days, 6 hours, 54 minutes ago

A Wrapper for Running SQL Server 2008 Reporting Services Anonymously

With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency. It now relies directly on HTTP.SYS and handles web protocols independently. This is a good thing, in a lot of respects (see http://msdn.microsoft.com/en-us/library/bb630410.aspx). But, there is also a down-side for those of us who are used to utilizing the IIS framework for hosting SQL Server reports. For one t... (more)

category: Reporting | clicked: 4 | comment | | source: blogs.msdn.com

tags: SSRS

1
kudos

Kudos

Installing SQL Server Reporting Services 2008

published 399 days, 15 hours, 19 minutes ago posted by

sa 402 days, 5 hours, 24 minutes ago

Installing SQL Server Reporting Services 2008

In this webcast we are going to install SQL Server reporting services 2008. Watch the video and post your feed back in our discussion board (more)

category: Reporting | clicked: 3 | comment | | source: sql-articles.com

tags: Install, SSRS, Video

1
kudos

Kudos

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

published 408 days, 15 hours, 23 minutes ago posted by

sa 409 days, 8 hours, 49 minutes ago

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcaste... (more)

category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com

tags: BI, Excel, Excel 2007, Excel Services, Office, SharePoint, SQL 2008, SQL Server, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, SSAS, SSIS, SSRS

1
kudos

Kudos

A review: "Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

published 407 days, 15 hours, 18 minutes ago posted by

sa 410 days, 10 hours, 22 minutes ago

A review: "Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy A while back I got asked if I’d review this book, but as they could only get me a copy in PDF format, it’s taken a while to get to it. Whilst I like having electronic copies of books, I generally prefer to read them in paper form, and just have the electronic copy for reference. But anyway – this book calls itself “A step-by-step guide to getting the most of Microsoft SQL Server Reporting Services 2008”. At 536 pages, I rem... (more)

category: Reporting | clicked: 8 | comment | | source: msmvps.com

tags: Book Review, SSRS

1
kudos

Kudos

View Permissions for Reporting Services in SharePoint Integrated Mode

published 409 days, 15 hours, 15 minutes ago posted by

sa 410 days, 20 hours, 56 minutes ago

View Permissions for Reporting Services in SharePoint Integrated Mode

Setting up security for SSRS in SharePoint integrated mode can be a bit tricky, particularly if you want to set up some of your users to only be able to run reports, but not to be able to modify or change them. If you give the users the standard Contribute permission level in SharePoint, they have the ability to view and execute reports, but they can also delete existing reports or add new ones. If you assign only the Read permission level to the users, they won't even be able to see the reports in the d... (more)

category: Security | clicked: 4 | comment | | source: agilebi.com

tags: Security, SharePoint, SSRS

1
kudos

Kudos

Syntax highlighting bug in Reporting Services 2008 MDX Query Designer

published 409 days, 15 hours, 15 minutes ago posted by

sa 410 days, 21 hours, 44 minutes ago

Syntax highlighting bug in Reporting Services 2008 MDX Query Designer

Maybe you have noticed that in difference to Reporting Services 2005, the MDX Editor in Reporting Services 2008 has not the syntax highlighting feature enabled, for this reason it’s very painful to edit MDX queries relatively complicated using this editor. Here some screenshots showing the problem in Business Development Studio (BIDS) 2008 – where we design the Reporting Services reports, notice that the BIDS 2005 “Data” tab is not more a tab but a dialog window... (more)

category: Reporting | clicked: 3 | comment | | source: alan-koo.blogspot.com

tags: BIDS, MDX, SSRS

Welcome!

SSRS

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

Creating reports that the end user can customize

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

Display Total on top of Stacked Chart - Some Random Thoughts

Report selection in parameter toolbar - Some Random Thoughts

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

SQLBI - Marco Russo : Permissions to display a report in SharePoint Services (SSRS integrated mode)

How to secure a new SQL Server Reporting Services farm

A Wrapper for Running SQL Server 2008 Reporting Services Anonymously

Installing SQL Server Reporting Services 2008

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

A review: "Learning SQL Server 2008 Reporting Services” by Jayaram Krishnaswamy

View Permissions for Reporting Services in SharePoint Integrated Mode

Syntax highlighting bug in Reporting Services 2008 MDX Query Designer

Open ID Login

Standard Login

Forgot Password?

Sign up