ARCHIVED: How do I create a list in SSRS?
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
To create a list in your SSRS folder:
- From the SSRS folder, click .
- In the ribbon, click . From the drop-down menu, select . Keep highlighted, and select .
- Select the tab, and click the icon. The cursor will turn into a small square icon with a plus sign.
- Click inside the report frame and drag the cursor along the frame; this will create an empty rectangle, and the "Dataset Properties" window will appear.
- Enter a descriptive name for the dataset, and select the radio button.
- For the data source, click .
- With highlighted on the left-hand side, enter a descriptive name for the data source.
- If not already selected, select the radio button.
- From the "Select connection type:" drop-down menu, choose .
- Click to construct the connection string.
- Enter the server name for the server where the data source is located.
- From the "Connect to a database:" drop-down list, select the database. Click .
- Highlight on the left-hand side, and make sure that is selected.
- Click to save the data source connection. This will return you to the dataset properties.
- Click .
- Click the ellipsis ( ) button in the left-hand corner and select the cube. Click .
- Drag and drop the measures and dimensions you want onto the empty frame. After you have completed the dataset, click .
- Click to save the dataset.
- In the "Report Data" pane on the left, open the dataset that was created above, and drag and drop a field that contains a list of items onto the list textbox. This will create a simple top-to-bottom list.
- Click in the text box above the list to add a report title. You can also position the list differently inside the report frame, if desired.
- To test the list, in the ribbon, click . To return to the report layout, click .
- To save the list, click the floppy disk icon in the left-hand corner of the screen and open the directory. Enter a name for the list and click .
This is document bcqv in the Knowledge Base.
Last modified on 2021-09-20 15:14:14.