tough questions for expert?!? REPORT / PIVOT CHART LEGEND

B

brian0110

I have a report that is not bound, "rptTestDetail", and it contains a
pivot chart.

However, "rptTestDetail" also has text data in it from sub reports. i
am trying to make the text data the same color as the pivot chart
legend colors. Is this possible? This is my main goal.

And also, if someone has time, is it possible to replicate the legend
from the pivot chart and represent it in "rptTestDetail"? This is so I
can eliminate the original legend in the pivot chart.(ALSO BECAUSE THE
ORIGINAL LEGEND CAN GROW AND SHRINK AND I WOULD LIKE TO HAVE THE
ABILITY TO MINIPULATE IT MYSELF AND COMBINE THE SUBREPORT TEXT DATA AND
THE ORIGINAL LEGEND AS ONE)

I would really appreciate any help! Thanks


+-------------------------------------------------------------------+
|Filename: test detail.zip |
|Download: http://forums.yourdomain.com.au/attachment.php?attachmentid=607|
+-------------------------------------------------------------------+
 
P

Phil F

Just a general notion that might help. I don't entirely follow your
description of the report.

In the section of the report where you want to change the color of
something, on properties/events, create a procedure for the "OnFormat" event.
During the execution of that code, you can go where-ever and fetch the color
info and use it to color the object that is about to print.

Phil Freihofner
 
Top