Series Group Colors in Chart changes on page break

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Series Group Colors in Chart changes on page break

Author

Topic

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-20 : 05:36:20

Hi,

We are showing "Product bases sales" report in form of a line graph. Here each product has its own Sales line, hence we gave "Product" in SeriesGroup. We implemented page breaks - after each 16 records from Dataset.

When we view the Report, user as an option to select multiple products. Based on the number of products selected, series colors are changing:
2 products selection - No problem
3 products selection - Colors changes in cyclic order on each new page.
4 prodcuts selection - No Problem
6 ..... - Colors changes in cyclic order on each new page.
7.... - Colors changes in cyclic order on each new page
8..... - No Problem

Based on this, my understanding is ..numbers divisible by 16 will have no effect(i.e 2,4,8..)
I rechecked this by implementing page break after each 15 records, then (3,5.. etc product selection has no effect on colors)

Is there a way to avoid changing of colors for Series Items. Please provide your valuable suggestions

Thanks,
Rachitha.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 09:16:49

you mean always show series in single color on all pages?

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-20 : 10:37:14

No Visakh, you didn't got my point.
Say, i am showing sales of 3 products: prod1, prod2 and prod3
first page: prod1 - Green
Prod2 - Blue
Prod3 - Red
Second Page: Colors got changed to
Prod2 - Green
Prod3 - Blue
Prod1 - Red
We dn't want these colors to be changed for the products on each page. However, we are getting correct running totals. Now the problem is only with colors.

Let us know whether there is an option to avoid changing of colors of each product thought out the entire report.

Thanks,
Rachitha.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 11:55:14

are you using standard sql report chart control or dundas chart?

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-20 : 23:36:03

Hi, i am using standard SQL Report Chart(SSRS 2005).
"I am not using Dundas charts"

Thanks,
Rachitha.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-21 : 09:36:48

then see this

http://msdn.microsoft.com/en-us/library/aa964128.aspx

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-21 : 22:59:44

thank you Visakh..
We acheived our requirement by making page breaks based on the number of products selected. i.e i am using (=Ceiling(RowNumber(Nothing)/Parameters!product.count*10)
This solved our legend and color palett issue.

Thanks,
Rachitha.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-23 : 12:53:48

cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources