<div>
Use ssms to make the query. If you have a single little syntax error ssrs will give that error. Then once it works right, put it in ssrs
</div>


Use ssms to make the query. If you have a single little syntax error ssrs will give that error. Then once it works right, put it in ssrs

<div>
I figured out a solution to my problem on my own. &nbsp;The experts comment offered for me to try something that I had already done.
</div>


I figured out a solution to my problem on my own.  The experts comment offered for me to try something that I had already done.

<div>
<div class="content wysiwyg-content">
I am trying to add a group by for the amountmst field from LegdgerTrans. &nbsp;Right now it is showing all of the transactions on the voucher, but I want it to show the sum on one line. &nbsp;I have multiple inner joins with tables but when I add the group by I get this error<br />
&quot;&nbsp;Could not update a list of fields for the query. &nbsp;Verify that you can connect to the data source and that your query syntax is correct. &nbsp;I only get this error when I add the group by. I am using sql 2008 and Dynamics AX 2009.
</div>
</div>


I am trying to add a group by for the amountmst field from LegdgerTrans.  Right now it is showing all of the transactions on the voucher, but I want it to show the sum on one line.  I have multiple inner joins with tables but when I add the group by I get this error
" Could not update a list of fields for the query.  Verify that you can connect to the data source and that your query syntax is correct.  I only get this error when I add the group by. I am using sql 2008 and Dynamics AX 2009.

Could not update a list of fields for the query SSRS report error

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.