farhasem.blogg.se

Highlight the Query from Dynamics GP connection.

Click the Data tab and select Connections in the Connections portion of the ribbon.Enter in Field headings for the parameters you want people to be enter. You can do it to the right of the data or insert rows/columns to put them in.Select New Worksheet for where to put the data and click OK. It will create a new worksheet that will look very similar to the one created by Excel Report Builder. On the Query Wizard – Finish window, select Return Data to Microsoft Excel and click Finish.Click Next on the Choose Columns window, the Filter Data window, and the Sort Order window.In the Available tables and columns, select the view that was created in Excel Report Builder and insert it into the Columns in your query field.Click the Options button and then in the Database field select the database the view was created in. On the SQL Server Login window, login to the SQL Server with a user that will have access to the view you have created for your Excel Report Builder setup.In the Get External Data portion of the ribbon, select From Other Sources – From Microsoft Query.Open the list in Excel and put the cursor in an empty cell.Create an Excel Report Builder report with the data you need.Here is how you would go about doing that. But, it can be added in Excel to the report you build in Excel Report Builder. With the core Excel Report Builder, this isn’t something that can be done. We have been asked many times if you can have parameters in an Excel Report Builder built report so the end user can restrict down the data a little easier.