Dynamically set iChart pen colors at page runtime when query data changes

October 11 0
Advertisement
I have a page with an iChart (3D Bar Chart) where I am currently allowing the pen colors to set automaticlly inthe diplay template.  However, the SQL Query that supplies the data, will return a different number of rows depending on user selections.  The data is aggregated by type and could possibly return up to 7 rows, a row for each type.  As an example.....
Query run #1 retuns rows for:
Type 1
Type 3
Type 4
Type 5
Query Run #2 returns rows for:
Type 1
Type 2
Type 3
I would like to set the iChart pen colors so they would aloways be the same for each Type returned by the SQL Query....
Type 1 - blue
Type 2 - green
Type 3 - red
Type 4 - orange
Type 5 - pink
Type 6 - purple
Type 7 - black
I would like these colors to be used whether or not query returns data for a specific type or not.  Any help would be greatly appreciated
Advertisement
OK.  Assuming you are returning the color value or the type value in the Query we can do this.
First, in your Chart Template, link the value that will determine the color (either the "Color" column or the "Type" column from the query) to the Datalink Columns field on the Data Mapping tab of the Chart Template.
Then using an applet event (update event) fire a javascript function.  This function will update the pen colors of your chart dynamically.
Use document.myApplet.getChartObject().getDatalinkValue(PENNUMBER,POINTNUMBER,ATTRIBUTE) where PENNUMBER is the Pen or Row in your query, POINTNUMBER can probably be left at '1', and ATTRIBUTE is the numerical index of the datalink value (probably also 1).
This will give you either your Color value or your Type value.
From there set the PenColor of the Chart using document.myApplet.getChartObject().setPenColor(INDEX, NEWVALUE) where INDEX is the actually Pen Number (query row) and NEWVALUE is the new color.  Keep in mind the NEWVALUE is expecting a color object not an English color. 
You can create a color from an English string by using document.myApplet.createColor("blue").
Then, don't forget to update the Chart -
document.myApplet.updateChart(false).  Don't do "true" or else you'll end up in an infinite loop.
Try that out.
Dynamically set iChart pen colors at page runtime when query data changes

I have a page with an iChart (3D Bar Chart) where I am currently allowing the pen colors to set automaticlly inthe diplay template.  However, the SQL Query that supplies the data, will return a different number of rows depending on user selections. 

Y Axis label color inherits Pen color and not the default Label color.

Hi, How do I enforce my Y Axis Label to taken the default color specified in the iChart Y-Axis Label Color property instead of picking it from the Pen color selected from the legend? I have a Y-Axis Label called "Total Stock", I can very well ch

Problem dynamically setting row background color in a report

Hi guys, I want a PPR Classic SQL Report to dynamically show a background color depending on what value is stored in the column of the record. To illustrate what I've tried consider the following: 1. I created a PPR Report on DEPT (this is the report

Dynamically Set Subreport Background Color to the Same Value as Main Report Background Color

I have a report that contains a subreport.  The main report has groupings in it.  I am dynamically setting the background color of the group rows based on an expression.  That part is working fine.  The problem that I am having is that I don't know h

HP Color Laserjet 1600 cannot print in color with Pages 09

Hi, everybody! I got a huge problem for me that the HP Color Laserjet 1600 cannot print in color with Pages 09 after I upgrade to 10.6.1. It worked very well in 10.5.8. Since there is no official driver from HP website for 1600, so I used foomatic/fo

How do I change the default color in pages.

How do I change the default color in pages.  Everytime I try to copy and paste a passage, I am unable to do so because it seems that the ink is always white on white.  Sometimes I am lucky and can change it using the color box in the format bar, but

How to use AppleScript to set "character fill color" in Pages 5.2?

For Pages 5.2 on OSX 10.9.3, what is the correct applescript for changing the "character fill" of text in pages.  If you highlight text, you do this via your mouse in the inspector by clicking "style," "advanced option (the gear w

How mak an iMacro to toggle Tools Options Content Colors Allow Pages Own Colors

Every day in Firefox I go back and forth repeatedly, enabling my own System Colors, then going back to "Allow pages to choose their own colors". I've tried to create an iMacro to do this, but apparently I haven't leaned iMacros correctly, becaus

Background color in Pages 5.5.2. full screen mode

I updated to Yosemite, and my Pages updated to 5.5.2. It used to be that when I went into full screen mode in Pages, the background color was black. Now when I enter full screen mode, the background color is pale. Is there a way to change it back to

How can I change the text   color in pages

Hi , how can I change the text color in pages appSelect the text you want to change. Tap the i in the top bar. Tap Style in the top bar. Tap the Font name/size Tap Color then choose the color you want the text.Read other 7 answers

Change highlight color in pages

Hey guys and gals, Would anyone happen to know whether changing highlight color in Pages is possible, and if so - how? I searched all over and found no satifsying answers. Thank in advance! EranIt looks like the Highlight (background) color can only

Spot to Process Color in Page Maker

Hello Everyone......... Can anyone help me in changing spot colors to Process Colors in Page Maker. I'm new with this. Thanks & Regardsdouble click the color. In color options click on spot and change it to CMYKRead other 2 answers

Saving Colors in Pages

I can not figure out how to save certain colors in Pages. You can click through a variety of colors, but I do not know how to then use the same color for different parts of a layout. Is there somewhere to put in web color numbers? Am I missing someth

Displaying color pallete at runtime

Dear Readers, I want to show color pallete at runtime so, the user should be able to pick a specific color. Then i want to apply that color to an item. Thanx in advance for help. ShafiqThis might help:<br><br>    Forms Color Utility -- Color.f

Background page color in Pages

Is it possible to change de default "white" page color in Pages in word processing mode?Great, that answers my question. I'm not too impressed by the complexity of the procedure (compared to word for example), but it works.Read other 4 answers

About Line (pen) color and thickness (width) for DWG/DXF files in ECLVIEWER

Hello, sapgui 640 set  Line (pen) color and thickness (width) for DWG/DXF files in ECLVIEWER Loader Preferences, is effective for  paper A2,A3,A4 dwg file,but isn't effective for paper  A1 and extend length dwg file . this set for line(pen) color and

Color cartridge page count

Why does my color cartridge page count go from 70-75 to zero when I am only printing black?Please read this post then provide some details.  What printer model?   When printing graphics color ink is typically used instead of black to provide finer de

How Apply Paper Swatch color on page

Hi Experts I want to apply Paper Swatch color on page. I try this to set Paper Swatch color but not sucess. #target indesign var myDocument = app.documents.add(); var myPages = myDocument.pages; var myPage = myPages.item(0); var swatchclr=app.activeD

Dynamic Form componants in my jsf page?

how could i make dynamic form componant in my jsf page ,depend on user inputs or result from database or whatever , where i use sun studio creator ???you need to use the "rendered" attribute of the components... for example in your jsp put this.

Add Page n of nn, date, current user name to aReport Footer on PDF Report

Hello, I am very new to using Apex. I have a SQL Report which I can output to a PDF and works. I have a header and the contents of the report all appearing in the PDF OK. I would like to have a footer for each page which has the date & timestamp, cur