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

SSRS-VS 46 Reputation points
2021-09-29T09:29:16.73+00:00

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

Table2: MEDIA_SUBCATEGORY
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:

136198-imagen.png

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,796 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-09-30T02:48:41.643+00:00

    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,
    Joy

    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.