Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Thursday, March 23, 2006

SQL Server Reporting Services

If you plan on using the next version of Dynamics AX that will soon come out, then you need to learn how to use SQL Server Reporting Services. This is the new reporting engine for Dynamics Platform. Should be, because in my on use of both the current 3.0 reporting tool and SQL Server Reporting Services, I really enjoy working with RS over the default reporting in AX 3.0.

Now with that said, how does this apply to 3.0 and current day use. Well because of how great a technical platform AX is, you can modify all reports within Axapta and processes so that all reporting is used with SQL Server 2000 and Reporting Services v2.

There is a great report pack on the Microsoft site that Tectura did. Is gives a based understanding of how to connect to AX from RS, and make it usefull. Something that is not explored throughly is how to connect that from within AX. The thing you have to keep in mind is that for AX 3.0 you want to use a Web Browser Control on a AX form, and then direct that form / control to the correct report. With that, then you can replace Purchase Orders, etc. With a version of it from SQL Server Reporting services. RS is a geat alternative for reporting in 3.0 and it IS the reporting in DAX 4.0 so you might as well create a test enviornment and learn how to set it up, Admin it, and most of all Create reports and use them from Within AX 3.0.

In the not to distant future I have plans on walking you through creating a report in AX 3.0, RS 2000 v2 from within Axapta. Check back soon for that, and other great post!

Find a job at: www.DynamicsAXJobs.com


Blogger shaakera said...

Hi Brandon,

Any news about creating the walk through for using RS with DAX?



1:18 AM  

Post a Comment

Links to this post:

Create a Link

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved