Here is my sample report for testing if desired:

Hello, I was wondering if it's possible to have an IIF statement generate more than 1 response and be comma separated? Currently I have a field called LocationType, and this column is showing multiple values using the JoinColumnContent expression. My question is for my ProjectLimits column, I wanted...

Hey Lech, I tried using both (Decimal)(Projects.Amendment_) and {(Decimal)(Projects.Amendment_)}, but it still doesn't seem to be formatting properly. As for the decimal you can see that i changed the type to decimal- doesn't that automatically make the "Amendment#" turn into 7 instead of ...

Hi Lech, please see the attached-

Also attached my sample report.

I ensured that the type of my source is changed to INT, but it still seems to be sorting by String.

I have a report where I'm trying to sort by an Amendment Number. It seems to always be sorting by string only no matter what type I set the datasource to

For some reason, the output when I sort by ascending is showing up as:

100000
11
12
13
14
15
7
8
9

Instead of:

7
8
9
11
12
13
14
15
100000

Could you take a look at the MRT file that I attached. I have tried many variations, but unable to get the JoinColumnContent expression to work for Groupheaderbands

Hi Lech, thank you for responding. That solution seemed to work for basic databands, but I'm running into issues when I use groupheaderbands. In the screenshot, I know that the first line project CC20130027 has 2 LocationTypes: "N/A" and "Hwy Segment". I am able to get both of th...

Hi Lech, I made a simple Sample report just trying to get all of my ProjectIDs, but it does not seem to be working. Could you please assist? Thank you!

Hi @Lech,

I'm having some difficulty understanding that function. If I want a list of all of the LocationTypes separated by a comma, would my function look like:

JoinColumnContent(Projects_CurrentProjectRevision_LocationDetails.LocationType, "LocationType", ",").