Who is online?  0 guests and 0 members
Home  »  search results

Search Results: Charts

36 results found
  • New features of SSRS 2008 R2 - Part 2 Report Part Gallery
    Report Part Gallery is a promising addition to the SSRS product in SQL Server 2008 R2 (currently using Nov CTP release). Imagine this: Jerry, a member of your team of developers, creates a series of cool data regions or charts that show key company metric
    Author: bretupdegraff bretupdegraff     Date: 12/4/2009     Section: Blog
  • SQL Server Reporting Services R2 - Publishing Report Parts
    SQL Server Reporting Services R2 – Publishing Report Parts SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish reports and data sources to the report server, but now they have the ability to publish report parts. You can p
    Author: PatrickLeBlanc PatrickLeBlanc     Date: 5/16/2010     Section: Blog
  • New Reporting Features in SSRS 2008: Part 1
    ( Visit my new technical blog at: http://busintmusings.blogspot.com! ) At my company, we recently started using SQL Server 2008 on one of our new projects, and I must say, it definitely has some great new features that are providing a lot of worth to our
    Author: britmccullar britmccullar     Date: 6/8/2010     Section: Blog
    tags : 2008, SQL, SSRS
  • Reporting / visualization solutions for SSAS
    What are some of the visualization tools / technologies that work well with SSAS and provide some or all of the following features: 1. Ability to Connec / Query OLAP cubes 2. SharePoint integration 3. Silverlight support 4. High quality / interactive char
    Author: atresso atresso     Date: 4/18/2011     Section: Forum
  • MS Cube Browser
    The Bids browser is only in BIDS. The browser is just for testing. Excel is much more powerful. You can create charts also.
    Author: MikeDavis MikeDavis     Date: 2/28/2010     Section: Forum
    tags : browser, cube, ssas
  • Series Data Label Formatting Charts in SSRS 2008
    I was creating a Pie Chart for a report in Reporting Services 2008 and wanted to show the Data Labels on the Chart. I also wanted to show the labels in the proper Currency format. The normal format menu would not let me change the formatting of the labels
    Author: MikeDavis MikeDavis     Date: 11/12/2009     Section: Blog
  • Dual Axis Chart w/Custom Colors - Line is now in the background (behind bar chart)?
    In SSRS 2008, I have a dual axis chart made up of a bar chart showing revenue and a line chart showing cost which compares only 2 years. I needed to use custom colors for both, so I used an Expression (iif statement) for the Color Property of both series.
    Author: SSRS08_DBA SSRS08_DBA     Date: 4/21/2010     Section: Forum
  • MDX and Parameters??
    So I have an SSAS cube that is pretty robust and rather complex. Now I want to build a dashboard on it. I want to fire a bunch of MDX queries at it and have it return data that I can populate into charts and graphs. And like most people in the "REAL WORLD
    Author: skerr skerr     Date: 5/22/2012     Section: Forum
  • PowerPivot?
    stirone, I am reviewing and starting to play around with PowerPivot. It is an Add-on to Excel 2010 and should not have any factor on changing the existing pivot table functionality. What it does is allows power users to pull data in from various sources w
    Author: bretupdegraff bretupdegraff     Date: 12/9/2009     Section: Forum
    tags : Excel
  • Getting Started With PerformancePoint 2010
    PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also has the ability to dig into the details. It makes it simple to create quick dashboards using KPIs, scorecards, charts and graphs. Perfo
    Author: DevinKnight DevinKnight     Date: 8/3/2010     Section: Blog
  • Time Intelligence Filters in PerformancePoint 2010
    The time intelligence filters provided with PerformancePoint 2010 gives developers an easy way to provide users with a method for specifying time periods using common English terms such as "Last 6 months", "Same Period Last Year", "Rolling 3 months", and
    Author: MMilligan MMilligan     Date: 3/16/2012     Section: Blog
  • SSRS – How to Get Rid of Those Dots
    Occasionally when you’re working with charts within SSRS you will run into an issue where you have numerous records returned for a given category/series. When this happens you will see an ellipsis (…) appear in the legend of your report, as s
    Author: ChrisAlbrektson ChrisAlbrektson     Date: 10/6/2011     Section: Blog
  • Calulated Fiedls on shared datasets in SSRS 2008 R2
    I posted the following connect item , please vote for it! https://connect.microsoft.com/SQLServer/feedback/details/585399/dataset-report-part-calculated-fields When creating a dataset, a new calculated field can be created using an expression, especially
    Author: MarkGStacey MarkGStacey     Date: 8/11/2010     Section: Blog
  • Making Charts Behave in SSRS with Un-Auto Settings
    I had a chart that wasn’t displaying the results that I had worked so hard in my stored procedure to get just like I wanted. The report was not showing each year on the bottom axis of the graph so the user couldn’t compare the results with the year by yea
    Author: timmurphy timmurphy     Date: 5/11/2010     Section: Blog
  • Almost to the Finish Line
    This week went by faster than I ever thought was possible. Tomorrow is the last day of this weeklong class! WOW!!! It's amazing to think about how much knowledge I've managed to gain in just a week. I feel very prepared and confident that I will be able t
    Author: MCao MCao     Date: 2/11/2010     Section: Blog
    tags : foundation
  • Rock Your Reports Series 1 of 3
    In this article, Sherri will show you how create a report that will utilize a your toolbox items from SSRS 2008 and SSRS 2008R2. Learn how to build the report with step by step instructions, including the query to pull the back the data. This is part 1 of
    Author: SMcDonald SMcDonald     Date: 3/11/2011     Section: Article
  • How to Make a Box Plot Chart in SQL Reporting Services 2008 SSRS
    In SQL server 2008 there are several new chart options. The Box Plot Chart or, Box and Whiskers Chart, or Candle Chart need a few calculations to make the chart work. The chart is made to show a series of numbers. Most box plot charts look like: This is a
    Author: MikeDavis MikeDavis     Date: 11/12/2009     Section: Blog
  • SSRS Sort Legend: It can be done!‏
    While working with a stacked bar chart in SQL Server Reporting Services (SSRS), I needed to change the sort order for the legend without changing the sort order of the stacked bar. Despite the fact I personally think stacked bar charts are a poor way to v
    Author: pkumar3 pkumar3     Date: 5/28/2012     Section: Blog
    tags : SSRS 2008 R2
  • Create a chart showing current and previous year
    SQL Server Reporting Services (SSRS) has several features that you can use to create visualizations of your data like charts, gauges, KPIs, and maps. These features are great for creating dashboards. The chart feature can be used to show multiple data poi
    Author: KathiKellenberger KathiKellenberger     Date: 3/10/2013     Section: Blog
  • Microsoft BI 101 for Beginners Part II
    Microsoft BI 101 PART II In my previous blog we talked high level about what Microsoft BI is and the main components involved within it. For this blog I wanted to touch on the 3 BI presentation tools, and some of the BI Development tools. Microsoft Applic
    Author: Dean.Brown Dean.Brown     Date: 1/18/2013     Section: Blog
  • PerformancePoint 2013 Dashboards: Applying Dynamic Security using CustomData and EffectiveUserName
    I recently had the great pleasure of solving a PerformancePoint 2013 puzzle and I thought I'd share how I did it to help others and as a reference for my fellow colleagues. Our team was trying to implement dynamic active directory security for Performance
    Author: MMilligan MMilligan     Date: 13 days ago     Section: Blog
  • KPI - ScoreCard - Dashboards
    Panorama is a Microsoft partner and worked closely with them in developing their NovaView set of tools. iDAshboards use of Flash makes their demo a bit flashier (no pun intended) but the front end capabilities of Novaview and Tableau are similar in that y
    Author: EGAN EGAN     Date: 12/18/2009     Section: Forum
    tags : Client Tools
  • New Reporting Features in SSRS 2008: Part 2
    In one of my previous posts, I mentioned that there are a lot of new features in SQL Server Reporting Services 2008 that can add a lot of value to reports and charts. Today, I'd like to discuss a few more of those in detail. One new feature is the ability
    Author: britmccullar britmccullar     Date: 6/22/2010     Section: Blog
  • Resizing Chart in Pivot Table
    Hi Everyone, I'm working in Excel 2007, sometimes the plot data section of charts doesn't auto-resize to avoid overlap from the legend. Is there a property in VBA that I can use to force it to auto-resize? Appreciate your help. Thanks, Pradeep
    Author: pkumar3 pkumar3     Date: 1/25/2011     Section: Blog
  • Dynamically sizing reports in SSRS
    We are putting SSRS charts into a website, and we'd like to have an 'expand' feature to make the chart bigger and allow users to see more detail. In essence, we'd like to be able to resize the report and make it bigger. Is there any way to dynamically do
    Author: britmccullar britmccullar     Date: 4/13/2010     Section: Forum