# Advanced Queries **URL:** \ **Category:** Uncategorized\ **Created:** [February 25, 2024, 8:52pm UTC](https://forum.manager.io/t/advanced-queries/51903 "2024-02-25T20:52:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [February 25, 2024, 8:52pm UTC](https://forum.manager.io/t/advanced-queries/51903/1 "2024-02-25T20:52:48Z")
So based on the feedback, I’ve realized the previous implementation of elevating `Advanced Search` into `Custom Reports` was not as good. In the latest version (24.2.26) it works as follows. I’m going to call the feature `Advanced Queries`. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/3/83b370cf518486f6b3f8faab3ee9cd6d0151477d.png) The reason is that it’s not always search what users are doing thus `Advanced Search` is not appropriate. And it’s not always a report that users want out of this feature so `Custom Reports` is not the right terminology either. I think `Advanced Queries` captures meaning of this feature the best. Another issue I was tackling was that when `Advanced Query` was active, the yellow box showing the definition was taking too much screen estate. The latest version will show just the name of selected advanced query. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/b/dbf94ad656fc908bb7b5511dd8172dfd4f674d6b.png) But if you click it, it will expand to full definition which you can `Edit`. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/0/e062002cb752a4f8f2c8b6f220a0dc7c7947ab2d.png) You can turn any advanced query into printable report. When advanced query is selected, there will be `Print` button at the bottom. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/1/8137543723af6bf6b5c669b36f15714893e313a4.png) Clicking `Print` button will convert data on the screen into printable report. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/d/0d49c84b8cba7a8abb729d123453b7261b1d633e.png) ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [February 25, 2024, 9:15pm UTC](https://forum.manager.io/t/advanced-queries/51903/2 "2024-02-25T21:15:46Z")
> [@lubos](#): > > Clicking `Print` button will convert data on the screen into printable report. Much better!! Please consider because of consistency with all other Print buttons in Manager to put it on top. Thank you! ---
**Author:** ![shahabb](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@shahabb](https://forum.manager.io/u/shahabb)\ **Post date:** [February 25, 2024, 9:25pm UTC](https://forum.manager.io/t/advanced-queries/51903/3 "2024-02-25T21:25:01Z")
New CustomReport/Advance queries works fine in some tabs like invoices. But on inventory tab the group by function is not working as intended. It just list the name of the groups and no balances against them nor any of the the group is clickable, kindly look into that. And by any chance the optional collapse/uncollapse function is coming to the group by feature? Like older custom reports? ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [February 26, 2024, 12:18pm UTC](https://forum.manager.io/t/advanced-queries/51903/4 "2024-02-26T12:18:54Z")
> [@shahabb](#): > > And by any chance the optional collapse/uncollapse function is coming to the group by feature? Like older custom reports? I agree with @shahabb we need collapse/uncollapse in our work. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [February 26, 2024, 8:09pm UTC](https://forum.manager.io/t/advanced-queries/51903/5 "2024-02-26T20:09:14Z")
There’s the same issue with fixing assets > [@Renamed "Advanced Search" to "Custom Reports" and making the feature look report-like](https://forum.manager.io/t/renamed-advanced-search-to-custom-reports-and-making-the-feature-look-report-like/51856/26): > > @lubos On Manager Windows server v24.2.23.1317 Fixed assets tab → Custom Reports Sort by Control account then time stamp works But if a Group by Control account is added only the control account groups are shown with no item data (equivalent to not Selecting any fields). ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [March 1, 2024, 10:36pm UTC](https://forum.manager.io/t/advanced-queries/51903/6 "2024-03-01T22:36:44Z")
This issue is resolved for me in Manager v24.02.29.1336. - In `Fixed assets`, `Advance Query` by control account now shows sub totals for `Acquisition cost`, `Depreciation` and `Book value`. - Drill down on each of these is supported enabling display of fixed asset items by control account. Thank you Lubos PS to illustrate, in a test business set up to mimic an earlier guide example With out advance query ![61 Fixed Assets](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/d/ed95bfa3de368c18dda5d2292a59b91b349746e8.jpeg) With advanced query, to group by control account ![70 Advanced query - Fixed Assets](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/5/e52d1d013d0f66aae4472806c1c556b8f33067ef.jpeg) Then drilling down on the Motor vehicle cost entry ![71 Advanced query - Fixed Assets Vehicless](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/1/d/1d0b9d860aab2152aa4679694f513369c5265749.jpeg)