Proof Approval report - Pull custom field values from campaign level to the proof approval report

[NishaPatel]

Hello,

I am pulling a proof approval report. I have created a custom radio button field on the campaign level (with values Yes/No only), which I am hoping to pull into this proof approval report. I would also like to group my report by this field. Can someone help me with the instructions in text mode? I have already tried below but it doesn't seem to work:

displayname=<field_name>
valuefield=documentVersion:document:project:{"DE:<field_name"}
valueformat=HTML

Thanks,

Nisha

[SuryaLakhani]

Hi @NishaPatel ,

This should work for grouping:

group.0.displayname=<Field Name>
group.0.valueexpression={documentVersion}.{document}.{project}.{DE:<Field_Name>}
group.0.valueformat=HTML
textmode=true

If you have multiple groupings, switch "0" to the appropriate number. 

[NishaPatel]

Hi Surya,

This doesn't seem to work. I have created custom fielf on campaign level and this is a proof level reporting. I have go the field added on the report and it is working for me. But I am seeing a lot of data there. I have more than 2k records where the field is blank.

Can I add that filter and sort if the grouping is not working atleast?

Thanks,

Nisha