Dynamically set iChart pen colors at page runtime when query data changes
Query run #1 retuns rows for:
Query Run #2 returns rows for:
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
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.
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.
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.
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
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
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
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. 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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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