as for background, currently our DB & Reporting Server is in one Server. Whenever i check my DB Server, the top 2 that consume the most resource is both SQL Server & Reporting Services. So here im thinking to try to move the Reporting Services to other Server.
So i have create a new server along with the SQL reporting Service. After all is ready, i goes to AX Report configuration to change the setting there. All went well. Check most of the report & most of it working fine except 1 report have a problem, which is Purchase Order Report. The report able to open but with a blank data. I have try redeploy the report, full CIL, & restart both AOS & Report Server, but still the data wont showing up. Im also comparing both my old Report Service setting on my DB server with my new Report Server & find no difference on both. Funny thing when i try to move my AOS DEV reporting services to the new Report Server, all Report work fine including Purchase Order Report.
im kinda lost of where should i check next.
Thank you
