Hi Forum,   I get a dataset each day for the previous days results which on Mondays is for last Friday.   I need to add the Date that the data is for so it's usually yesterday unless it's Monday as I've stated.   I want the User to be able to add the relevant date preferably using the 'Datepicker' tool if possible.   I can't find any tips on code that would open & run the Datepicker, accept the date selected & add that Date to the table.   Any suggests welcome.     ... View more

Hi Forum - ers,   I have 2 questions about adding color properties to 2 different Custom graphs.   Firstly, how do I change the colors of the categories in a Custom Stacked Bar/Line graph?   Second, I have another Custom Bar/Line graph & I want to add a 'Green/Yellow/Red' gradient color to the background. my research tells me to add a Color Role to the Custom graph but I can't seem to get to allow me (grayed out).   Any help appreciated.   Thanks ... View more

Hi Forum,   I've had a couple of goes at creating this Stacked Bar (with 2 values) and Line combo graph but am having the following issues.   Attempt 1. I use the Customer graph builder & drag in a Bar graph & a Line Graph,  Then I try to add another measure for the bar graph so I can add the second measure to the bar stack. Issue - I can't change the Stack to normalise to 100%   Attempt 2. I drag 2 bar graphs into the design plus a Line graph, Then I format the 2 bar graphs as I need & find that I can't use a stacked bar.   Can someone give me a step by step way to achieve this?   I've looked at the User Guide but m still stuck.   Thanks   ... View more

Hi Forum I'm using a List table to display a report that contains text headings in Row 1 & Column 1, the Cells that intersect these headings need to have Formatting applied across the Rows & not the Columns. Is there a way or workaround (coding) to get the individual Rows or certain cells to apply Formatting such as Row 2 would need to be Currency, where Row 3 should be a Percentage etc. I'm finding that I get the formatting applied under the top row headings for the whole Column. I know this is how it should behave but I need to use a List table for appearances sake & I need the Data to be correct in Format. Any suggests ideas all welcome.Thanks ... View more