Zebra BI logo

How to Customize Gantt Chart in SQL Server Reporting Services (SSRS)

A gantt chart with customizable elements

Gantt charts are a critical tool for project management that help project managers and team members visualize project timelines, dependencies, and progress. By creating a Gantt chart in SQL Server Reporting Services (SSRS), you can quickly customize and display your project data in a meaningful, easy-to-understand format. This article will provide a step-by-step guide on how to customize Gantt charts in SSRS as well as best practices for achieving optimal results.

Table of Contents

Understanding Gantt Charts and their Importance in Project Management

A Gantt chart is a type of bar chart that displays a project schedule. It shows the start and end dates of each task in the project, as well as the dependencies between tasks. Gantt charts are essential tools for project managers and team members because they provide a visual representation of the project timeline. By seeing the project at a glance, everyone can better understand the project’s progress, status, and upcoming tasks. Additionally, Gantt charts show critical paths, identifying the sequence of tasks with the highest level of risk for the project’s timely completion.

Another benefit of Gantt charts is that they allow project managers to allocate resources effectively. By seeing the timeline of each task, managers can determine which resources are needed at specific times and ensure that they are available. This helps to prevent delays and ensures that the project stays on track.

Furthermore, Gantt charts can be used to communicate project progress to stakeholders. By sharing the chart with clients or executives, they can see the project’s status and understand how it is progressing. This can help to build trust and confidence in the project team and ensure that everyone is on the same page regarding the project’s goals and timeline.

Introduction to SQL Server Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) is a versatile reporting platform that provides robust capabilities for building custom reports, including Gantt charts. Using SSRS, you can connect to data sources, create reports, and customize report layouts and formatting. SSRS allows you to import data from a variety of sources, including SQL Server, Oracle, Access, and Excel. With SSRS, you can display data in numerous formats, including tables, charts, and maps. Within SSRS, you can configure interactive features, such as drill-through reports and parameter controls.

One of the key benefits of SSRS is its ability to schedule and automate report generation. You can set up a schedule to automatically generate and distribute reports to specific users or groups, reducing the need for manual report generation and distribution. Additionally, SSRS provides a range of security features, allowing you to control access to reports and data sources, ensuring that sensitive information is only accessible to authorized users.

Installing and Configuring SQL Server Reporting Services (SSRS) for Customization

Before you can begin customizing your Gantt chart in SSRS, you must install and configure SSRS. The process for installing and configuring SSRS varies depending on your setup. To get started, first determine which version of SSRS you want to install. SSRS is available both on-premises and in the cloud. Next, download the appropriate version of SSRS and follow the instructions to install it on your server. Once installed, configure the SSRS farm by setting up the necessary user accounts and security settings.

After you have installed and configured SSRS, you can begin creating your Gantt chart. To do this, you will need to create a new report in SSRS and add a Gantt chart to the report. You can customize the Gantt chart by adjusting the data source, formatting, and layout. You can also add additional features, such as tooltips and drill-down functionality.

It is important to note that customizing a Gantt chart in SSRS requires a strong understanding of SQL and SSRS. If you are not familiar with these technologies, it may be helpful to seek assistance from a developer or consultant who specializes in SSRS customization.

Creating a Basic Gantt Chart in SSRS

To create a basic Gantt chart in SSRS, first open Visual Studio and create a new report project. Connect to your data source using the Report Data window. Drag and drop a “Chart” control onto the report’s design surface. In the Chart Data window, select “Gantt Chart” as the chart type. Set the Gantt chart’s data fields and customize the chart’s appearance to your liking. Run the report to see the Gantt chart in action.

It is important to note that Gantt charts are commonly used in project management to visualize project timelines and progress. By using SSRS to create a Gantt chart, you can easily track and communicate project status to stakeholders.

Additionally, SSRS allows you to add interactivity to your Gantt chart by using drill-down functionality. This means that users can click on specific bars in the chart to see more detailed information about that particular task or project milestone.

Adding Data to the Gantt Chart in SSRS

Once you have created a basic Gantt chart, you can add project data to it. In the Chart Data window, select the data source that contains your project data and drag and drop it onto the Gantt chart’s data fields. The Gantt chart will refresh to display your project data. You can also customize the data labels and values that appear on the Gantt chart by editing the chart’s properties and data series.

It is important to note that when adding data to the Gantt chart, you should ensure that the data is accurate and up-to-date. Any changes made to the project data will be reflected in the Gantt chart, so it is crucial to regularly update the data to ensure that the chart accurately represents the project’s progress. Additionally, you can use the Gantt chart to identify any potential delays or issues in the project timeline, allowing you to take corrective action before they become major problems.

Formatting the Gantt Chart in SSRS

You can customize the appearance of the Gantt chart in SSRS in several ways. For example, you can add a legend, adjust the chart’s axis scales, and change the chart’s theme. In the Properties window, locate the chart’s “Style” properties and modify them to fit your design preferences. To add a legend, go to the “Legends” tab and configure it. To adjust the axis scales, go to the “Axes” tab and configure the horizontal and vertical axis properties. To change the chart’s theme, go to the “Appearance” tab and select a new theme.

Another way to customize the Gantt chart in SSRS is to add data labels. Data labels can provide additional information about the data points on the chart, such as the start and end dates of a task. To add data labels, go to the “Data” tab and select the “Data Labels” option. From there, you can choose which data points to label and customize the appearance of the labels.

In addition to customizing the appearance of the Gantt chart, you can also add interactivity to the chart. For example, you can add drill-down functionality to allow users to view more detailed information about a specific task or group of tasks. To add drill-down functionality, go to the “Interactive” tab and select the “Drilldown” option. From there, you can configure the drill-down behavior and specify which data points should trigger the drill-down action.

Customizing the Color Scheme of the Gantt Chart in SSRS

You can customize the color scheme of the Gantt chart in SSRS to highlight specific data and make the chart easier to read. For example, you can use different colors to identify the different project phases, team members, or task statuses. To do this, go to the chart’s “Data” tab and select the data series you want to modify. Choose a color from the color palette to assign it to the data series. You can also apply conditional formatting to the data series to change the color of the Gantt bar based on specific criteria.

Adjusting the Scale of the Gantt Chart in SSRS

If your project timeline is very long or very short, you may need to adjust the scale of the Gantt chart in SSRS to make it more readable. You can zoom in or out on the Gantt chart by adjusting the chart’s zoom level. To do this, open the chart’s “Properties” window, go to the “Appearance” tab, and modify the “Zoom” property. You can also adjust the chart’s start and end dates by modifying the “Minimum” and “Maximum” axis scale properties.

Adding Labels and Annotations to the Gantt Chart in SSRS

You can add labels and annotations to the Gantt chart in SSRS to provide additional information about tasks or milestones. To add a label or annotation, select the Gantt bar you want to annotate and right-click it. Choose “Add Data Label” or “Add Annotation” from the context menu. In the “Data Label” or “Annotation” properties, you can specify the content, position, and format of the label or annotation.

Advanced Customization Techniques for Gantt Chart in SSRS

There are numerous advanced customization techniques for Gantt charts in SSRS, including adding more complex data, displaying multiple charts in one report, and using custom code to modify the chart’s behavior. Custom code can be used to add functionality not included in the chart’s built-in properties and functions. However, advanced customization techniques require a higher level of expertise and knowledge of SSRS and Gantt charts.

Troubleshooting Common Issues while Customizing a Gantt Chart in SSRS

Common issues when customizing Gantt charts in SSRS include data formatting issues, axis scaling problems, and issues with chart labels. If you encounter issues when customizing your Gantt chart in SSRS, the first step is to check that your data source is properly formatted and that the chart’s properties are correctly configured. Additionally, you can use the SSRS debugger to troubleshoot and test your report.

Best Practices for Creating a Customized Gantt Chart in SSRS

When creating a customized Gantt chart in SSRS, there are several best practices to keep in mind. First, consider the purpose and audience for the report and design the chart accordingly. Use colors and labels to highlight important data and information. Keep the chart simple and easy to read by avoiding cluttered or confusing displays. Finally, test and validate the Gantt chart to ensure that it correctly represents the project data and meets the report’s objectives.

Conclusion and Future Outlook for Customizing Gantt Charts using SQL Server Reporting Services (SSRS)

In conclusion, Gantt charts are essential tools for project management, and customizing them in SQL Server Reporting Services can help streamline your project management processes. With SSRS, you can create customized reports that fit your organization’s needs and provide insightful, data-driven analysis. As SSRS continues to evolve and update, we can expect to see more innovative features and capabilities added to Gantt chart customization in the future.

By humans, for humans - Best rated articles:

Excel report templates: build better reports faster, top 9 power bi dashboard examples, excel waterfall charts: how to create one that doesn't suck, beyond ai - discover our handpicked bi resources.

Explore Zebra BI's expert-selected resources combining technology and insight for practical, in-depth BI strategies.

sql server reporting services gantt chart

We’ve been experimenting with AI-generated content, and sometimes it gets carried away. Give us a feedback and help us learn and improve! 🤍

Note: This is an experimental AI-generated article. Your help is welcome. Share your feedback with us and help us improve.

sql server reporting services gantt chart

  • [email protected]

CloudFronts - Microsoft Dynamics 365 | CRM | ERP | Power BI | Azure

How to create a Gantt Chart or Progress bar inside a Table in SSRS

  • Dynamics 365
  • Dynamics CRM

In this article, we will create a Gantt Chart or Progress bar inside a table in SSRS .

In SQL Server Reporting Service does not allow a report programmer to modify a “width” property at run time. The challenging part of this task is how to create a scale and how to create a progress bar that spans a start date and end date. But SSRS have a range bar chart that will help you to make a Gantt chart or progress bar. And display diamond shape if start date and end date is same.

For creating Gantt chart, we need a Data source, a Dataset, a Table and a Range Bar chart.

Step 1: First create a new data source.

sql server reporting services gantt chart

Step 2:  Before creating a data set, we need to write a Fetch XML query that created the data we’re going to work with.

Fetch XML Query:

<fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”false”>

<entity name=”milestone”>

<attribute name=”createdon” />

<attribute name=”item” />

<attribute name=”projectid” />

<attribute name=”contractorid” />

<attribute name=”packageid” />

<attribute name=”startdatemilestone” />

<attribute name=”remarks” />

<attribute name=”finishdatemilestone” />

<attribute name=”startdateforecast” />

<attribute name=”finishdateforecast” />

<attribute name=”startdateactual” />

<attribute name=”finishdateactual” />

<attribute name=”progress” />

<attribute name=”status” />

<attribute name=”durationdays” />

<attribute name=”sequencenumber” />

<attribute name=”milestoneid” />

<order attribute=”item” descending=”false” />

<filter type=”and”>

<condition attribute=”projectid” operator=”eq” uiname=”ABC” uitype=”pmtracker” value=”{86AF05D9-6962-E911-A834-000D3A07F3D7}” />

</filter>

</entity>

</fetch>

This gives us a result set like this :

Step 3: Now we create a Data set from this query:

sql server reporting services gantt chart

If start date and end date is same then need to display diamond shape, for that we have to add three calculated field.

sql server reporting services gantt chart

Need to find number of days between two dates.

DayDiff_MileStone=DateDiff(“d”,Fields!startdatemilestoneValue.Value,Fields!finishdatemilestoneValue.Value)

we are going to set the following properties:

We’re going to create a table within the report that has a column for each of the columns in the data set, plus a column for a graph.

We just have to bind the Table to the data set “MilstoneData”

Then drag the columns of the data set to the columns of the table.

sql server reporting services gantt chart

Step 4 : Build the Gantt Chart

SSRS have the Range Bar Chart option.

sql server reporting services gantt chart

Just drop the chart onto a blank area of the report. We’ll fit it into table later.

sql server reporting services gantt chart

Now we are going to take fewer part of the chart. We’re throw away of:

  • The chart title
  • The vertical Axis title
  • The vertical axis
  • The horizontal axis title

When we’re done, the chart should look like this:

sql server reporting services gantt chart

Let’s start setting up the chart.

The first thing we need to do is set the Minimums, Maximums, Intervals and Interval Types.

The client wants minimum date must be from “startdatemilestone” date and maximum date should be “finishdateforecast” date.

On the Horizontal Axis, we are going to set the following properties:

Also going to set the format the of items along the Horizontal Axis to MM-yyyy

sql server reporting services gantt chart

Go to chart series properties, set Marker properties.

sql server reporting services gantt chart

Let’s get a preview of the report and see how we’re doing.

sql server reporting services gantt chart

It’s correct, but it doesn’t provide the milestone data. Now cut the chart and paste it into the details row of the Table, in the right most column. Now we’re going to run a preview.

We receive the error “The chart has a detail member with inner members. Detail members can only contain static members.

What this means is that chart cannot live in a detail row.

We’re going to create a Group that contains only a single Item.

After selecting the Table, at the bottom left of the screen, we find “Row Groups”,

sql server reporting services gantt chart

Just click on preview shows us:

sql server reporting services gantt chart

Nice-looking but do we really need a timeline on every now?

Now we are going to need a timeline. So, let’s take a copy of the Chart and put it right next to the header “Duration”

Now we can hide the Axis Labels on the chart in the footer. We can also change the Axis line style to none.

Click on preview

sql server reporting services gantt chart

Wow! Hope this helps you!

Check out my other blog here https://www.cloudfronts.com/performing-update-operation-in-microsoft-dynamics-nav-through-integration-in-scribe-online/

Related posts:

Share story :.

How to Attach Word Template to Notes of record Automatically

Entity Relationship Behavior in D365 CRM

SEARCH BLOGS :

Follow cloudfronts blog :.

Enter your email address to follow this blog and receive notifications of new posts by email.

  • Azure and Office 365 (103)
  • Azure Databricks (3)
  • Azure DevOps Services (4)
  • Azure Function (9)
  • Azure Synapse Analytics (3)
  • Blog (1,165)
  • Business Process Flow (2)
  • Cloud flows (20)
  • CloudFlows (9)
  • Customer Success (72)
  • D365 Business Central (240)
  • D365 Commerce (5)
  • D365 Customer Service (59)
  • D365 Field Service (21)
  • D365 Finance (1)
  • D365 Finance and Operations (156)
  • D365 General (298)
  • D365 Project Service Automation (55)
  • D365 Retail (60)
  • D365 Sales (51)
  • D365 SCM (1)
  • Dataverse (3)
  • Dot Net (1)
  • Dynamics 365 (193)
  • Dynamics 365, Business (9)
  • Dynamics AX (40)
  • Dynamics CRM (122)
  • Dynamics NAV (13)
  • JavaScript (5)
  • Logic App (18)
  • LS Central (13)
  • Model-Driven App (3)
  • MS Teams (5)
  • Power Automate (53)
  • Power BI (188)
  • Power Plattform (12)
  • Power Virtual Agent (1)
  • PowerApps (47)
  • PowerApps Portal (2)
  • Press Releases (36)
  • Project Management (2)
  • Project Service Automation (7)
  • Salesforce (1)
  • SharePoint (4)
  • SQL Server (6)

RECENT UPDATES

  • Restoring an Environment in Business Central.
  • Optimizing Project Impact: Continuous Monitoring of Client System Utilization for Enhanced Value Deliver using Business Central
  • US-based financial services company partners with CloudFronts for 3-year Managed Services Agreement (MSA) Renewal 
  • Salesforce Integration using Azure Integration Services
  • Quarantine Management Process in Dynamics 365 FnO Supply Chain Management

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

Use Paginated Reports to Create a Gantt Chart

A paginated report has variable height that can be scrolled vertically on the screen or split across multiple pages when printed or saved to different output formats. Power BI has become the go-to business tool for modern reporting, but sometimes we need information displayed in the more traditional paginated format. A colleague asked if a Gantt chart could be created, and I thought this was an excellent example of where Paginated Reports & SSRS were an ideal choice for the purpose.

A Gantt chart is a running list of activities with the duration for each displayed as a horizontal bar depicting the beginning and ending day along a horizontal scale. The challenge is that this is not a standard chart type in either Power BI or SSRS/Paginated Reports. Furthermore, project planners may prefer to see activities as rows in the format of a printed page, as you can see in this example:

sql server reporting services gantt chart

Let me just get this part out of the way before we proceed. I’ve been using SQL Server Reporting Services (now called “Paginated Reports” in the Power BI service) for most of my 20+ year career in BI and data analytics. It is a very flexible tool that can, at times, be tedious and time-consuming for a report developer to use beyond its basic features. I’ve used it, and seen it used in very creative ways, but some things take patience to work through the trial-and-error design process. Once you know what you are doing, it can be a wonderfully powerful and flexible design tool.

Source Data

The source for this report is a list of project tasks, each having a start date and an end date. For demonstration purposes, I used the Enter Data feature to populate a portable dataset, but you can use a database or any other supported data source. Since the data in my sample is stored as text, I do need to perform some extra data type conversion in some of the expressions. In some cases, this won’t be necessary when using strongly-type data sources like SQL Server.

sql server reporting services gantt chart

A Gauge in a Table

Most advanced Paginated reports are built by using a data region, like a table, matrix or rectangle; to repeat other report items in data groups. To achieve the Gantt chart effect, I use a table data region to repeat a linear gauge for each row in the dataset. The table is sorted by the Order column. You could also use the DateFrom column for sorting (again, my data is stored as text which doesn’t naturally sort in date order).

I’ve added two linear gauges to the table: one in the details row of the table with the numeric scale hidden, and one in the header with the range (or bar) removed, and the scale displayed. This image shows the report in design view after the following steps have been completed. You can look though the sample RDL file I’ve provided, which includes a completed report based on the steps outlined below.

Make sure you have the Properties pane displayed in report Builder by checking the Properties box in the View ribbon.

sql server reporting services gantt chart

To set the “window” of dates shown in the chart, I’ve created two date-type parameters named ChartRangeStart and ChartRangeEnd , and assigned default values that include the records in the source data, 3 months apart.

The gauge visual doesn’t naturally work with dates, so we need a couple of calculated fields: StartNumber and EndNumber . These are created in the properties for the dataset using the following two expressions, respectively to define these two calculated fields (no line returns, the text wraps):

For reference, this is the Dataset Properties dialog after adding these two new fields:

sql server reporting services gantt chart

Choose Gauge from the Insert ribbon. Select a Bullet Graph from the Select Gauge Type dialog and then drop it onto a blank space on the report canvas.

When working with an intricate visual report item like a gauge, I make it a point to place it outside the data region, make it as big as possible to setup all the properties. Then, I cut and paste the gauge into the table cell.

sql server reporting services gantt chart

Mysteries of the Gauge Visual

This is where things get tricky. The Gauge, Databar, Sparkline and Indicator visualizations were all developed by Dundas Software. They had their own charting product and Microsoft purchased the code base to integrate with Reporting Services back in 2010. There is a trade-off when using these components; they erred on the side of giving us lots and lots of wonderful options to build complex charting visuals, rather than making them uber simple to use. You can spend lifetimes digging through these object collections and properties. Believe me – I’ve spent much of mine doing just that! Anyway, speaking from experience, check your OCD and don’t stay up too late at night trying to figure out every nuance because this can become a Pandora’s Box of knobs and levers that control all the intricate features of these visualizations.

To unravel the Gauge objects, start clicking-around to select objects in the gauge visual designer. You will see that objects are organized into a hierarchy of collections within the Gauge Panel. The items in bold are those used in this report:

  • CustomLabels
  • RadialGauges

Objects in the linear gauge and radial gauge have corresponding names, like LinearGaugePanel1 and LinearRange1 . You can modify or remove these objects by selecting them in the designer, or you can add or remove then in the properties pane using the ellipsis button for the collection of child objects.

For example, the Gauge Panel has a collection of Scales , and a Scale has a collection of Ranges and Pointers . Until you get the feel of things, you might want to make a second copy of the gauge. You can always use Ctrl-Z to undo a delete or property change if you get into trouble.

Setup the Gauge

Delete all the Pointers and all but the first Range (it’s named LinearRange1 ). You can click to select each object in the designer. Confirm the selection by checking the object name in the top of the properties pane before you delete or modify anything.

The following image shows the properties of the LinearScale1 . Modified and non-default properties are shown in bold:

sql server reporting services gantt chart

This is the entire MaximumValue property expression:

To choose the LinearRange1 object, either click to select the object in the designer or use the ellipsis ( … ) button in the properties panel to edit the Ranges collection, then update the properties shown here in bold:

sql server reporting services gantt chart

For properties that represent a collection of objects, you’ll see an ellipsis button (a button with three dots) on the right side of the property value cell when that property is selected. Click the button to open a dialog window to add, remove and edit the objects in the collection.

This is the entire ToolTip expression (text wraps so don’t use line returns):

Using the Insert ribbon, drop-down the Table button and choose Insert Table . Drop the table in the body of the report.

Expand the dataset and then drag and drop the Task field to the “Data” row in the first column of the table.

Select the gauge and then use Ctrl-X to cut it to the clipboard.

Select the second cell in the “Data” row of the table, and then use Ctrl-V to paste the gauge. Resize the second column and row height to adjust the gauge size and position.

Select and copy the gauge to the clipboard, using Ctrl-C .

Select the second cell in the “Header” row. Use Ctrl-V to paste a copy of the gauge into this cell.

In the new copy of the gauge, you will delete the Range and show the Scale . To do this, select the gray range bar and make sure that LinearRange1 is displayed at the top of the properties panel. Once you confirm that the Range object is selected, press the Delete key to remove it.

Select the LinearScale1 object in the new copy of the gauge.

Change the Hidden property to False .

Expand the LabelStyle group and change the UseFontPercent property to False . You can optionally expand the Font group and change the Font property of needed. This is one of the many properties you can tweak later if you want to adjust things to your liking .

To change the sort order of the table, choose the table and use the SortOrder expression. The default table name is Tablix1.

To select the entire table data region, click any cell in the table to show the gray row and column handles, and then click the gray box in the top-left corner, between the row and column handles.

The rest of the report design is typical. I’ve added textboxes to show the title and parameters selections. I’ve also added the option to hide and show additional columns using a parameter. These should be apparent in the sample RDL file I’ve provided. With variations on the design, you can enhance this report to add more details, and perhaps deal with weekends and non-workdays, etc. If you make such enhancements, please share them for benefit of the community.

Download Gantt Chart sample project here

Share this:

  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Reddit (Opens in new window)

Paul Turley

Paul Turley

Microsoft Data Platform MVP, Principal Consultant for 3Cloud Solutions Specializing in Business Intelligence, SQL Server solutions, Power BI, Analysis Services & Reporting Services.

Related Posts

Ci/cd & devops for power bi… are we there yet.

In my view, projects and teams of different sizes have different needs. I described DevOps maturity as a pyramid, where most projects don’t require a sophisticated DevOps implementation, and the most complex solutions do. The DevOps maturity is a progression, but only for projects of a certain scale. One of the following options might simply be the best fit for a particular project. Unless you are throwing together a simple Power BI report that you don’t plan to maintain and add features to, the first and most basic managed project should start with a PBIX file or Power BI Project folder stored in a shared and cloud-backed storage location. DevOps isn’t a requirement for all projects, but version control and shared file storage definitely is.

Power BI for the Enterprise Precon: Atlanta Feb 9th

Please come to the Atlanta SQL Saturday BI Edition in February, and join me for a full-day preconference event: Designing and Developing Enterprise-scale Solutions with Power BI

Conference Sessions and Presentations in late 2023 & 2024

Are you in the California Bay area? Do you want to learn to do Power BI and Fabric the right…

4 thoughts on “ Use Paginated Reports to Create a Gantt Chart ”

  • Pingback: Use Paginated Reports to Create a Gantt Chart – Paul Turley's SQL Server BI Blog - Seattle Daily Chronicle
  • Pingback: Use Paginated Reports to Create a Gantt Chart - Paul Turley's SQL Server BI Blog - Vancouver Daily Times

useful for beginners https://marketreportsinsights.com/de/industry-forecast/power-transformers-market-2022-134723

  • Pingback: Building a Gantt Chart with Power BI Paginated Reports – Curated SQL

Leave a Reply Cancel reply

Discover more from paul turley's sql server bi blog.

Subscribe now to keep reading and get access to the full archive.

Type your email…

Continue reading

sql server reporting services gantt chart

SQL Server Agent Gantt Chart in Power BI

sql server reporting services gantt chart

In this blog post, I walk-through how to use a Power BI template file I have created that displays a Gantt chart which shows which SQL Server Agent Jobs have run and when.

The purpose of the chart is to identify when jobs are overlapping and taking server resource off each other.

If two or more resource intensive jobs overlap, it’s a good idea to schedule them at different times if possible.

To use the template file, input the server name.

sql server reporting services gantt chart

Once the server name has been entered, the template does all the hard work for you and should produce your SQL Server Agent Gantt Chart.

SQL Server Agent Job Gantt Chart

Click here to download the Power BI Template file

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

sql server reporting services gantt chart

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

SSRS: customize area bar chart (gantt chart) — different colors based on expression

I have a dataset like this, but there are more rows

122400-table.png

There I have employees names and their qualifications in my project, start date and end date of their vacations and vacations id.

Then i did an area bar chart (gantt chart) based on this dataset. Lines are grouped by vacation_id, start of line is vacation start date and end of line is vacation end date. The vertical axis shows the names of the workers, and the horizontal axis shows the dates of current month. All lines are blue now. But I need to switch the lines color to red if vacations overlap by dates for those employees who have the same qualifications in my project. Is it possible to do this?

SQL Server Reporting Services A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports. 2,727 questions Sign in to follow

Could you share what your current area bar chart (gantt chart) looks like?

122684-chart.png

Do you mean that when employees have the same position, the overlapping parts of vacations are displayed in red, and the non-overlapping parts are displayed in blue? That is, does the bar graph of a certain employee have two colors at the same time? If I misunderstand what you mean, please feel free to correct me.

You may use SQL to resolve you problem. Add a boolean column "OverlappedQualifications" in your dataset. Then control the color based on the value in the column.

SSRS 2022 Install, Setup and Configuration

By: Joe Gavin   |   Updated: 2024-02-21   |   Comments   |   Related: > Reporting Services Installation

SQL Server Reporting Services (SSRS) is still one of the major components of the Microsoft Business Intelligence (MSBI) stack used to generate interactive and automated reports. It's part of Microsoft SQL Server services, along with SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).

SSRS 2022 includes enhanced Windows Narrator support, security enhancements, browser performance improvements, and accessibility bug fixes.

The SSRS installation process has changed slightly since it was first released in 2004 as an add-on to SQL Server 2000. We saw in a previous tip: SSRS Install, Setup and Configuration , where the SSRS installation used to be part of the SQL Server installer up through SQL Server 2016. As of SQL Server 2017, the installation now has its own downloadable installer. There are only some minor differences between installing SSRS 2019 and SSRS 2022, but knowing where to get the installer and what to expect before you go through the installation process is helpful. This tip will walk through the various screens and options for the installation process.

We'll look at the minimum hardware and software requirements, see where to get the installer, and walk through each step of installing and configuring a new installation of SSRS 2022. The installation documented here was done on a SQL Server 2022 running on Windows Server 2022.

SSRS 2022 Requirements

You'll likely have more resources than this, but the following are the minimum requirements for installing SSRS 2022:

  • 6 GB of available hard drive space
  • 512 MB (1 GB is recommended)
  • 1 GB (4 GB recommended)
  • X64: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
  • 1.4 GHz (2 GHz recommended)
  • Windows Server 2016/2019/2022, Windows 10 / 11
  • SQL Server Database Engine 2014 SP3 or later
  • .NET Framework 4.8 or later

SSRS 2022 Installation

Download the installer.

Go to Microsoft SQL Server 2022 Reporting Services Installer Download

  • Click Download .

Download SSRS 2022

Retrieve and Run Installer

  • Run SQLServerReportingServices.exe from your Download folder.

Download folder

Welcome Screen

The installer opens, and you're presented with one option on the Welcome screen.

  • Install Reporting Services.

Welcome Screen

Choose Edition and Install

There are four edition options for SSRS. The first three do not require a Product Key:

  • Evaluation Edition – Full edition that is good for 180 days.
  • Developer Edition – Full edition that can be used for non-production, e.g., test, development, training, or demonstration purposes.
  • Express Edition – Limited edition with fewer features than the full edition.
  • Paid Edition - The fourth option requires a product key. Click Learn more , which will take you to Find the product key for SQL Server Reporting Services .

Install Paid Edition

  • Click the Enter the product key radio button and enter the key in the box.
  • Click Next .

Choose Edition

Review Licensing Terms

  • Read and accept license terms by checking the 'I accept the license terms' checkbox.

License Terms

Install Database Engine

Install SSRS

Specify Install Location

  • Choose the drive and directory to install SSRS.
  • Click Install .

Installation Location

The SSRS application has been installed, and now it's time to configure it.

Configure SSRS

  • Click Configure report server , which runs RSConfigTool.exe to open the Report Server Configuration Manager.

Configure SSRS

Connect to the SSRS Server

  • Click Connect .

Connect to SSRS

Configure Service Account

If the SSRS server requires access to remote servers, a Windows domain account can be specified to run the SSRS service.

  • Click on Service Account in the Report Server Configuration Manager.
  • Select the 'Use another account' radio button. Enter the domain account information and password.
  • Click Apply .

Configure Service Account

Configure SSRS Databases

Here, we configure the SSRS databases.

  • Click Database in the Report Server Configuration Manager.
  • Click Change Database .

Databases

Create New Database

The new SSRS installation can be pointed to an existing set of SSRS databases. However, since this is a new installation, the default 'Create a new report server database' is left selected, and the installer will create the new databases.

Create Databases

Test the Connection

We must test the connection to the SQL Server to ensure connectivity before attempting to create the SSRS databases.

  • Click Test Connection .
  • If the connection is successful, click OK .

If the connection is unsuccessful, verify that the SQL Server service is running and accepting connections, and then run the test again.

Test Connection

Name the Database

Unless a name other than the default database names must be used, leave the defaults as ReportServer and ReportServerTemp.

Database Names

Specify Credentials

Credentials

Review Summary

Review the install configuration on the Summary screen.

  • Click Next if all information is correct.

Summary

Progress and Finish

Verify all tasks completed successfully.

  • If all tasks are successful, click Finish .

Progress and Finish

At this point, we have the SSRS service installed and databases created.

It's time to create the Web Service and the Web Portal.

Create the SSRS Web Service

  • Click on Web Service URL .

Web Service URL

Validate Web Service

Open the Report Server Web Service URL to validate. There are no folders shown because no reports have been deployed yet.

Web Service

Create Web Portal

  • Click Web Portal URL .

Web Portal URL

Validate Web Portal

To validate, open the Report Server Web Portal URL. Again, the root folder is empty because no reports have been deployed yet.

Web Portal

We now have a fully functioning SSRS server that's ready for reports to be deployed to it.

Email Settings

If Subscriptions to email reports will be created, we'll need to configure the email settings.

  • Click E-mail Settings .
  • Enter a Sender Address in the form of [email protected] .
  • Enter the SMTP Server name.
  • Select the Authentication dropdown menu to enter the account and password information if your SMTP server requires authentication.

E-mail Settings

Email has been configured.

  • Click Exit .

Exit

You may run into failures, sometimes sporadically, related to TLS 1.2, where subscriptions are not sending emails and generating errors like this:

ERROR: Error sending email. Exception: System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream.

Adding the following registry keys will force TLS 1.2:

Registry Keys to Force TLS 1.2

The following links have more information on SQL Server Reporting Services:

  • SSRS Install, Setup and Configuration
  • SQL Server Reporting Services 2017 Installation and Configuration
  • Install SSRS ReportServer Databases on Azure SQL Managed Instance
  • Installing SQL Server Reporting Services 2017
  • SQL Server Reporting Services Standalone Installation
  • How to Add SSRS to Existing SQL Server Clustered Instance
  • PowerShell Commands for SQL Server Reporting Services
  • Visual Studio 2019 Install and Configure for the SQL Server DBA
  • How to Install and Configure SSRS with Amazon RDS SQL Server
  • Side by Side SSRS Install and Upgrade to Minimize Downtime

sql server categories

About the author

MSSQLTips author Joe Gavin

Comments For This Article

Related articles.

Please enter your information to subscribe to the Microsoft Fabric Blog.

Microsoft fabric updates blog.

Microsoft Fabric February 2024 Update

  • Monthly Update

Headshot of article author

Welcome to the February 2024 update.

We have a lot of great features this month including Fabric Git Integration REST APIs, Fabric notebook status bar upgrade, Copilot in Dataflow Gen2, and many more!

Fabric Community Conference

Join us at the Microsoft Fabric Community Conference the ultimate Microsoft Data & AI learning event, on March 26-28, 2024, at the MGM Grand, Las Vegas. With over 150 sessions for everyone who works with Power BI, Microsoft Fabric, SQL, Azure AI, and Purview , the conference promises a rich learning experience.

This is a unique opportunity to meet the Microsoft product teams building these technologies, the customers betting their businesses on them, and the partners that are at the forefront of deployment and adoption. Engage with this vibrant community, learn from their real-world experiences, stay abreast of the latest developments.

Please note that this event is in-person only. Sessions will not be recorded, streamed or made available for on-demand consumption.

Register today using code MSCUST for an exclusive discount ! Need help convincing your boss to attend? No problem!  Use this letter  to share with your boss about this unforgettable opportunity.

  • Visual calculations 
  • Dynamic subscriptions for Power BI reports  
  • On-object Interaction Updates 
  • Power BI Home in Desktop is Enabled by Default   
  • Enhanced Reference Layer in Power BI Azure Maps Visual 
  • Measure descriptions with Copilot  
  • DAX query view improvements 
  • Certified connectors updates 
  • Storytelling in PowerPoint – Replace report URLs with shareable links in Power BI add-in 

Data overview in Explore

Directquery connections update, shared device mode is now ga, power bi custom visuals new local storage api, on-object interaction support for custom visuals, tmdl in power bi desktop developer mode, editor’s pick of the quarter.

  • New Visuals in AppSource
  • Multiple Sparklines 21
  • Rose Donut Pie Chart by Powerviz 

xViz Gantt Chart by Lumel

  • Control Chart XmR by Nova Silva 
  • Drill Down Graph PRO 
  • More users can now collaborate with protected PBIX in Power BI desktop 

Customizable Navigation Pane

Persistent filters in workspace, domains in onelake, fabric git integration rest apis, delegation for git integration settings, data warehouse, browse code snippet, configure session timeout, fabric notebook status bar upgrade, copilot in fabric (preview) is available worldwide, kql db shortcut to delta lake tables support name-based column mapping, kql db shortcut to delta lake tables support deletion vectors, get data in kql db now supports processing events before ingestion via eventstream, kql db now supports data ingestion using apache flink, route data from splunk universal forwarder to kql db using kusto splunk universal connector, copilot in dataflow gen2, certified connector updates, connector updates.

Visual calculations

A new way of doing calculations has arrived! You can now add calculations directly on your visual using visual calculations, which are DAX calculations that are defined and executed directly on a visual. A calculation can refer to any data in the visual, including columns, measures, or other visual calculations. This approach removes the complexity of the semantic model and simplifies the process of writing DAX. You can use visual calculations to complete common business calculations such as running sums or moving averages. Visual calculations make it easy to do calculations that were previously very hard or even almost impossible to do.

To use visual calculations while in preview, you need to enable it in Options and Settings > Options > Preview features . Select visual calculations and select OK . Visual calculations will be enabled after Desktop is restarted.

To add a visual calculation, you first need to select a visual. Next, select the New calculation button in the ribbon:

The new calculation button is shown on the Home tab of the ribbon in Power BI Desktop in the Calculations group.

To add a visual calculation, type the expression in the formula bar in the visual calculations edit mode that opens. For example, in a visual that contains Sales Amount and Total Product Cost by Fiscal Year , you can add a visual calculation that calculates the profit for each year by simply typing: Profit = [Sales Amount] – [Total Product Cost].

The visual matrix is updated as you add visual calculations using in the formula bar. New visual calculations are added as columns to the visual matrix.

Additionally, you can easily add a running sum of profit by writing:

Here is a visual with the two visual calculations we have just created:

sql server reporting services gantt chart

You can use many existing DAX functions in visual calculations. Functions specific to visual calculations are also available, such as RUNNINGSUM , PREVIOUS and MOVINGAVERAGE . Using these and other functions, visual calculations are much easier to read, write and maintain than the current DAX required.

We are only just getting started with this preview. There is a lot more that we have planned, so please stay tuned for updates in future releases. However, we invite you to jump in now!

For more information, read the dedicated blog pos t and documentation . Please try the preview today and let us know what you think.

Dynamic subscriptions for Power BI reports

Dynamic per recipient subscriptions is now available in Preview for Power BI reports! Like dynamic subscriptions for paginated reports , you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription.

Imagine you have a report that includes sales data for your entire team. You want to schedule an email subscription that sends out a PDF copy of this report to each salesperson on a weekly basis, with the report filtered to only show their sales results.

This can now be done by connecting to a semantic model (previously Power BI dataset) that defines the mapping between recipients and respective filter values. When it’s time to send out the report, the latest data available in your semantic model will determine which employees should receive a report in their inbox, and with what filter values applied.

sql server reporting services gantt chart

See the documentation for dynamic subscriptions here.

On-object Interaction Updates

This February release we added multi-visual container format support ! Previously, when multi-selecting across different visual types, the format pane did not support any options for formatting the visuals. Now, when multi-selecting different visuals, we’ve added formatting support for container formatting such as changing the size, background color, adding a shadow or turning on/off titles in bulk.

When multi-selecting different visual types (e.g. a line chart and bar chart):

A screenshot of a graph.

We’ve also added the ability to format a visual’s container size and position even if it’s empty:

 A screenshot of a graph

This month we also bring you a handful of quality improvements to the on-object experience:

  • Bug fix : when working with a non-visual (text box, button, image, shape) the build pane accidentally closing automatically. The build pane now stays open unless explicitly closed regardless of selected item type.
  • Bug fix : style bug where the build pane was showing 5 icons across instead of the usual 6 has been fixed.
  • Bug fix : in some cases, the data flyout was extending beyond the window size making the search box hard to use, this has now been fixed.
  • Enhancement : When choosing a field using the data flyout – you can now click anywhere on the name, not just the checkbox next to it to select the field.

A screenshot of a showing how to select Order Quantity

  • Enhancement : If replacing a field in a visual that does not use an aggregation or date hierarchy (other dropdowns are disabled), we auto open the data dropdown to save an extra click.

A screenshot of a computer showing how to select Category.

Power BI Home in Desktop is Enabled by Default 

We are excited to announce the new and improved Power BI Home as the default experience! The Power BI Home has been redesigned to provide a centralized and familiar location for all your Power BI activities within the desktop application. Our aim is to enhance your productivity and make it easier to discover and consume content.

With Power BI Home, you no longer need to navigate through multiple menus or tabs to access your files and reports. This intuitive interface serves as a hub, like other popular office products, where you can effortlessly manage your reports, all from a single location.

Whether you’re a seasoned Power BI user or new to the platform, Power BI Home ensures a consistent and seamless experience across all your Power BI activities.

Now, you can:

  • Initiate a new report directly from the new home screen.
  • Access reports from recommendations that we have curated.
  • Locate your most recent reports through the Quick Access lists.

A screenshot showing the new home screen.

Please continue to submit your feedback directly in the comments of this blog post or in our feedback forum.

Enhanced Reference Layer in Power BI Azure Maps Visual

We’re excited to introduce a significant enhancement to the Power BI Azure Maps visual reference layer feature. In response to valuable user feedback and in alignment with evolving industry standards, we have expanded the capabilities of the reference layer. Now, in addition to supporting the existing GeoJSON format, users can also utilize KML (Keyhole Markup Language) and WKT (Well-Known Text) formats.

We’re also adding URL as a data source alongside file upload. This addition offers users even more flexibility and convenience in importing spatial data into Power BI. Whether your data resides in GeoJSON, KML, WKT, or through a URL link, the Power BI Azure Maps visual seamlessly integrates these formats, ensuring a comprehensive and versatile geospatial analysis experience.

Measure descriptions with Copilot

Add descriptions to your semantic model measures with Fabric Copilot for Power BI! People building reports from your semantic model can see the name and description of your measures, making the description property essential documentation. And Fabric Copilot is here to help!

sql server reporting services gantt chart

Streamline your semantic model documentation by creating measure descriptions with Copilot .

1. Click on the model measure in the Data pane of Model view to see the measure properties .

2. Click on the Create with Copilot (preview) button under the Description textbox.

3. Review the measure description from Copilot, then click Keep it .

4. Now the measure description is in the Description box. Fine tune the description, as needed.

5. You update the measure later? No worries, just click the button again when you need the description updated!

Try this out today and let us know what you think! Get started today by turning on this public preview feature in Options > Preview features and learning more about how to get access to Fabric Copilot for Power BI on your tenant at https://learn.microsoft.com/power-bi/create-reports/copilot-introduction#copilot-requirements.

DAX query view improvements

We released the public preview of DAX query view in November 2023, and in this release, we made the following improvements:

  • Boolean values are now showing in the Results grid.

sql server reporting services gantt chart

  • A share feedback link has been added in Options > Preview features. We would love to hear your feedback on DAX query view!
  • A bug causing active query tab to stop being highlighted is fixed.
  • A bug with close brackets of a nested IFs DAX formula is fixed.

And we have released additional INFO DAX functions.

  • INFO.CHANGEDPROPERTIES()
  • INFO.EXCLUDEDARTIFACTS()
  • INFO.FUNCTIONS()
  • INFO.LINGUISTICMETADATA()

sql server reporting services gantt chart

Learn more about DAX query view at https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view.

Data connectivity

Certified connectors updates.

SingleStore, we’re thrilled to inform you that our connector has now officially moved out of beta. We want to express our gratitude for your valuable feedback and for being an essential part of our beta journey. Your insights have played a crucial role in shaping the enhancements we’ve made.

This upgrade comes with an exciting new feature – you can now cancel running queries, hassle-free. No more queries running in the background after you refresh the UI/visual or navigate across the pages in the report.

Our team is dedicated to continuously improving and adding even more useful features to enhance your experience. Thank you for your ongoing support, and we can’t wait to continue providing you with top-notch features that elevate your data connectivity and reporting capabilities.

Storytelling in PowerPoint – Replace report URLs with shareable links in Power BI add-in

When you add the Power BI add-in to a presentation, you can pick a report suggested to you or paste a link to a specific report.

When you paste a standard report link (the URL copied from the browser address bar), and if sharable links are enabled for your organization and allowed for this report, you have re-share permissions to this report, Power BI add-in can replace the link you pasted with shareable link. In that case you will see a checkbox added below the report URL that offers you automatic access to this report. Just mark this checkbox and Power BI add-in will create a shareable link for you.

Using a sharable link ensures that other users viewing the presentation have the required permission to see the report, and do not need to request access when viewing the presentation.

sql server reporting services gantt chart

Have you tried out the new Explore feature yet? This month we added a data overview feature to Explore that allows you to get the “gist” of what your data is all about. Powered by Copilot, data overview gives you a summary of what’s contained in the data you’re exploring and highlights some interesting tidbits to get you started. Let us know what you think!

sql server reporting services gantt chart

Maximum connections per data source  is a setting to configure the maximum number of connections DirectQuery opens for each underlying data source. This controls the maximum number of queries that can be executed concurrently against each data source and is configurable per semantic model.

We recently updated the upper limit of the number of concurrent Direct Query connections allowed per semantic model. The updated limits for each SKU are listed in the table below.

The upper limit for Power BI PPU is 100 active connections. Note that there is no change to the Power BI Pro and Report Server limits and the default maximum value remains as 10 concurrent connections.

Introduced last September, shared device mode is now generally available! With shared device mode, organizations can safely deploy the Power BI mobile app across their pool of shared devices.  Check it out !

This API allows Custom Visuals to store data directly in the local browser. Data stored locally is more secure and improves the performance of web apps. The API will be controlled by a global admin setting. Learn more about the API.

Our February release introduces the support of the new on-objec t interaction. This enhancement allows users to build and customize visuals directly on the visual in Power BI Desktop. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text. 

The primary objective of Power BI Desktop developer mode is to provide friendly source control and co-development experience. With this objective in mind, you can now save your Power BI Project files (PBIP) using Tabular Model Definition Language (TMDL) format. TMDL is easily readable and editable in any text editor. It was designed for humans and is collaborative by default with its native folder structure.

Saving as a PBIP using TMDL is currently in preview. Before giving it a try, you must first enable this feature in Preview features: go to File > Options and settings > Options > Preview features and check the box next to “Store semantic model using TMDL format”.

After enabling the preview feature, when saving as PBIP, your semantic model will be saved as a TMDL folder named “\definition”:

sql server reporting services gantt chart

Existing PBIP files can also be easily converted to TMDL by simply opening them and selecting “Upgrade” in the upgrade popup during the save process:

sql server reporting services gantt chart

During the Public Preview, Fabric Git Integration will still export the semantic model as Tabular Model Scripting Language (TMSL) by default. However, if the semantic model is imported into Fabric using TMDL, then Fabric Git Integration will use TMDL when exporting the definition into Git.

Learn more about TMDL in Power BI Desktop developer mode here .

Visualizations

  • Inforiver Analytics+ (Charts+Cards+Tables)
  • Inforiver Premium Matrix / Table
  • Drill Down Donut PRO (Filter) by ZoomCharts
  • Date Picker
  • Enlighten Aquarium
  • Deneb: Declarative Visualization in Power BI

New visuals in AppSource

  • Comment – Dynamics 365 Finance business performance planning
  • Reporting – Dynamics 365 Finance business performance planning
  • Variance – Dynamics 365 Finance business performance planning
  • Matrix planning – Dynamics 365 Finance business performance planning
  • Copy – Dynamics 365 Finance business performance planning
  • Table edit – Dynamics 365 Finance business performance planning  
  • Graphical planning – Dynamics 365 Finance business performance planning
  • Waterfall-Visual-Extended
  • Processifier Process Mining
  • flashbi fantail
  • Map by Squillion
  • Charticulator Visual Community (View)

Multiple Sparklines

New features were added to Multiple Sparklines on Oct 23

  • When you double click a line chart, it will zoom in to screen size of visual and you can then compare it with any other line chart in that column.
  • You can use different colors for each line chart in a field/column.
  • You can insert ratings with bands.
  • You can add beeswarm / distribution microchart.

sql server reporting services gantt chart

Once you double click the line chart, it zooms in to the visual size. You can then compare it with another line chart in the same column. This is shown below:

sql server reporting services gantt chart

Download this visual from APPSOURCE

For more information visit https://www.excelnaccess.com/sparklines/

or contact [email protected]

Rose Donut Pie Chart by Powerviz

Rose/Donut/Pie Chart is a powerful visual that lets you build four types of charts – a rose, a rose donut, a donut, and a pie chart. These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison.

Key Features:

  • Chart Options: Rose, donut, pie charts with style customization.
  • Data Colors: Choose from 30+ palettes, including color-blind mode.
  • Fill Patterns: Apply patterns or use custom images.
  • Smart Labels: Improve readability with data and leaf labels.
  • Arc Customization: Easily adjust arc radius, padding, and stroke.
  • Ranking: Filter Top/Bottom N, show others intelligently.
  • Center Circle: Multiple layers, text, icons, and images in the center.
  • Mouseover Text: Display dynamic details when hovering over arcs.
  • Image Labels: Integrate dynamic image URLs for enhanced visuals.
  • Conditional Formatting: Detect outliers and set smart rules for measures/categories.

Other features included are annotation, grid view, show condition, and accessibility support.

Business Use Cases: Finance, Healthcare, E-commerce, Education, Customer Demographics

🔗 Try Rose/Donut/Pie Chart for FREE from AppSource

📊 Check out all features of the visual: Demo file

📃 Step-by-step instructions: Documentation

💡 YouTube Video: Video Link

📍 Learn more about visuals: https://powerviz.ai/

✅ Follow Powerviz : https://lnkd.in/gN_9Sa6U

sql server reporting services gantt chart

xViz Gantt Chart by Lumel is a Microsoft Power BI Certified Visual. As the most feature rich Gantt in Power BI – it is widely used across most Fortune 500 companies world-wide.

Why Large Enterprises Choose xViz Gantt Chart:

Real-time Alerts for Project Managers: Leverage Conditional Formatting to receive color-coded alerts and status flags, ensuring timely awareness of schedule delays or progress issues.

Visualize Task Dependencies: Easily identify causes of delays with the ability to plot task dependencies using connectors within the roadmap view.

Adaptable for Different Users: From Stakeholders tracking yearly progress to Project Managers analyzing monthly views and Developers scrutinizing smaller time grains with flexibility across three distinct timeline levels.

Strategic Planning with Reference Lines and Ranges: Utilize Reference Lines and Ranges to mark crucial dates, holidays, sprints, or deadlines across projects.

Customization Galore:   Wide range of customizable options, including adjustable timeline limits, selectable week start days, and indentation customization for ragged hierarchies.

Hassle-Free Licensing:   The visual is free for use in Power BI Desktop. For sharing & collaborating on Power BI service, the licenses can be purchased directly from Microsoft AppSource.

sql server reporting services gantt chart

Try xViz Gantt Chart today after watching the 2-minute video highlights .

Control Chart XmR by Nova Silva

Years ago, Stacey Barr introduced us to the magic of Control Charts. Magic it is, because it allows everyone to split their temporal data in two: random noise and real signals. And we all are looking for real signals, and don’t want to be distracted by random noise.

In our last release of the Control Chart XmR we have added several new features to make it even easier to find real signals and ignore random noise in your data.

First, we added a feature to allow any report consumer to override the applied rules. This allows everyone to analyze the effects of one specific rule or set of rules.

sql server reporting services gantt chart

Several customers asked for a possibility to download the calculated values from the visual. Now you can download all values calculated by the Control Chart XmR, like: LCL, CL, UCL, sigmas and signals.

Don’t hesitate and try the new Control Chart XmR now on your own data by downloading it from the AppSource . All features are available for free to evaluate this visual within Power BI Desktop.

Questions or remarks? Visit us at: https://visuals.novasilva.com/ .

Drill Down Graph PRO

Drill Down Graph PRO lets you create elegant and user-friendly graphs to represent complex relationships between nodes. It’s ideal for both small and large network graphs and offers advanced features like cross-chart filtering and vast customization options. You can create hierarchies and explore them using this visual’s intuitive interactions.

Main features include:

  • Multiple layout options – dynamic, hierarchical, and radial
  • Focus nodes mode – for gradual exploration of graphs
  • Customization options – choose colors, shapes, images, and labels
  • Bidirectional links – show reciprocal relationships between nodes
  • Touch device support – explore your data anywhere

Popular use cases:

  • IT – asset management, IT infrastructure, IoT monitoring
  • Logistics – fleet management, stock management, parcel tracking
  • Sales & Marketing – community detection, account management, web analytics

ZoomCharts Drill Down Visuals are known for interactive drilldowns, smooth animations, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu. Use them to create visually appealing and intuitive reports that business users will love on any device.

Get Drill Down Graph PRO from AppSource!

Learn more about Drill Down Graph PRO by ZoomCharts.

sql server reporting services gantt chart

More users can now collaborate with protected PBIX in Power BI desktop

Have you ever wondered how to collaborate with your colleagues on sensitive data without compromising its security? Do you want to learn how to use Microsoft Purview Information Protection sensitivity labels to protect your data ?

If so, you’re in the right place! We’ll show you how to use sensitivity labels with protection to encrypt and protect your data, and how to enable more users to edit and republish encrypted PBIX files. By the end of this article, you’ll be able to collaborate more securely with your data in Power BI.

Protecting your data with Microsoft Purview

Compliance admins in your organization can use Microsoft Purview Information Protection  sensitivity labels  to manage their org’s sensitive data across different apps and services and meet regulatory and compliance requirements.

They define file protection policies for the sensitivity labels, which result in files being encrypted when such labels are applied, allowing only authorized users to open and edit these files in Office apps and Power BI Desktop.

Sensitivity labels are widely adopted by enterprises today and used to label and protect content in  Microsoft 365  apps such as Excel, PowerPoint, Word, and Outlook, and now in Power BI and Fabric as well.

All you have to do is enable Information Protection in Microsoft Fabric’s Admin Portal and let the labels do the rest.

sql server reporting services gantt chart

How Power BI Desktop enforces sensitivity label protection

In Power BI Desktop , we enforce label protection on PBIX files. To open a PBIX file, you either must be the label issuer or have one of the following usage rights .

These usage rights are elevated permissions, as they grant permission to change the sensitivity label. Because Power BI and Office apps use the same label policies, compliance admins may prefer not to grant these usage rights for Highly confidential labels. This might block you from collaborating with your colleagues when you’re sharing or downloading Power BI reports and trying to open them in the desktop app.

Collaborating and keeping label protection on PBIX files

By enabling “ More users in your organization to edit and republish encrypted PBIX ” in your tenant, users that have been assigned with all of the following usage rights should be able to open, edit, and republish the protected PBIX file to the Power BI service:

  • View Content (VIEW)
  • Edit Content (DOCEDIT)
  • Save (EDIT)
  • Copy and extract content (EXTRACT)
  • Allow Macros (OBJMODEL)

Thus, users who were once restricted can now collaborate with protected files, while keeping protection consistent with the organizational policy.

Note: These usage rights are a sub-set of the “Co-Author” permissions preset in Microsoft Purview compliance center.

What are the restrictions and why?

In order to align with compliance requirements, users with these usage rights are lightly restricted while editing a protected PBIX file.

No exporting to unsupported formats –The user won’t be able to export to formats that don’t support sensitivity labels, such as CSV files.

sql server reporting services gantt chart

No label change – The user can’t change the label on the PBIX file.

sql server reporting services gantt chart

Republishing to the original workspace only

sql server reporting services gantt chart

Why restrict republishing into the original workspace only?

To remain compliant, we must keep users from gaining more permissions, including Power BI permissions (i.e., Read, Write, Reshare and Build). Meaning that a user who wishes to publish should not be able to publish to a workspace that might grant them additional permission through Workspace roles.

Additionally, this feature is meant for collaborating and sharing items that are more restricted than usual, and confidential data is usually managed in a dedicated workspace. This restriction will prevent users from publishing confidential data across the tenant.

Side note: The file must be published at least once for other users to be able to republish it to that specific workspace. If the file has not yet been published, then the latest label issuer (the one who set the protected label) or a user with sufficient usage rights must publish it and then share the file with the other editors.

How to enable it

Prerequisite: The compliance admin must assign you and your colleagues the proper permissions for that sensitivity label.

Next, Fabric/Power BI admins must enable the feature in Admin Portal > Information protection > Increase the number of users who can edit and republish encrypted PBIX files (preview).

In Power BI Desktop, users who would like to open and edit protected PBIX files must enable the feature by opening File > Options and settings > Options > Preview feature > Less elevated user support.

Final words

With this new feature, users can now collaborate more easily with other users when working on confidential data in Power BI Desktop, without any loss of protection along the way.

This new feature allows users to customize their preferred entry points on the left navigation bar. With this feature, users can now easily unpin the entry points they don’t need by simply right-clicking on them, freeing up more space for the content they focus on. Even though an entry point is unpinned, it remains accessible through the three dots overflow menu in the left navigation bar. And if users need to pin an entry point back, they can easily do so from the overflow menu.

We hope this new feature will make navigating our platform even more efficient and personalized for our users.

sql server reporting services gantt chart

With persistent filters in workspace, you can save selected filters in workspace list view. And they will be automatically applied the next time you open the workspace. You don’t have to repeat the same steps every time to see the items you care about in your daily work. You can also easily add and remove filters or clear all applied filters to set the list view back to default state.

sql server reporting services gantt chart

Domains in OneLake help you organize your data into a logical data mesh, allowing federated governance and optimizing for business needs.

We recently introduced:

  • Sub domains (public preview) for better structuring.
  • Set up the domain as default for users and security groups (public preview), this capability will help keeping the relevant data under the relevant domain without additional work from the tenant or domain admins.
  • Move To (Public preview) enables admins to select one or multiple workspaces and to easily move them between sub domains and domains without the need for unassign and reassign to the correct place.
  • Domains REST APIs for Admin (public preview).

Create subdomains

To create subdomains for a domain, open the domain you want to create a subdomain for and select  New subdomain .

sql server reporting services gantt chart

Provide a name for the subdomain in the  new subdomain  dialog that appears. When done, select  Create .

sql server reporting services gantt chart

Note – Subdomains don’t have their own domain admins. A subdomain’s admins are the domain admins of its parent domain.

Configure Default Domain –

Select Domains settings –

sql server reporting services gantt chart

Select  Default domain (preview)  and specify users and/or security groups. When the specified users and/or security groups create new workspaces, or update unassigned workspaces, those workspaces will automatically be assigned to the domain. This capability helps keep the relevant data under the relevant domain without additional work from the tenant or domain admins.

sql server reporting services gantt chart

Move WS between domains or sub domains

Select the WS you would like to move (you can select one or more)

sql server reporting services gantt chart

Select the destination and click on Move Here

sql server reporting services gantt chart

The WS will be assigned to the selected destination.

Learn more about the available API’s here , and about domains and all the value they provide here  – Easily implement data mesh architecture with domains in Fabric | Microsoft Fabric Blog | Microsoft Fabric.

Git Integration

We are thrilled to announce the public availability of the highly anticipated REST APIs for Fabric Git integration! This new set of APIs enables seamless incorporation of Fabric Git integration into your team’s end-to-end CI/CD pipeline, eliminating the need for manual triggering of actions from Fabric. The APIs encompass capabilities such as connecting a workspace to Git, committing changes to Git, updating changes from Git, retrieving the status of items in the workspace, and more.

In addition to the APIs, we have also introduced several PowerShell samples to facilitate a quick start with Git integration APIs in your workflow.

Check out the full blog pos t for more details and all the resources.

Until now, all Git related settings could only be enabled or disabled by the tenant admin, for all workspaces and capacities. This includes enabling Git integration, controlling cross-region connections, and controlling export of items with sensitivity labels.

To enable more control over these settings, a tenant admin can now delegate these settings to both capacity admins and workspace admins.

This means that once delegated by the tenant admin, the admin of each resource can decide on their own whether to enable a setting or not.

In the example pictured below, a tenant admin has disabled from the admin portal the ability to connect to repositories in a geographic location different to that of the workspace, but enabled delegation of this capability to workspace admins:

sql server reporting services gantt chart

With these settings in place, by default workspaces cannot be connected to repositories in different regions than those of the tenant. However, within the workspace settings, any workspace admin can view this default configuration or choose to enable the capability for all or some of their workspace members:

sql server reporting services gantt chart

Learn more here on the Git integration settings, and how to enable delegation.

In our continued commitment to providing a streamlined, efficient, and user-friendly data warehousing experience in Fabric, we have released several improvements related to connectivity and performance. One of the notable enhancements is the improved experience for creating warehouses, which has been made more intuitive and user-friendly. Additional improvements in the areas of T-SQL execution, automatic metadata discovery and error messaging make it easier for customers to load and process their data in Fabric quickly and efficiently.

Data Engineering

We are excited to introduce a new notebook feature: Browse code snippet. This feature allows you to easily access and insert code snippets for commonly used code snippets with multiple supported languages. You can also learn the best practices that are recommended by Fabric and improve your coding skills of using Fabric Notebook.

With browse code snippet, you can:

  • Find the code snippet you need by searching keywords or browsing categories.
  • Filter code snippets by language.
  • Preview the code snippet and see its description, syntax, and usage.
  • Insert the code snippet into your Notebook cell with one click or copy it to the clipboard.

You can find “Browse code snippet” it from “ Edit ” tab.

sql server reporting services gantt chart

Notebook now supports configuring session timeout for the current live session. It can help you avoid wasting resources or losing context due to timeout. With a set session timeout, you can:

  • Specify the maximum duration of your spark sessions, from minutes to hours.
  • Get alerts before the session expires and extend it with a single click.

To use set session timeout, you can click on the upgraded cell status bar on notebook.

sql server reporting services gantt chart

And click the “Extend” button to configure the current session timeout value.

sql server reporting services gantt chart

We are excited to announce the new version of Fabric Notebook status bar, this upgrade contains a couple of useful features and shortcuts that can help you easily find the relevant info and navigate back and forth!

The new status bar has 3 persisted info buttons, they are.

  • Session status
  • Save status
  • Cell selection status

Moreover, it also contains a few contextualized features that can be triggered under certain situations, they are:

  • Git connection state when your workspace is connected with Git.
  • Extend session shortcuts (supported in Spark runtime 3.4) when your session is about to expire.
  • Failed cell navigator when your notebook has failed cells.

Check out the Fabric Monthly Update video for a demo to learn the usage!

Data Science

During November 2023, we unveiled the public preview of Copilot in Microsoft Fabric . This preview includes Copilot for Power BI, Data Factory and Data Science & Data Engineering. Since then, we have been gradually rolling this feature out and today, we are excited to announce that our Copilot preview is now available to all customers!

To access the Copilot in Fabric, you must have a paid SKUs (F64 or higher, or P1 or higher) with capacity available in the following Fabric regions and your tenant administrator needs to enable Copilot. This can be done with a new tenant setting group, “Copilot and Azure OpenAI Service (preview)” , in the admin portal. Enable Copilot for Microsoft Fabric (preview).

Since December 2023, we shipped a new feature that allows tenant admins to enable AI and Copilot in Fabric for specific security groups in addition to the entire organization. This means that Copilot can now be tailored to the needs of different groups within your organization. More granular AI and Copilot setting on Capacity level is coming.

Real-time Analytics

Column mapping feature allows Delta table columns and the underlying Parquet file columns to use different names. This enables Delta schema evolution operations such on a Delta table without the need to rewrite the underlying Parquet files and allows users to name Delta table columns by using characters that are not allowed by Parquet.

KQL DB now supports reading Delta tables with column name mappings. Delta Lake table format interoperability – Microsoft Fabric | Microsoft Learn

Deletion vectors are a storage optimization feature that can be enabled on Delta Lake tables. With deletion vectors enabled for the table, DELETE and UPDATE operations use deletion vectors to mark existing rows as removed or changed without rewriting the Parquet file.

KQL DB can now read delta tables with deletion vectors, resolving the current table state by applying the deletions noted by deletion vectors to the most recent table version. Delta Lake table format interoperability – Microsoft Fabric | Microsoft Learn

The Process event before ingestion in Eventstream option enables you to process the data before it’s ingested into the destination table. By selecting this option, the get data process seamlessly continues in Eventstream, with the destination table and data source details automatically populated. Get data from Eventstream – Microsoft Fabric | Microsoft Learn

sql server reporting services gantt chart

Apache Flink is a framework and distributed processing engine for stateful computations over unbounded and bounded data streams. The Kusto connector for Flink is an open-source project that can run on any Flink cluster. It implements a data sink for moving data from a Flink cluster to an Azure Data Explorer table. Using Azure Data Explorer and Apache Flink, you can build fast and scalable applications targeting data driven scenarios. For example, machine learning (ML), Extract-Transform-Load (ETL), and Log Analytics. Ingest data with Apache Flink into KQL DB

Splunk Universal Forwarder is a lightweight version of the Splunk Enterprise software that allows you to ingest data from many sources simultaneously. It’s designed for collecting and forwarding log data and machine data from various sources to a central Splunk Enterprise server or a Splunk Cloud deployment. Splunk Universal Forwarder serves as an agent that simplifies the process of data collection and forwarding, making it an essential component in Splunk deployment. You can now use the Kusto Splunk Universal Connector to send data from Splunk Universal Forwarder to a table in your KQL DB. Ingest data from Splunk Universal Forwarder to KQL DB

Data Factory

Dataflow gen2.

We are excited to announce the public preview of Copilot for Data Factory in Microsoft Fabric, which is now included in the Dataflow Gen2 experience. Copilot for Data Factory is an AI-enhanced assistant that supports both citizen and professional data wranglers in streamlining their workflow by providing intelligent Power Query mashup code generation to transform data with ease and generating code explanations to help users better understand complex data cleansing tasks. To use Copilot, you’ll need access to a workspace that has a P1 or higher or a F64 or higher capacity.

Supported capabilities:

  • Ex. “Convert the temperature column to Celsius.”
  • Ex. “Describe the Trips query”
  • Ex. “Create a new query that is a calendar table starting from 2020 to current date with lots of columns to slice and dice my data with.”

Check out the  Copilot for Data Factory Docs  for complete instructions and requirements and don’t hesitate to leave a comment in the  Fabric Community site  if you have any questions.

The Power Query SDK enables you to create new connectors for both Power BI and Dataflow experiences. With a robust set of tools to allow you to define a custom experience for your users when connecting to your data source and how they should be seen in the Power Query experience, you can see what some of our partners have been able to accomplish and delivered inside of Power BI and Dataflows today.

This month we’re glad to release new updates for the following certified connectors:

  • FactSetAnalytics
  • AutodeskConstructionCloud
  • EmplifyMetrics
  • SingleStoreODBC
  • SolarWindsServiceDesk
  • BitSightSecurityRatings

Be sure to check the documentation of the connectors to find out more about them from the Power Query Connectors reference .

Data Pipeline

We’re excited to announce new connectors are available in your Data Factory data pipelines!

In your data pipeline, you can now create a new connection to your Amazon S3 Compatible data source to copy, extract, and transform your data.

sql server reporting services gantt chart

You can also now connect to your Amazon S3 , Amazon S3 Compatible , or Google Cloud Storage data destinations.

sql server reporting services gantt chart

For more information on data pipeline connectors, please read Data pipeline connectors in Microsoft Fabric – Microsoft Fabric | Microsoft Learn.

Related blog posts

Microsoft fabric december 2023 update.

Welcome to the December 2023 update. We have lots of features this month including More styling options for column and bar charts, calculating distinct counts in Power BI running reports on KQL Databases, Changes to workspace retention settings in Fabric and Power BI, and many more.

Microsoft Fabric November 2023 update

Welcome to the November 2023 update.   We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic model scale-out, and many more. Continue reading for more details on our new features!    Contents Core Microsoft Fabric User API Power BI Reporting Button … Continue reading “Microsoft Fabric November 2023 update”

SQLServerCentral Article

Generating charts in SQL Server Reporting Services

Sunil Chandurkar , 2010-02-01

Introduction

We often need to present the report data in graphical format, specially when we develop reports for business users. Most common chart formats are bar / column chart or pie chart. SSRS is a widely used reporting service and/or tool to develop and render reports into various business applications. In this article we will develop a simple report using the report wizard (I will publish another article to display creating rich reports without using wizard) to see how to represent the report data in graphical format using chart. Our report will display all employees along with their department name in tabular format and chart will display department wise allocation of total number of employees.

Data Preparation

Before we proceed to develop a report file (.rdl) we will first create the data to display on report. For simplicity and easy understanding we will take commonly used example of Employee and Department tables. Let's first create the tables tblEmpReportData and tblDeptReportData for storing employee details and department details respectively. (I am creating these tables in tempdb database)

Lets insert the data into tblDeptReportData and tblEmpReportData tables respectively.

Lest run following query and test the output. The output of the query will be displayed on report in tabular format.

We are done with basic data preparation. We can move ahead to create a report definition file which will display the desired report.

Setup Report Project

To create a report file we will create a report server project. Go to Start -> Programs -> SQL Server 2005 and click 'SQL Server Business Intelligence Development Studio'. (I have mentioned the path on Windows XP in classic style view. On your machine the link may be situated at some other place).

Once MS Visual Studio is opened, click new Project and select Report Server Project as shown in below image.

Once the project is created first step is to create a data source for our report. In solution explorer right click on shared data source and click 'Add new Data Source'. Provide your database connection string, give a name to datasource (dsReportData in this example) and click OK. The data source should appear as below:

Our next step is to add a report file to our project. Right click on 'Reports' and click 'Add new Report'. A dialog will appear to select data source for the report. Select our shared data source ' dsReportData ' in the dropdown. (We can have multiple datasource in a single project and for a single report)

Now click 'Next'

Building Actual Report

Next thing is to provide query for our report to fetch the data. We can provide inline query string i.e. direct select query or we can provide a Stored Procedure name which while return us the data. In this example we will use direct query to get employee details.

We have our query which we used to test output after creating the tables.

Copy this query and paste in query string box as displayed below:

Click 'Next' two times. Select all values in 'Available fields' at left side and add them to 'Details' section at right side.

Click Next two times. Provide a name to your report (RptChart in this example) and click Finish. Entire thing should look like as below:

Update the table captions to Employee Name, Salary and Department to be more appropriate.

Adding Chart

Expand the report pane by dragging the bottom line and add a chart control from toolbox in empty area.

Lets now define Chart properties. Right click on chart and click 'Properties'

Provide Name and Title to the chart in 'General' tab.

Setup chart data.

Click on Data Tab and select dataset name. Then click 'Add' against Values section. Select '=Count(Fields!EmpName.Value)' in values dropdown. Delete anything displayed in Series Label field.

Then click 'Add' against Category groups section. Select '=Fields!DeptName.Value' in expression. Click 'Ok'

Go to 'Legend' tab and uncheck 'Show Legend' checkbox. Click 'OK' to close chart property dialog.

Now we have our basic report ready to run. Click on preview tab to see how report looks like.

Enhancing the Chart a little more

We developed a simple chart in a report. Lets enhance it further by adding captions on axis and providing legends. Switch to layout view and click on chart's graphical area. Three sections will appear as below.

From Datasets window drag DeptName and drop it in 'Series Fields' section at right. Then open chart properties do following steps

  • Go to 'Legend' tab. Check 'Show Legend' checkbox.
  • On X Axis tab type 'Departments' in title field
  • On Y axis tab type 'No of Employees' in title field.
  • Click ok to close properties dialog box.
  • Save report file and click 'Preview'

Our chart report is ready as below:

Here I have shown a step by step way to create charts on report developed using SSRS. We can further add expressions and formulas over chart to generate its display based on specific conditions like we can display only those departments where number of employees in more than 3 etc. We have different types of charts such as line chart, bar chart, bubble chart etc. The same can be exported to PDF and excel to name a few. My focus in this article was to create a chart for report data. I am not going to show how to setup a report server and deploy the reports on the server. Though I have not provided much attention towards report layout I leave it to readers to explore it.

2.68 ( 19 )

Log in or register to rate

You rated this post out of 5. Change rating

  • Reporting Services (SSRS)

Join the discussion and add your comment

Related content

Get started with chart development in reporting services 2008.

  • by Additional Articles

With Reporting Services 2008, it is now much easier to produce charts from data in SQL Server, and the variety of charts seems almost limitless. All you need to get started is a quick step-by-step guide that tells you the basics and gets you past the stage of creating the first chart. Well, here it is.

4,411 reads

Developing Report Navigation and Drilldown

  • TechNet Blogs

This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services for Dummies, by Mark Robinson. Learn how to produce interesting navigation and drill down reporting using the basic tools provided within SQL Server 2005 Reporting Services.

2,216 reads

Building Custom Reporting Services Reports for SQL Server Management Studio

  • Database Journal

Learn how to build Custom Reports, without installing Reporting Services, using a new feature found in Microsoft Service Pack 2 (SP2) for SQL Server 2005.

4,068 reads

External Article

Using Report Parameters in SQL Server Reporting Services

  • SQL Server Performance

Report parameters assist in narrowing down a report for better analysis.

2,614 reads

Navigation Options in Reports

  • by Vasant Raj
  • SQLServerCentral.com

You can build some very complex reports in Reporting Services and longtime author Raj Vasant brings us a short tutorial on how you can implement internal navigation structures in your reports.

5,153 reads

Microsoft Power BI Blog

Power bi february 2024 feature summary.

Headshot of article author Saveen Reddy

Welcome to the Power BI February 2024 update. We’ve got a lot of great features this month. Here are some key highlights:

  • Visual calculations make it easier than ever to do calculations that were very hard or even impossible.
  • The Power BI home provides a centralized location for all your Power BI desktop activities.
  • Fabric Copilot for Power BI can now add measure descriptions to your semantic model measures.
  • The Power BI add in now supports shareable links to make it easier for people to consume reports.
  • The new Explore feature gives you a better understanding of what’s in the data you’re exploring.

Fabric Community Conference

Join us at the Microsoft Fabric Community Conference the ultimate Microsoft Data & AI learning event, on March 26-28, 2024, at the MGM Grand, Las Vegas. With over 150 sessions for everyone who works with Power BI, Microsoft Fabric, SQL, Azure AI, and Purview , the conference promises a rich learning experience.

This is a unique opportunity to meet the Microsoft product teams building these technologies, the customers betting their businesses on them, and the partners that are at the forefront of deployment and adoption. Engage with this vibrant community, learn from their real-world experiences, stay abreast of the latest developments.

Please note that this event is in-person only. Sessions will not be recorded, streamed or made available for on-demand consumption.

Register today using code MSCUST for an exclusive discount ! Need help convincing your boss to attend? No problem!  Use this letter  to share with your boss about this unforgettable opportunity.

sql server reporting services gantt chart

  • Version number: v: 2.126.927.0
  • Date published: 02/16/2024

sql server reporting services gantt chart

On-object Interaction Updates

  • Enhanced Reference Layer in Power BI Azure Maps Visual 

Data connectivity

Certified connectors updates, storytelling in powerpoint – replace report urls with shareable links in power bi add-in, data overview in explore, directquery connections update, shared device mode is now ga, power bi custom visuals new local storage api, on-object interaction support for custom visuals, tmdl in power bi desktop developer mode, editor’s pick of the quarter, new visuals in appsource, multiple sparklines, rose donut pie chart by powerviz, xviz gantt chart by lumel, control chart xmr by nova silva, drill down graph pro, more users can now collaborate with protected pbix in power bi desktop.

Visual calculations 

A new way of doing calculations has arrived! You can now add calculations directly on your visual using visual calculations, which are DAX calculations that are defined and executed directly on a visual. A calculation can refer to any data in the visual, including columns, measures, or other visual calculations. This approach removes the complexity of the semantic model and simplifies the process of writing DAX. You can use visual calculations to complete common business calculations such as running sums or moving averages. Visual calculations make it easy to do calculations that were previously very hard or even almost impossible to do.

To use visual calculations while in preview, you need to enable it in Options and Settings  ➡️  Options  ➡️  Preview features . Select visual calculations and select OK . Visual calculations will be enabled after Desktop is restarted.

To add a visual calculation, you first need to select a visual. Next, select the New calculation button in the ribbon:

The new calculation button is shown on the Home tab of the ribbon in Power BI Desktop in the Calculations group.

To add a visual calculation, type the expression in the formula bar in the visual calculations edit mode that opens. For example, in a visual that contains Sales Amount and Total Product Cost by Fiscal Year , you can add a visual calculation that calculates the profit for each year by simply typing: Profit = [Sales Amount] – [Total Product Cost].

The visual matrix is updated as you add visual calculations using in the formula bar. New visual calculations are added as columns to the visual matrix.

Additionally, you can easily add a running sum of profit by writing:

Here is a visual with the two visual calculations we have just created:

A screenshot of a graph Description automatically generated

You can use many existing DAX functions in visual calculations. Functions specific to visual calculations are also available, such as RUNNINGSUM , PREVIOUS and MOVINGAVERAGE . Using these and other functions, visual calculations are much easier to read, write and maintain than the current DAX required.

We are only just getting started with this preview. There is a lot more that we have planned, so please stay tuned for updates in future releases. However, we invite you to jump in now!

For more information, read the dedicated blog post and documentation . Please try the preview today and let us know what you think .

Dynamic subscriptions for Power BI reports

Dynamic per recipient subscriptions is now available in Preview for Power BI reports! Like dynamic subscriptions for paginated reports , you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription.

Imagine you have a report that includes sales data for your entire team. You want to schedule an email subscription that sends out a PDF copy of this report to each salesperson on a weekly basis, with the report filtered to only show their sales results.

This can now be done by connecting to a semantic model (previously Power BI dataset) that defines the mapping between recipients and respective filter values. When it’s time to send out the report, the latest data available in your semantic model will determine which employees should receive a report in their inbox, and with what filter values applied.

A screenshot of a computer New dynamic subscription, select and filter data.

See the documentation for dynamic subscriptions here.

This February release we added multi-visual container format support ! Previously, when multi-selecting across different visual types, the format pane did not support any options for formatting the visuals. Now, when multi-selecting different visuals, we’ve added formatting support for container formatting such as changing the size, background color, adding a shadow or turning on/off titles in bulk.

When multi-selecting different visual types (e.g. a line chart and bar chart):

A screenshot of a graph, Visualizations. Order Quantity by Year, Sales by Category.

We’ve also added the ability to format a visual’s container size and position even if it’s empty:

A screenshot of a graph, Visualizations. Select or drag fields to populate the visual.

This month we also bring you a handful of quality improvements to the on-object experience:

  • Bug fix : when working with a non-visual (text box, button, image, shape) the build pane accidentally closing automatically. The build pane now stays open unless explicitly closed regardless of selected item type.
  • Bug fix : style bug where the build pane was showing 5 icons across instead of the usual 6 has been fixed.
  • Bug fix : in some cases, the data flyout was extending beyond the window size making the search box hard to use, this has now been fixed.
  • Enhancement : When choosing a field using the data flyout – you can now click anywhere on the name, not just the checkbox next to it to select the field.

A screenshot of a computer, Data selecting Order Quantity.

5.Enhancement : If replacing a field in a visual that does not use an aggregation or date hierarchy (other dropdowns are disabled), we auto open the data dropdown to save an extra click.

A screenshot of a graph, Data selecting Category.

Power BI Home in Desktop is Enabled by Default  

We are excited to announce the new and improved Power BI Home as the default experience! The Power BI Home has been redesigned to provide a centralized and familiar location for all your Power BI activities within the desktop application. Our aim is to enhance your productivity and make it easier to discover and consume content.

With Power BI Home, you no longer need to navigate through multiple menus or tabs to access your files and reports. This intuitive interface serves as a hub, like other popular office products, where you can effortlessly manage your reports, all from a single location.

Whether you’re a seasoned Power BI user or new to the platform, Power BI Home ensures a consistent and seamless experience across all your Power BI activities.

Now, you can:

  • Initiate a new report directly from the new home screen.
  • Access reports from recommendations that we have curated.
  • Locate your most recent reports through the Quick Access lists.

A screenshot of a computer abilities within the new home screen.

Please continue to submit your feedback directly in the comments of this blog post or in our feedback forum .

Enhanced Reference Layer in Power BI Azure Maps Visual

We’re excited to introduce a significant enhancement to the Power BI Azure Maps visual reference layer feature. In response to valuable user feedback and in alignment with evolving industry standards, we have expanded the capabilities of the reference layer. Now, in addition to supporting the existing GeoJSON format, users can also utilize KML (Keyhole Markup Language) and WKT (Well-Known Text) formats.

We’re also adding URL as a data source alongside file upload. This addition offers users even more flexibility and convenience in importing spatial data into Power BI. Whether your data resides in GeoJSON, KML, WKT, or through a URL link, the Power BI Azure Maps visual seamlessly integrates these formats, ensuring a comprehensive and versatile geospatial analysis experience.

Measure descriptions with Copilot

Add descriptions to your semantic model measures with Fabric Copilot for Power BI! People building reports from your semantic model can see the name and description of your measures, making the description property essential documentation. And Fabric Copilot is here to help!

A screenshot of a computer Description automatically generated

Streamline your semantic model documentation by creating measure descriptions with Copilot .

1. Click on the model measure in the Data pane of Model view to see the measure properties .

2. Click on the Create with Copilot (preview) button under the Description textbox.

3. Review the measure description from Copilot, then click Keep it .

4. Now the measure description is in the Description box. Fine tune the description, as needed.

5. You update the measure later? No worries, just click the button again when you need the description updated!

Try this out today and let us know what you think! Get started today by turning on this public preview feature in Options > Preview features and learning more about how to get access to Fabric Copilot for Power BI on your tenant at https://learn.microsoft.com/power-bi/create-reports/copilot-introduction#copilot-requirements .

DAX query view improvements  

We released the public preview of DAX query view in November 2023, and in this release, we made the following improvements:

A screenshot of a computer, Boolean values are now showing in the Results grid.

  • A share feedback link has been added in Options > Preview features. We would love to hear your feedback on DAX query view!
  • A bug causing active query tab to stop being highlighted is fixed.
  • A bug with close brackets of a nested IFs DAX formula is fixed.

And we have released additional INFO DAX functions.

  • INFO.CHANGEDPROPERTIES()
  • INFO.EXCLUDEDARTIFACTS()
  • INFO.FUNCTIONS()
  • INFO.LINGUISTICMETADATA()

A screenshot of a computer, we have released additional INFO DAX functions.

Learn more about DAX query view at https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view .

SingleStore, we’re thrilled to inform you that our connector has now officially moved out of beta. We want to express our gratitude for your valuable feedback and for being an essential part of our beta journey. Your insights have played a crucial role in shaping the enhancements we’ve made.

This upgrade comes with an exciting new feature – you can now cancel running queries, hassle-free. No more queries running in the background after you refresh the UI/visual or navigate across the pages in the report.

Our team is dedicated to continuously improving and adding even more useful features to enhance your experience. Thank you for your ongoing support, and we can’t wait to continue providing you with top-notch features that elevate your data connectivity and reporting capabilities.

When you add the Power BI add-in to a presentation, you can pick a report suggested to you or paste a link to a specific report.

When you paste a standard report link (the URL copied from the browser address bar), and if sharable links are enabled for your organization and allowed for this report, you have re-share permissions to this report, Power BI add-in can replace the link you pasted with shareable link. In that case you will see a checkbox added below the report URL that offers you automatic access to this report. Just mark this checkbox and Power BI add-in will create a shareable link for you.

Using a sharable link ensures that other users viewing the presentation have the required permission to see the report, and do not need to request access when viewing the presentation.

A screenshot of a computer, Using a sharable link ensures that other users viewing the presentation have the required permission to see the report, and do not need to request access when viewing the presentation.

Have you tried out the new Explore feature yet? This month we added a data overview feature to Explore that allows you to get the “gist” of what your data is all about. Powered by Copilot, data overview gives you a summary of what’s contained in the data you’re exploring and highlights some interesting tidbits to get you started. Let us know what you think!

A screenshot of a computer, Powered by Copilot, data overview gives you a summary of what’s contained in the data you’re exploring and highlights some interesting tidbits to get you started.

Maximum connections per data source  is a setting to configure the maximum number of connections DirectQuery opens for each underlying data source. This controls the maximum number of queries that can be executed concurrently against each data source and is configurable per semantic model.

We recently updated the upper limit of the number of concurrent Direct Query connections allowed per semantic model. The updated limits for each SKU are listed in the table below.

The upper limit for Power BI PPU is 100 active connections. Note that there is no change to the Power BI Pro and Report Server limits and the default maximum value remains as 10 concurrent connections.

Introduced last September, shared device mode is now generally available! With shared device mode, organizations can safely deploy the Power BI mobile app across their pool of shared devices.  Check it out !

This API allows Custom Visuals to store data directly in the local browser. Data stored locally is more secure and improves the performance of web apps. The API will be controlled by a global admin setting. Learn more about the API.

Our February release introduces the support of the new on-object interaction. This enhancement allows users to build and customize visuals directly on the visual in Power BI Desktop. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text.

The primary objective of Power BI Desktop developer mode is to provide friendly source control and co-development experience. With this objective in mind, you can now save your Power BI Project files (PBIP) using  Tabular Model Definition Language (TMDL)  format. TMDL has been designed from the ground up to be human-friendly, facilitating not only readability but also easy editing in any text editor. This represents a substantial enhancement for source control and collaborative development experiences, particularly when dealing with complex file diffs.  

Saving as a PBIP using TMDL is currently in preview. Before giving it a try, you must first enable this feature in Preview features: go to  File  >  Options and settings  >  Options  >  Preview features  and check the box next to “Store semantic model using TMDL format”.  

After enabling the preview feature, when saving as PBIP, your semantic model will be saved as a TMDL folder named “\definition” with separate files for each table, perspective, role, culture:  

After enabling the preview feature, when saving as PBIP, your semantic model will be saved as a TMDL folder named “\definition” with separate files for each table, perspective, role, culture: 

You can also upgrade existent PBIP files to TMDL , by just opening them and choosing “Upgrade” when you save:  

You can also upgrade existent PBIP files to TMDL, by just opening them and choosing “Upgrade” when you save: 

By default, Fabric Git Integration will still use Tabular Model Scripting Language (TMSL) to export the semantic model during the Public Preview. However, if the semantic model is imported into Fabric using TMDL, then Fabric Git Integration will export the definition into Git using TMDL in the event of any semantic model changes in the service.  

Learn more about TMDL in Power BI Project files  here .  

Visualizations

  • Inforiver Analytics+ (Charts+Cards+Tables)
  • Inforiver Premium Matrix / Table
  • Drill Down Donut PRO (Filter) by ZoomCharts
  • Date Picker
  • Enlighten Aquarium
  • Deneb: Declarative Visualization in Power BI
  • Comment – Dynamics 365 Finance business performance planning
  • Reporting – Dynamics 365 Finance business performance planning
  • Variance – Dynamics 365 Finance business performance planning
  • Matrix planning – Dynamics 365 Finance business performance planning
  • Copy – Dynamics 365 Finance business performance planning
  • Table edit – Dynamics 365 Finance business performance planning
  • Graphical planning – Dynamics 365 Finance business performance planning
  • Waterfall-Visual-Extended
  • Processifier Process Mining
  • flashbi fantail
  • Map by Squillion
  • Charticulator Visual Community (View)

New features were added to Multiple Sparklines on Oct 23

  • When you double click a line chart, it will zoom in to screen size of visual and you can then compare it with any other line chart in that column.
  • You can use different colors for each line chart in a field/column.
  • You can insert ratings with bands.
  • You can add beeswarm / distribution microchart.

A screenshot of a graph New features were added to Multiple Sparklines on Oct 23

Once you double click the line chart, it zooms in to the visual size. You can then compare it with another line chart in the same column. This is shown below:

A graph with purple lines Once you double click the line chart, it zooms in to the visual size. You can then compare it with another line chart in the same column.

Download this visual from APPSOURCE

For more information visit https://www.excelnaccess.com/sparklines/

or contact [email protected]

Rose/Donut/Pie Chart is a powerful visual that lets you build four types of charts – a rose, a rose donut, a donut, and a pie chart. These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison.

Key Features:

  • Chart Options: Rose, donut, pie charts with style customization.
  • Data Colors: Choose from 30+ palettes, including color-blind mode.
  • Fill Patterns: Apply patterns or use custom images.
  • Smart Labels: Improve readability with data and leaf labels.
  • Arc Customization: Easily adjust arc radius, padding, and stroke.
  • Ranking: Filter Top/Bottom N, show others intelligently.
  • Center Circle: Multiple layers, text, icons, and images in the center.
  • Mouseover Text: Display dynamic details when hovering over arcs.
  • Image Labels: Integrate dynamic image URLs for enhanced visuals.
  • Conditional Formatting: Detect outliers and set smart rules for measures/categories.

Other features included are annotation, grid view, show condition, and accessibility support.

Business Use Cases: Finance, Healthcare, E-commerce, Education, Customer Demographics

🔗 Try Rose/Donut/Pie Chart for FREE from AppSource

📊 Check out all features of the visual: Demo file

📃 Step-by-step instructions: Documentation

💡 YouTube Video: Video Link

📍 Learn more about visuals: https://powerviz.ai/

✅ Follow Powerviz : https://lnkd.in/gN_9Sa6U

A screenshot of a chart Rose/Donut/Pie Chart is a powerful visual that lets you build four types of charts - a rose, a rose donut, a donut, and a pie chart. These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison.

xViz Gantt Chart by Lumel is a Microsoft Power BI Certified Visual. As the most feature rich Gantt in Power BI – it is widely used across most Fortune 500 companies world-wide.

Why Large Enterprises Choose xViz Gantt Chart:

Real-time Alerts for Project Managers: Leverage Conditional Formatting to receive color-coded alerts and status flags, ensuring timely awareness of schedule delays or progress issues.

Visualize Task Dependencies: Easily identify causes of delays with the ability to plot task dependencies using connectors within the roadmap view.

Adaptable for Different Users: From Stakeholders tracking yearly progress to Project Managers analysing monthly views and Developers scrutinizing smaller time grains with flexibility across three distinct timeline levels.

Strategic Planning with Reference Lines and Ranges: Utilize Reference Lines and Ranges to mark crucial dates, holidays, sprints, or deadlines across projects.

Customization Galore:   Wide range of customizable options, including adjustable timeline limits, selectable week start days, and indentation customization for ragged hierarchies.

Hassle-Free Licensing:   The visual is free for use in Power BI Desktop. For sharing & collaborating on Power BI service, the licenses can be purchased directly from Microsoft AppSource.

A screenshot of a computer

Try xViz Gantt Chart today after watching the 2-minute video highlights.

Years ago, Stacey Barr introduced us to the magic of Control Charts. Magic it is, because it allows everyone to split their temporal data in two: random noise and real signals. And we all are looking for real signals, and don’t want to be distracted by random noise.

In our last release of the Control Chart XmR we have added several new features to make it even easier to find real signals and ignore random noise in your data.

First, we added a feature to allow any report consumer to override the applied rules. This allows everyone to analyze the effects of one specific rule or set of rules.

A screenshot of a computer First, we added a feature to allow any report consumer to override the applied rules. This allows everyone to analyze the effects of one specific rule or set of rules.

Several customers asked for a possibility to download the calculated values from the visual. Now you can download all values calculated by the Control Chart XmR, like: LCL, CL, UCL, sigmas and signals.

Don’t hesitate and try the new Control Chart XmR now on your own data by downloading it from the AppSource . All features are available for free to evaluate this visual within Power BI Desktop.

Questions or remarks? Visit us at: https://visuals.novasilva.com/ .

Drill Down Graph PRO lets you create elegant and user-friendly graphs to represent complex relationships between nodes. It’s ideal for both small and large network graphs and offers advanced features like cross-chart filtering and vast customization options. You can create hierarchies and explore them using this visual’s intuitive interactions.

Main features include:

  • Multiple layout options – dynamic, hierarchical, and radial
  • Focus nodes mode – for gradual exploration of graphs.
  • Customization options – choose colors, shapes, images, and labels.
  • Bidirectional links – show reciprocal relationships between nodes.
  • Touch device support – explore your data anywhere.

Popular use cases:

  • IT – asset management, IT infrastructure, IoT monitoring
  • Logistics – fleet management, stock management, parcel tracking
  • Sales & Marketing – community detection, account management, web analytics

ZoomCharts Drill Down Visuals are known for interactive drilldowns, smooth animations, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu. Use them to create visually appealing and intuitive reports that business users will love on any device.

Get Drill Down Graph PRO from AppSource!

Learn more about Drill Down Graph PRO by ZoomCharts.

A screenshot of a computer ZoomCharts Drill Down Visuals are known for interactive drilldowns, smooth animations, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu. Use them to create visually appealing and intuitive reports that business users will love on any device.

Have you ever wondered how to collaborate with your colleagues on sensitive data without compromising its security? Do you want to learn how to use Microsoft Purview Information Protection sensitivity labels to protect your data ?

If so, you’re in the right place! We’ll show you how to use sensitivity labels with protection to encrypt and protect your data, and how to enable more users to edit and republish encrypted PBIX files. By the end of this article, you’ll be able to collaborate more securely with your data in Power BI.

Protecting your data with Microsoft Purview

Compliance admins in your organization can use Microsoft Purview Information Protection  sensitivity labels  to manage their org’s sensitive data across different apps and services and meet regulatory and compliance requirements.

They define file protection policies for the sensitivity labels, which result in files being encrypted when such labels are applied, allowing only authorized users to open and edit these files in Office apps and Power BI Desktop.

Sensitivity labels are widely adopted by enterprises today and used to label and protect content in  Microsoft 365  apps such as Excel, PowerPoint, Word, and Outlook, and now in Power BI and Fabric as well.

All you have to do is enable Information Protection in Microsoft Fabric’s Admin Portal and let the labels do the rest.

A screenshot of a computer All you have to do is enable Information Protection in Microsoft Fabric’s Admin Portal and let the labels do the rest.

How Power BI Desktop enforces sensitivity label protection

In Power BI Desktop , we enforce label protection on PBIX files. To open a PBIX file, you either must be the label issuer or have one of the following usage rights .

These usage rights are elevated permissions, as they grant permission to change the sensitivity label. Because Power BI and Office apps use the same label policies, compliance admins may prefer not to grant these usage rights for Highly confidential labels. This might block you from collaborating with your colleagues when you’re sharing or downloading Power BI reports and trying to open them in the desktop app.

Collaborating and keeping label protection on PBIX files

By enabling “ Increase the number of users who can edit and republish encrypted PBIX files (preview) ” in your tenant, users that have been assigned with all of the following usage rights should be able to open, edit, and republish the protected PBIX file to the Power BI service:

  • View Content (VIEW)
  • Edit Content (DOCEDIT)
  • Save (EDIT)
  • Copy and extract content (EXTRACT)
  • Allow Macros (OBJMODEL)

Thus, users who were once restricted can now collaborate with protected files, while keeping protection consistent with the organizational policy.

Note: These usage rights are a sub-set of the “Co-Author” permissions preset in Microsoft Purview compliance center.

What are the restrictions and why?

In order to align with compliance requirements, users with these usage rights are lightly restricted while editing a protected PBIX file.

No exporting to unsupported formats –The user won’t be able to export to formats that don’t support sensitivity labels, such as CSV files.

A screenshot of a computer In order to align with compliance requirements, users with these usage rights are lightly restricted while editing a protected PBIX file. No exporting to unsupported formats –The user won’t be able to export to formats that don’t support sensitivity labels, such as CSV files.

No label change – The user can’t change the label on the PBIX file.

A screenshot of a computer No label change - The user can't change the label on the PBIX file.

Republishing to the original workspace only

Republishing to the original workspace only

Why restrict republishing into the original workspace only?

To remain compliant, we must keep users from gaining more permissions, including Power BI permissions (i.e., Read, Write, Reshare and Build). Meaning that a user who wishes to publish should not be able to publish to a workspace that might grant them additional permissions through Workspace roles.

Additionally, this feature is meant for collaborating and sharing items that are more restricted than usual, and confidential data is usually managed in a dedicated workspace. This restriction will prevent users from publishing confidential data across the tenant.

Side note: The file must be published at least once for other users to be able to republish it to that specific workspace. If the file has not yet been published, then the latest label issuer (the one who set the protected label) or a user with sufficient usage rights must publish it and then share the file with the other editors.

How to enable it

Prerequisite: The compliance admin must assign you and your colleagues the proper permissions for that sensitivity label.

Next, Fabric/Power BI admins must enable the feature in Admin Portal > Information protection > Increase the number of users who can edit and republish encrypted PBIX files (preview).

In Power BI Desktop, users who would like to open and edit protected PBIX files must enable the feature by opening File > Options and settings > Options > Preview feature > Less elevated user support.

Final words

With this new feature, users can now collaborate more easily with other users when working on confidential data in Power BI Desktop, without any loss of protection along the way.

That is all for this month! Please continue sending us your feedback and do not forget to vote for other features that you would like to see in Power BI! We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store,  please leave us a review .

Also, don’t forget to vote on your favorite feature this month on our community website. 

As always, keep voting on  Ideas  to help us determine what to build next. We are looking forward to hearing from you!

  • Microsoft Fabric
  • visual calculations

Sign up for the Power BI Newsletter

Sign up below to get the latest from Power BI, direct to your inbox!

I would like to receive the Power BI newsletter. Privacy Statement.

Participation requires transferring your personal data to other countries in which Microsoft operates, including the United States. By submitting this form, you agree to the transfer of your data outside of China. Privacy Statement .

IMAGES

  1. sql server

    sql server reporting services gantt chart

  2. Gantt (Range) chart with multiple events per row

    sql server reporting services gantt chart

  3. sql server

    sql server reporting services gantt chart

  4. SQL Server + ASP .NET Core 6 MVC + DlhSoft Gantt charts = success

    sql server reporting services gantt chart

  5. sql server

    sql server reporting services gantt chart

  6. Gantt Chart: How To Effectively Plan And Manage Your Projects

    sql server reporting services gantt chart

VIDEO

  1. Publishing SQL Server 2008 R2 Reporting Services Reports

  2. SQLServer Reporting Services Part 2

  3. Foglight

  4. Developing a Simple SQL Server 2008 Reporting Services Report

  5. How to Configure Reporting Services on Windows Cluster for High Availability

  6. Day 2

COMMENTS

  1. How to Customize Gantt Chart in SQL Server Reporting Services (SSRS

    SQL Server Reporting Services (SSRS) is a versatile reporting platform that provides robust capabilities for building custom reports, including Gantt charts. Using SSRS, you can connect to data sources, create reports, and customize report layouts and formatting.

  2. How to create a Gantt Chart or Progress bar inside a Table in SSRS

    Step 1: First create a new data source. Step 2: Before creating a data set, we need to write a Fetch XML query that created the data we're going to work with. Fetch XML Query: <fetch version="1.0″ output-format="xml-platform" mapping="logical" distinct="false"> <entity name="milestone"> <attribute name="createdon" /> <attribute name="item" />

  3. Use Paginated Reports to Create a Gantt Chart

    A Gantt chart is a running list of activities with the duration for each displayed as a horizontal bar depicting the beginning and ending day along a horizontal scale. The challenge is that this is not a standard chart type in either Power BI or SSRS/Paginated Reports.

  4. SQL Server Reporting Services Range Charts

    You have four choices for range chart types: 1) range chart 2) column range chart 3) bar range chart 4) smooth range chart. Let us get started with an example; we will use the high and low temperatures for two cities in the US, Westerville, OH and Kennesaw, GA. A snippet of the dataset is displayed below.

  5. Report with a Gantt chart

    1 Sign in to vote Hi pscorca, According to your description, you want to create a gantt chart. In ssrs 2012, we can use Range Bar chart to achieve your goal. Please refer to the following steps: Define a data set for the report. On the View menu, click Toolbox.

  6. Range charts in a paginated report (Report Builder)

    Range charts are often used to graph data that contains minimum and maximum values for each category group in the dataset. Displaying markers on each data point is not supported on the range chart. Like the area chart, in a plain range chart, if the values in multiple series are similar, the series will overlap.

  7. sql server

    1 Answer Sorted by: 5 I am not aware of any third party plug ins (Surprisingly). However there is an excellent article on this on SQL Server Central: http://www.sqlservercentral.com/articles/Reporting+Services+ (SSRS)/Santa+gets+an+RDL+present/61782/

  8. Charts in a paginated report

    SQL Server Reporting Services Charts in a paginated report (Report Builder) Article 03/21/2023 10 contributors Feedback In this article Designing a Chart How a Chart is like a Matrix Adding Data to the Chart Category and Series Groups in a Chart Show 5 more

  9. SQL Server Reporting Services Charts Tips

    Distribution Analysis using a SQL Server Reporting Services Box Plot Chart. Siddharth Mehta. All Tips. Embed Pie Charts, Manage Outliers and Display Reports on a Mobile Device with SQL Server Reporting Services. Scott Murray. All Tips. Getting Started with Data Bars in SQL Server 2008 R2 Reporting Services. Ray Barley.

  10. Gantt charting for the holidays

    Gantt charting for the holidays David Leibowitz, 2007-12-21 Gantt charts in SSRS aren't included in the 2005 release. You can purchase a third-party add-on, or, if you can wait, these...

  11. Trying to create a gant chart in SSRS with markers that can change

    Hey guys, For the past week I've been working on creating a functional Gantt chart from SQL data. The primary needs for this Gantt are the rectangles/bars which change width and position based on my date field; dtmobilization. ... SQL Server Reporting Services. SQL Server Reporting Services A SQL Server technology that supports the creation ...

  12. SSRS Range Bar Chart (GANTT) using SSRS 2008 R2

    Implementing SSRS Range Bar chart using SSRS 2008 R2http://pnarayanaswamy.blogspot.comLink to Part 2:http://youtu.be/x2KCLF1Q9Kw

  13. SQL Server Agent Gantt Chart in Power BI

    SQL Server Agent Gantt Chart in Power BI. In this blog post, I walk-through how to use a Power BI template file I have created that displays a Gantt chart which shows which SQL Server Agent Jobs have run and when. The purpose of the chart is to identify when jobs are overlapping and taking server resource off each other. If two or more resource ...

  14. SSRS: customize area bar chart (gantt chart)

    SSRS: customize area bar chart (gantt chart) — different colors based on expression. There I have employees names and their qualifications in my project, start date and end date of their vacations and vacations id. Then i did an area bar chart (gantt chart) based on this dataset. Lines are grouped by vacation_id, start of line is vacation ...

  15. SSRS 2022 Install, Setup and Configuration

    Choose Edition and Install. There are four edition options for SSRS. The first three do not require a Product Key: Evaluation Edition - Full edition that is good for 180 days.; Developer Edition - Full edition that can be used for non-production, e.g., test, development, training, or demonstration purposes.; Express Edition - Limited edition with fewer features than the full edition.

  16. Microsoft Fabric February 2024 Update

    These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison. Key Features: Chart Options: Rose, donut, pie charts with style customization. Data Colors: Choose from 30+ palettes, including color-blind mode.

  17. sql server

    Reporting Services Timeout with Range Chart (Gantt) Ask Question Asked 8 years, 9 months ago Modified 8 years, 9 months ago Viewed 182 times 0 I have a chart report using a range chart with SSRS 2012. It was working great until last week. Now, it won't finish running in the IDE or on the report server.

  18. Generating charts in SQL Server Reporting Services

    Setup chart Data. Click on Data Tab and select dataset name. Then click 'Add' against Values section. Select '=Count (Fields!EmpName.Value)' in values dropdown. Delete anything displayed in Series ...

  19. Power BI February 2024 Feature Summary

    These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison. Key Features: Chart Options: Rose, donut, pie charts with style customization. Data Colors: Choose from 30+ palettes, including color-blind mode.

  20. sql server

    I tried to create report stacked bar, you can see this link: How to design bar chart on SSRS. but if I create like this my report running very slowly. that's why I try to create report use range (Gantt) chart. report design: and report preview: I want to show productıon and setup phase side by side for every order but I couldn't show.