Has this happened to you?  You’ve spent time developing a complex query and then fields go missing.   And you wonder why.

I made this mistake several times.  So, it’s worth a blog post.  At the least, it will help me remember not to make the mistake again.

Here’s a sample report page with my query fields displayed to the left.  The report shows both Earnings and Earnings Code.

You don’t want Earnings Code on the report as your users prefer the description to the code.  Everyone knows that REG means regular hours, but codes proliferate as time goes on.

If you were like me, you just highlighted the column and hit delete.  And then wondered why the field disappeared and some of your filters blew up.


Instead, simply highlight the column and cut.   You may use the cut from the tool bar or control-x.

You’ll get a message that the asset has been copied.  The column will be gone from the report but remain in the query:

Hope this helps. 

Questions?  Leave a comment!

Want more reporting and data integration tips?   Let us know and we’ll add you to our newsletter.

Adam Jacobson

Adam is founder and president of Red Three Consulting. He has over 20 years of experience in ERP consulting and BI consulting. Adam has particular expertise in complex accounting and other multi-company and international reporting challenges. Prior to founding Red Three, Adam was a partner in United Systems Consultants where he ran its 30-person Lawson software practice. Outside of work, he serves as board member and treasurer of the Riverdale Y. When not working, he spends his time answering his son’s political questions and cycling, swimming and reading.


Leave a comment

Get tips and insights delivered to your inbox

Start a conversation with us

Call: 917-848-7284
Email: inquiries@redthree.com

Request a Consult