AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 22.12.2010, 12:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
kamalblogs: Data methods in Ax Reports and SSRS Reports
Источник: http://kamalblogs.wordpress.com/2010...-ssrs-reports/
==============

If you are someone who was exposed to the world of reporting through Ax reports then there is a dilemma that you would face when you create a Ax-SSRS report  for the first time. The dilemma is the perception towards data methods.

Conceptually Ax data methods and SSRS data methods are quite different, this has to do with their architecture.

When MS planned it’s migration from SSRS to Ax reports, the major reason cited was the randomness or the chaotic way of data gathering and rendering from Ax.

The Ax reporting engine does preparation of data and rendering of the same in an alternative way. A record is fetched and then all the additional information related to it is processed (display methods) and then it is rendered. This means every record fetched is processed before it’s rendered. This is the reason to receive the current record as a parameter for a display method and do calculations on it. This can be too simple but would be cumbersome to scale the reporting ability.

While SSRS reports have a well defined approach here. The data that is to be displayed in the reports are processed first before rendering. So even calculated/display methods are pre-processed and the data is kept ready. This data is then passed to the rendering engine which renders it. This is a more structured and scalable approach to follow.



When I had to start with SSRS for the first time It took me sometime to figure out this. Thanks to Saveen and the Dynamics BI team for making it much easier to understand for everyone. Today there is loads of SSRS Demo available in the Youtube Dynamics Ax BI Channel including the one that details about data method.

Data method related videos

AX2009 SSRS 11 Introduction to Data Methods
AX2009 SSRS 12 Using Data Methods as a Data Source
AX2009 SSRS 13 Executing an AX Query in a Data Method


Watch out to tune in your reports perception




Источник: http://kamalblogs.wordpress.com/2010...-ssrs-reports/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Jose Lorenzo: Most SSRS reports will stop showing data from January 2011 on Refresh 3, 3.5 and 4 Blog bot DAX Blogs 0 17.12.2010 00:12
emeadaxsupport: Date picker in Dynamics AX 2009 SSRS reports Blog bot DAX Blogs 0 29.06.2010 19:05
emeadaxsupport: Debugging Microsoft Dynamics AX 2009 SSRS reports with Microsoft Visual Studio 2008 Blog bot DAX Blogs 0 26.07.2009 15:07
gatesasbait: Dynamics AX 2009 SSRS and SSAS Integration Tips Blog bot DAX Blogs 3 09.07.2009 13:07
Vincent: Debugging business logic in AX 2009 SSRS reports Blog bot DAX Blogs 0 29.11.2008 09:05
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 23:24.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.