# query with Report definition

**URL:** <https://forums.pega.com/t/query-with-report-definition/1146>\
**Category:** General\
**Tags:** reporting, 8-3-1\
**Created:** [February 18, 2021, 6:07pm UTC](https://forums.pega.com/t/query-with-report-definition/1146 "2021-02-18T18:07:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rupesh999](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@Rupesh999](https://forums.pega.com/u/Rupesh999)\
**Post date:** [February 18, 2021, 6:07pm UTC](https://forums.pega.com/t/query-with-report-definition/1146/1 "2021-02-18T18:07:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![MarcLasserre\_GCS](https://avatars.discourse-cdn.com/v4/letter/m/e99b99/32.png) [@MarcLasserre\_GCS](https://forums.pega.com/u/MarcLasserre_GCS)\
**Post date:** [February 19, 2021, 8:00am UTC](https://forums.pega.com/t/query-with-report-definition/1146/2 "2021-02-19T08:00:44Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![Rupesh999](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@Rupesh999](https://forums.pega.com/u/Rupesh999)\
**Post date:** [February 19, 2021, 8:55am UTC](https://forums.pega.com/t/query-with-report-definition/1146/3 "2021-02-19T08:55:41Z")

</div>

@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

---

<div class="post-metadata">

**Author:** ![MarcLasserre\_GCS](https://avatars.discourse-cdn.com/v4/letter/m/e99b99/32.png) [@MarcLasserre\_GCS](https://forums.pega.com/u/MarcLasserre_GCS)\
**Post date:** [February 19, 2021, 9:02am UTC](https://forums.pega.com/t/query-with-report-definition/1146/4 "2021-02-19T09:02:33Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![Rupesh999](https://avatars.discourse-cdn.com/v4/letter/r/a88e57/32.png) [@Rupesh999](https://forums.pega.com/u/Rupesh999)\
**Post date:** [February 19, 2021, 11:39am UTC](https://forums.pega.com/t/query-with-report-definition/1146/5 "2021-02-19T11:39:35Z")

</div>

@MarcLasserre_GCS

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

Thanks

Rupesh K