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