Close popover
Tom Pletzke (TomP1704)
Quest Diagnostics
Engineer, Software III
Quest Diagnostics
TomP1704 Member since 2015 7 posts
Quest Diagnostics
Posted: February 6, 2017
Last activity: February 8, 2017

Reporting Definition Issue with combining a list of values into one reporting row

I need help with something I have been struggling with for months. We have a report definition with business constraints that make it difficult to manage. The business wants only one row per case and a case can have multiple records for some fields that we are concatenating into a list during case filings so the data can be displayed on the report in a comma delimited list. My question is: What is the best way to handle situations like this and I now have something more difficult in that it requires run time results from current date. I am thinking that a function alias might solve this but I am having issues finding example of function aliases. A good example is the operators that are assigned to a case. There can be many and the business wants them to stay on one row so I am building a list at case submit to make the list so I can use that list at reporting. I don't like this solution because if forces me to keep a property just for reporting.

Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.