2D_Table

[damdoum]

with this Expression i get all Channels_name and all Channels_Status like this

now i want all Channel names but only with Properties Failed.


That was the first Question.
Second Question:

I want a Table with all Groups.Properties.Name and All Groups.Properties.Status.
this Expression @@Data.GetChannel(D2TabRow).Properties("name").Value@@ work only for Channels.
something like this would not work for Groups: @@Data.GetGroups(D2TabRow).Properties("name").Value@@.

Does Anyone has Tableexpressions or has some Solution 🙄. Thanx

[Dia791 · Accepted solution]

Hello.

for the second part it's easy: in your expression change "GetGroups" in "Root.ChannelGroups":

@@Data.root.channelGroups(D2TabRow).Properties("Name").Value@@

For the first, a possible way could be via "intermediate storage":

• in a code you find out, which groups have this property "failed" (e.g. in a loop over all groups)
• you either use internal variables (like R1...Rx for real numbers) or declare by yourself global variables, better as array
• assign the group numbers which fit your requirements to these variable
• for the table use the variable only, with D2TabRow as an inder 

For example, I do it with name only, and have only one group at all:

call globalDim ("gr(3)")
gr(1) = Data.Root.ChannelGroups(1).Properties("name").Value

Inside the table in the report, I use @@gr(d2TabRow)@@ as expression.

That's it.

Probably not the best way, but the working one.

Greetings,

Vassili

[damdoum]

OMG that works thank you.

But i have one more question:
in the end, I want to automatically display a table with lines of code as I explained before and it works with this @@Data.root.channelGroups(D2TabRow).Properties("Name").Value@@
for the groups 😊 .
The problem now is that when I do the Automatically increasing, I have to enter the number of rows manually or it will display only one line. Is there a way to enter it automatically?

In my exemple i gived the number 4 in the Number of Rows but i want it automatically with the max_lenght

[damdoum]

call globalDim ("number")

number = Data.Root.ChannelGroups.Count

Give the @@number@@ in number of rows 😊