In Report module I have two table.
For eg. Table 1 is having data of age and table 2 is having data of name. both table are in same report only.
Both are seperate table so the datakey are different for them.
I want to check the age and the change the font color of data of the second table with names.
For eg. if age is in the first row of table 1 is greater than 18 then the first row of the table 2 will be in green or else it will be some other color.
Is there a way to achieve this ?
Why not use one table with 2 columns?
because i'm not getting dataset from somewher. I have to make dataset through script
I dont see why that stops you, could you show the two tables and script?
see with script i'm generating 6 datasets.
i dont know how to combine all this data sets
we cant give more specific help without seeing the code
https://docs.inductiveautomation.com/display/DOC81/system.dataset.addColumn
Tried but not wotking this way in code throws error
If your code throws an error it doesn't mean it's not the right solution, it only means you did it wrong.
Give us more details. We can't do much with what you told us so far.
There should be PIWIP and P1StatusDataset instead.
PIWIP and P1StatusDataset are pydatasets fyi
what is the error
Vatsal, please read back through your posts and ask yourself how anyone could help with the information you have provided. If you really want help you're going to give a lot more detail. Post code - not pictures of code. Post formatted SQL queries. Explain the data structure. Show sample source data. Show a mockup of what you want it to look like. Be serious!