Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
bruceh3555
Community Beginner
bruceh3555
Community Beginner
Activity
‎Oct 21, 2018
08:57 PM
2 Upvotes
Done. Tracker
... View more
‎Mar 21, 2018
12:15 AM
It has been a known fact that in older versions of ColdFusion you could not use the CASE WHEN THEN statements inside a query of queries like you can in a SQL query to a database. Has this changed for CF2016? What about the use of IF and ELSE-IF and ELSE statements in a query of queries? We are using MS SQL Server.
... View more
‎Mar 01, 2018
12:05 PM
This is a problem that was first observed with CF8 using the cfchart tag. We have since upgraded to CF2016 and it still exists. Perhaps this is a programming error on our part but here is the issue: Trying to create a pie chart. In this case I has 4 data items. Two of them have 0 values and the other two each have a value of 50 (representing percentages). This is in response to a title to this posing as a question... How do you feel today? <cfsavecontent variable="chartContent"> <cfchart format="png" pieslicestyle="solid" width="400" height="280"> <cfchartseries type="pie"> <cfchartdata item="Terrific!" value="0"> <cfchartdata item="OK" value="50"> <cfchartdata item="Not so good" value="50"> <cfchartdata item="Terrible!" value="0"> </cfchartseries> </cfchart> </cfsavecontent> I don't know if the cfsavecontent has any bearing on this but I left it in because we use it to place the chart on a template page. This is what I get for the results: This is completely wrong! The color mapping shows one color not two. The color choice is wrong for either of the 50% values, suggesting 100% have a value of "Terrible!" Is this a bug? We have observed this with other quantity of answer options. We have seen it wrong with one of the 4 having a non-0 value but the rest are 0 values. The only work around we have found is to always place non-0 values last in the list. So changing the data order around... <cfsavecontent variable="chartContent"> <cfchart format="png" pieslicestyle="solid" width="400" height="280"> <cfchartseries type="pie"> <cfchartdata item="Terrible!" value="0"> <cfchartdata item="Terrific!" value="0"> <cfchartdata item="OK" value="50"> <cfchartdata item="Not so good" value="50"> </cfchartseries> </cfchart> </cfsavecontent> Then you get this pie chart: At least the color mapping is correct but the answer options have to be rearranged so that all 0 value data items are at the top of the list. If it was the opposite where only items at the top of the list were colored it would be better but having to rearrange the order to put non-0 data as the last in the list of cfchartdata is a terrible hack! Having incorrect color mapping as in the desired implementation shown first above is just unusable!! I'm hoping there is a simple fix to making this work but if this is a bug... Adobe, please fix ASAP! I'm also surprised no one else has found this or reported this that I can find so it gives me hope that there is a simple fix to what we are doing.
... View more
‎Feb 28, 2018
11:55 AM
Awesome!! Thank you!!
... View more
‎Feb 28, 2018
09:41 AM
Thanks very much for this response! That will likely save me hours in the future in hopefully avoiding or at least quickly mitigating the same issues you faced. I'm surprised about your decision to not go to CF2016. I have not seen those blog posts I guess, but then I wasn't in on the decision to move to it where i work. I will hope for the best now that we are on it. It seems redundant to have to format data before AND after the loop. Strange! I could see doing one or the other but not both. I'll have to test and see if that is still a requirement in CF2016. So you didn't ever use SreadsheetAddRow and construct row by row in a loop? I plan to use that approach but will switch to the cell by cell approach you use if needed. I'm hoping they have done something to improve these functions since CF10. But that may be wishful thinking. Again, a big thank you!
... View more
‎Feb 27, 2018
03:02 PM
WolfShade​ Thanks for your prompt response. I'm running CF2016. Do you have any estimate of how many rows it can create in an excel .xlsx formatted sheet? I'm hoping it can handle 100's of thousdands at least. If you have an idea of a size you recall trying, please let me know approx. record count. For formatting cells, my need is in some cases to dynamically (on a per cell basis) format the background color at least which is best handled in the row by row loop that is used to construct the data set. There is some rows/columns of the data set that will also need formatting (bold for some columns, underline for a row, etc.) I assume these formatting during and after the build won't be an issue? As for datatype I've found that when specifying datatype with the SpreadSheetAddRows (and using a query) that Numeric type does not work for me. It results in numeric values getting changed to Text in the cell and left justified. Have you seen this happen for you? I'm hoping it doesn't fail for the SpreadSheetAddRow function that builds a row at a time. I'm not quite there yet in my project.
... View more
‎Feb 27, 2018
10:23 AM
WolfShade I realize it's been a few years now but, can you please share any tips on how you achieved working with creating Excel files containing 1M records that were formatted and without issues? Did you find any impact of how you formatted cells (as you construct the rows vs after the sheet was filled with data) and in which order? What heap memory settings and other config/admin settings did you find were necessary? Any such tips would be much appreciated!
... View more
‎Jan 25, 2018
04:40 PM
Ever since we upgraded from CF8 to CF2016 (yes a big leap) all our pie charts came out tiny and showing decimal values less than 1 for all the values that used to be percents. No auto conversion to percent. No display of "%" symbol after the label values (like your 67% and 33% above). I've found this to be true for the cfchart tag in 2016 ver. Since it now does not auto-convert decimal values obtained from things like ycnt/(ycnt+ncnt) and ncnt/(ycnt+ncnt), it started showing 10-12 decimal place label values next to the pie slices ( such as 0.4856748696748) causing the pie chart area to shrink to fit it in the plot area. So I have had to go in and first multiply and round as in Round((ycnt*100)/(ycnt+ncnt)) and then use JSON string attributes to add the "%" symbol. Since Report Builder uses cfchart "under the hood" (as far as I know) it too has this problem. I've looked all over Report Builder trying to find a way to cause the display of the "%". There is a Label Format in the UI but it is set to "Percent" and yet does nothing. I changed it to "Currency" and it still did not show "$" prior to the label. How did you get "%" to show for you? Where in Report Builder did you set this?
... View more
‎Jan 25, 2018
11:37 AM
jlig, have you found a way to style charts generated within a cfreport using JSON string attributes? I have found the Chart Wizard that lets you specify Label Format to be broken. It let's you specify "Percent" or "Currency" but these symbols do not display by the values for a pie chart. I found this to be true for the regular cfchart tag. Fortunately cfchart let's you specify a plot attribute that is set to a JSON string that allows controlling the "value-box" object with properties like "text": "%v %" and "placement": "out" (or "in"), etc. <cfset plot = { "value-box": { "placement": "out", "text": "%v %", "offset-x": 2, "offset-y": 0 } }> <cfchart format="png" plot="#plot#"> <cfchartseries type= "pie" seriesLabel="My Pie"> <cfchartdata item="High" value="#hVal#"> <cfchartdata item="Low" value="#lVal#"> </cfchartseries> </cfchart> But I find no documentation for making this JSON addition to <cfreport> and the cfcharting it does internally. The attribute and properties I want to add are not so much styling which the wizard lets you do to some degree but other characteristics. Since Report Builder appears to have a bug in it's Label Format setting (at least for pie charts) I find no way to display percent or currency values with "%" or "$". I hope you have found a way to do it.
... View more
Copyright © 2025 Adobe. All rights reserved.
AdChoices