ReportNet -- Lookup value based on another

[kculpepper77]

I want to do your basic look-up function on a ReportNet Report. For example, I have a list of styles as well as multiple color numbers attached to them; but I have used the minimum calc to display only one of those color numbers; now I want to display the color name that is associated with the color number. Any ideas?

Thanks.

 

[schampheleer]

I think you can do this by creating 2 subqueries. In the tabular model of your query, add two new tabular models as children. In the first child, create your query as you have done now and already include the "minimum" calc. In the second child you fetch all combinations of color numbers and names. In the parent tabular model select all the query items you need from the children and include a filter like child1.color_number = child2.color_number.

HTH,

Willem