In our BI Reporting series, we address several BUI reporting tools. This blog expands on our Business Intelligence Quick Reference Guide.
Enjoy.
Step | Action | Details |
1. Start Visio | ||
2. Mock up report in Visio | ||
3. Link shapes to database: | Data?Link Data to Shapes?Microsoft SQL Server Database | |
4. Select the UserView: | Server, Reporting DB, appropriate UserView | |
5. Enter name of Data Connection | ||
6. Select your Data Connector, Rows & Columns | ||
7. From External Data window, drag & drop item onto graphical element |
8. Use Data?Data Graphics to configure item appearance based upon its value
Save to SharePoint document library