report 2D Table

[Steve Koza]

I am trying to make a summary table in Report, where I can pull specific channel values, channel properties, etc. in a summary table.  So far, I can only display an entire channel, a single value over and over in a column, or a channel property over and over in a column.  I have structured my data in groups, where each group is a separate experiment, each experiment has a bunch of channels.  I am trying to generate a table where I can display a value from each experiment in a single column.  I can provide an example if it would help.  Thanks.

Steve

[Brad_Turpin]

Hi Steve,

Sure we can do this.  The information you want to present in the table columns, is it stored in channel values or channel properties?  If it's in channel properties, do these properties already exist (maximum/minmum) or will you need to first caluculate the property value and add it to the channels?  In either case, will the channels this information comes from have the same name in every group, or will they be in the same order in each group?  Will you want to show values from all groups in the Data Portal, or will there be some groups that don't have these channels in them?

A sampling of data sets would help,

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[Steve Koza · Accepted solution]

I was able to get a solution from the "Ask an Engineer" line.  My problem was that I was calling out a specific group number when I was coding the table columns, so it was only repeating the same value from the same column every time.  In the Script tab, I would have just used a for loop to loop over the number of groups.  The solution that was provided to me for Report was to use the "D2TabRow" variable to specify the row of the table, instead of calling out the group by number.  For example, to display the maximum value in the channel "dTemp Smooth" from the nth group in the nth row of the 2D table, I would use:

@@Str(Data.GetChannel("["+str(D2TabRow)+"]/dTemp Smooth").Properties("maximum").Value, "AutoAdj")@@

I think this solves the problem that I was having.  I'm trying to find my way up the learning curve of using the Report feature to automate my analysis and data summarization.  Report is a HUGELY powerful tool, but the coding is a little awkward to a new user.  Can you recommend any useful resources for a Report newbie?

Thanks,

Steve