Conditional formatting and hidden columns

This site is best viewed in a modern browser with JavaScript enabled.

Lutolfr

I created a report column solely for the purpose of conditionally formatting cells. It worked. I don't want the column in my report so I "Hide" the column. two things. The column is still in the report but the values are the column title and the conditional formatting doesn't work - probably because of the bogus values. Have I misread the documentation. It seems to read like this would do what I want. 1. A column could be hidden and 2. a column can be used for conditional formatting.
I then tried using a calculated column in the Assignment condition. e.g. {train_time}>7 where train_time is "SELECT from_unixtime(h.datum+25200)train_time" . I get the blank "Notice." I then changed the Assignment condition to (from_unixtime(h.datum+25200))>7 and got the blank "Notice"
Any ideas?

peterdeed

I think you should definitely be able to do what you say using both methods...in fact i just tried the same on a report and it worked

I added a column to the SQL, then added an assignment to set the color to red using the style wizard and set condition {somecolumn} > 7 and then used the Columns button to show the columns and selected comecolumn and chose to hide it. All seemed good.

Are you saying that the conditional formatting works but when you try to hide the test value it stops working as per your description? It sounds like your test column has got corrupt. Can you double check your SQL still has the column in it and it matches the column for the assignment .. if you unhide the column does it still do the formatting?

If you want to upload the xml file here or send it to me at info @ reportico.org that would be very useful

Do you know which version of reportico you are using and whether its for LAravel/joomla or standalone?

Lutolfr

Are you saying that the conditional formatting works but when you try to hide the test value it stops working as per your description? YES
Can you double check your SQL still has the column in it and it matches the column for the assignment .. YES and YES
if you unhide the column does it still do the formatting? NO. I need to remove the column and the part of the SQL and reconstruct the SQL and the column. It then works.
Do you know which version of reportico you are using and whether its for LAravel/joomla or standalone? VERSION is Powered by reportico 4.6. I have never used LAravel/joomla so assume standaslone. How can I check. Will upload xml and a word doct with screen shots

peterdeed

Apologies for not getting back to you on this.... ive been really busy... ok you are using 4.6 i did get your xml so i will look at this this week. Again apologies it should be an easy thing to fix... are you still on 4.6 or are have you moved to 6.x?

peterdeed

Ive looked into your report I cant recreate the problem.. I modified you report to use columns in my database so i got something similar and then I hid the AmPm column and the formatting was still there...

Ok so Ive saved what I did and am sending it to you in a separate email , can you do me a favour and put this version in your report project folder and try that and let me know if it works

PS I still need a little more time with Reportico 7 , although it is the same concept in both systems so i'm not sure that this will fix the issue.

Peter

Lutolfr

Your version works. I am trying to find the difference between yours and mine. I am using your version until I get a chance to find the difference(s). i have other reports to complete.

peterdeed

Thanks for the info .. let me know how you get on..