Hello Elena,
If you are using standard SSRS builder (Report Builder or Visual Studio) for direct SQL data you should define a query (select statement for all financial analytists).
For more information look here: msdn.microsoft.com/.../aa337396(v=sql.105).aspx
I am not familiar with AX reporting a lot, but it seems it should be done in similiar way.
You can find step-by-step procedure in "What's New in Microsoft Dynamics AX 2012 for Developers":
Procedure: Add a Dynamic Parameter
To add a dynamics parameter, follow these steps:
1. Create a new Query.
2. Locate the table and drag it onto the Data Sources node.
3. Include the field for your parameter in your dataset view.
4. In the Model Editor, right-click the Datasets node, and then click
Add Dataset.
5. Type a name for the Datasets node.
6. Select the node for the dataset.
7. In the Properties window, specify the following values:
a. Set the Data Source property to Dynamics AX.
b. Set the Data Source Type property to Query.
c. Set the Default Layout property to Table.
d. Set the Name property.
e. Set the Query property.
8. In the Model Editor, select the AutoDesign1 node.
9. Expand the Parameters node to display the list of report parameters.
10. In the Properties window, click the button in the Values property.
11. Select the From Dataset button and set the following:
a. Set the Dataset property.
b. Set the Value Field property.
c. Set the Label Field property.
12. Optional: In the Model Editor, right-click the AutoDesign1 node,
and then click Preview to view the new style settings for the report.
13. Optional: Close the Preview window.
14. Save the report.
Greetings, Artur
