I have to return a list of Incident records.
One incident can have one or more than one problem link to it.
The problem I have is when the incident has more than one problem, it will count the incidnet more than one.
E.g.
The total number of incidents is
2Incident # Related Problems
------------- ----------------------
100 201
100 202
I would like the report to display like:
The total number of incident is
1Incident # Related Problems
------------- ----------------------
100 201, 202
I don't know how I am able to achieve it... I know an array may help, but after a few days, I still cannot figure out...
Hope you may will be able to help me out...
Thanks in advance, guys!
Cheers! :)