I have been trying to highlight values in a reporting modules data table based on the actual values of the rows in question. I have been working with dynamic data keys, and I have gotten close using this method, however when I use a dynamic data key it seems to highlight the entire column, or in another configuration every row on the table... it seems as though its basing all of my formatting on the first row of data, rather than each individual column.
Any suggestions would be helpful.
Here is a screenshot of where I placed the data key reference (the key chain code...) ... I had a few screenshots here but they weren't helpful.
I was able to get the table to format based off of the values... but no matter how I set these up, the fill color was applied to every row. If I reversed the logic , IE changed from a date > testDate, to my date < testDate... it would turn off on all rows ... Never individually.
Perspective and Reporting are two separate modules with little in common between them. Can you edit your question (and the title tags) to clarify what you're asking about? I think you can remove the database tag too as it seems irrelevant.
Add a line-break between each of your images so they don't try to wrap on the same line. They're all jammed together.
I removed all of the tags except Reporting and Scripting.
Thanks for the advice... I don't have to use the forums often... but this is one issue I have not been able to nail down. The reporting module is definitely a unique construct with regard to ignition !
I apologize, but I just figured out that the person I am helping has formatted his table incorrectly. I reformatted the table, and then went back and carried this procedure again the way I thought was correct... and this time it worked.
While working on a table for a colleague, in an attempt to format the table based on the underlying data, I came across what you see in this image... When looking at the table, it looks normal, but when working to format it I noticed that each row was a separately added Rectangle Shape that has been individually formatted for each row.
For holding the data, it seemed to be working fine, but when I tried to use this format to apply dynamic formatting using datakeys .. I was forced to apply the formatting individually to each row one at a time. In retrospect this should have been a red flag.
I redesigned a simple version of the table which only required formatting to be done in a single place: and viola! it worked seamlessly.
and Here is the formatting that I was trying to apply (In this test scenario I was only highlighting every row with a date that occurred before my testDate parameter (in this case that was set for 11/16/2024).
I put condition in the field after right clicking a selecting datakeys... It didn't require an @ symbol... and it didn't require an if then else... just the logical test... In this case "Time >testDate" (Time was the name of the field)...
