How do I set a Chart Series EmptyPoint color to match the series?

Laford, Thomas 0 Reputation points
2023-09-13T14:01:59.74+00:00

I have an SSRS report (developed in VS2017) which contains a chart that is repeated once on each page of the report. When the report is run, the charts can have any number of series each time (let's say between 1 and 20) and I allow each series color to be set automatically so every series line/marker has a unique color.

If I explicitly set the EmptyPoint.Color to RED then the "EmptyPoint Average" lines are displayed but if I leave the EmptyPoint.Color as Automatic then the "EmptyPoint Average" lines are not displayed.

How can I configure the EmptyPoint.Color so it matches its series color?

SQL Server Reporting Services
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,796 questions
{count} votes

2 answers

Sort by: Most helpful
  1. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-09-14T02:14:19.6066667+00:00

    Hi @Laford, Thomas

    This is indeed strange. I did a simple test and when setting the color of the empty points to Automatic, it doesn't seem to show the color.

    I found this thread for you which simulates the color palette in an expression to solve the problem: https://stackoverflow.com/questions/39124724/automatic-color-no-color-for-empty-point-data-in-ssrs-report. Hope this helps.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya


  2. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-09-18T07:36:54.67+00:00

    Hi @Laford, Thomas

    I found this link for you: https://stackoverflow.com/questions/8290951/ssrs-line-chart-not-connecting-data-points. It uses custom code to keep sequence colors and EmptyPoint colors consistent.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya