question

SSRS-VS avatar image
0 Votes"
SSRS-VS asked SSRS-VS edited

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

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
imagen.png (25.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered SSRS-VS edited

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi.
The data comes from two datasets created with Report Builder. This two datasets are linked with two stored procedures stored in SSMS. In the Mobile report I just load the dataset and I link them with the graphics. By the way, in each stored procedure, the categories and subcategories are grouped because I return also a count(*). Maybe you're saying to have just one dataset with just one stored procedure/query?

0 Votes 0 ·