query with Report definition

Hi, I have a requirement that on a perticular condition,data of few columns in report definition should not come.

Is this possible,if possible can any one suggest me a way to this please

Thanks

Rupesh

@Rupesh999

I think it might be possible but maybe not from the Report Definition.

You may have to run the Report Definition and then re-work the results back to remove unexpected data.

@MarcLasserre_GCS

Thanks Marc, can you please suggest a way what need to be done since i am fresher to pega i am not having that knowledge in pega,

Thanks

Rupesh K

@Rupesh999

Your Report Definition might be returning pxResults pages on your clipboard with all the details. So you could loop on said pages with an activity to apply Property-Remove.

And then at then end of the process present the expected results on a custom SECTION.

@MarcLasserre_GCS

Hi Marc, i used fuction alias for that i can see its working fine

Thanks

Rupesh K