SqlServerKudos

SSRS

1
kudos

Kudos

Scottish Area SQL Server User Group: Reporting Services and Sharepoint Integration and BI features in Denali #sql #usergroup #sqlfaq

published 174 days, 9 hours, 44 minutes ago posted by

sa 177 days, 8 hours, 43 minutes ago

Scottish Area SQL Server User Group: Reporting Services and Sharepoint Integration and BI features in Denali #sql #usergroup #sqlfaq

Here is another usergroup event scheduled for Scottish Area SQL Server usergroup, this time its all high-up and concentration on BI specific. The topics are: Reporting Services and SharePoint Integration & BI features in Denali The SSRS & Sharepoint INtegration is presented by Rob Carrol who is Sr. Premier Field Engineer in Microsoft, so you will get insight of SSRS integration with Sharepoint within your data platform. it will be a highlight for you to think about how easily you can integrate...(read more) (more)

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

tags: Best Practices, BI, mvp, sassug, SharePoint, SQL Server, SQL Server Reporting Services, SSRS, usergroup

1
kudos

Kudos

SQL Server BI Performance series: managing CUBE performance issues

published 226 days, 13 hours, 31 minutes ago posted by

sa 235 days, 14 hours, 11 minutes ago

SQL Server BI Performance series: managing CUBE performance issues

What kind of performance issues you will need to face when you are setting/managing a Business Intelligence environment involving SQL Server technologies. I see this more as a practical question than to answer about the technology. When we talk about OLTP based applications then high-speed transactions, data concurrency, access and performance is a key factor. Also the volatile changes within data require constant maintenance to keep up the performance. But it may not be entirely related to an OLAP...(re... (more)

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

tags: benchmarking, Best Practices, business intelligence, DBA, ebook, parallel processing, Query, SQL Server, SSAS, SSIS, SSRS

1
kudos

Kudos

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

published 514 days, 9 hours, 41 minutes ago posted by

sa 523 days, 11 hours, 37 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 582 days, 14 hours, 33 minutes ago posted by

sa 590 days, 14 hours, 58 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 595 days, 15 hours, 33 minutes ago posted by

jacobsebastian 604 days, 17 hours, 19 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 601 days, 15 hours, 59 minutes ago posted by

jacobsebastian 610 days, 21 hours, 27 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 637 days, 18 hours, 38 minutes ago posted by

jacobsebastian 646 days, 15 hours, 38 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 651 days, 19 hours, 44 minutes ago posted by

sa 655 days, 21 hours, 55 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 849 days, 13 hours, 7 minutes ago posted by

sa 858 days, 14 hours 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 892 days, 14 hours, 21 minutes ago posted by

sa 898 days, 5 hours, 55 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 897 days, 12 hours, 21 minutes ago posted by

sa 901 days, 7 hours, 15 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: 9 | comment | | source: blogs.msdn.com

tags: SSRS

1
kudos

Kudos

Installing SQL Server Reporting Services 2008

published 912 days, 15 hours, 40 minutes ago posted by

sa 915 days, 5 hours, 45 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 921 days, 15 hours, 44 minutes ago posted by

sa 922 days, 9 hours, 10 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 920 days, 15 hours, 39 minutes ago posted by

sa 923 days, 10 hours, 43 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: 9 | comment | | source: msmvps.com

tags: Book Review, SSRS

1
kudos

Kudos

View Permissions for Reporting Services in SharePoint Integrated Mode

published 922 days, 15 hours, 36 minutes ago posted by

sa 923 days, 21 hours, 17 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: 5 | comment | | source: agilebi.com

tags: Security, SharePoint, SSRS

1
kudos

Kudos

Syntax highlighting bug in Reporting Services 2008 MDX Query Designer

published 922 days, 15 hours, 36 minutes ago posted by

sa 923 days, 22 hours, 5 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

Scottish Area SQL Server User Group: Reporting Services and Sharepoint Integration and BI features in Denali #sql #usergroup #sqlfaq

SQL Server BI Performance series: managing CUBE performance issues

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