SSRS Mobile report: Print Category bar colors depending of Circular Graphic colors

SSRS-VS 41 Reputation points

I have two datasets. The first dataset gives me the Main categories of Media from one table. The second dataset gives me the Subcategories of the previous tables from another table.
For example:

Table1: MEDIA
ID | Category

1 | Category1
2 | Category2
3 | Internet

ID | Subcategory | MEDIA_FK

1 | Newspaper | 1
2 | TV | 2
3 | Radio| 2
4 | Google | 3

Then, in my mobile report, I show the Main Category on a circular graphic (Dataset1). And the subcategories on a Category bar graphic (Dataset2).
The problem is, that the Circular Graphics gives color to each category, but the Bar graphic color is only blue. I want the bar graphic to give the subcategories the same color that their respective main categories have on the circular graphic. Like this:


How can I do that? Can I do that?
I also tried with Total Graphic Bar. But the colors has no relation with the Circular graphics, and for two Subcategories with the same Main Category, it gives two different colors.

If the colors of the bar graphics (category or total) cannot have relation with the colors of the Circular graphic, can I at least to group the subcategories by colors (two subcategories with the same main category with the same 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,370 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,471 Reputation points Microsoft Employee

    Hi @SSRS-VS
    Does your mobile report data come from Excel or Report Sever? If it comes from the report server, you could try to merge the two tables during data query, group the Subcategory in the table by Category and create a new table, and then set the color according to the group in the new table. Anyway, you may need to have a grouped table.
    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.