how to associate a concatenated field with an ID field

[ry1633]

Hi all,

I have a user request that I'm having difficulty with.     I have a query subject (database view) that has a Product Code and Serial number in, and a concatenated field of those two which I've created.  And it has a mail item ID field in it 'ML ID".  The users wants all entries of a concatenated field to be associated with the ID Field - and doesn't want to use the Grouping Tool in Query Studio or Report Studio.

In Framework Manager  there a way to displayall the product/serial (concatenated fields) associated with a given ML ID field?   This is the first I've encountered a problem like this, and I haven't really seen anything like this in the support docs.

[cognostechie]

I don't see what is the problem. This should be pretty standard. Simply put the ML ID and the concatenated field in the report and it should give you what you expect. It's like having the Date Dimension run by the Date field but  making the report to show all Months belonging to a certain Year.