Report on the fly

Is it possible with Axapta to create a report on the fly base on a query or table or else…


Yes, it is. Look at Create a report by using the Microsoft Dynamics AX auto-report wizard and other options in How to create a custom report.