SQL Reporting drop down or prompt

Question

I created the following query which returns my assets and the collection they belong to. One asset belongs to many collections. I would like to publish this in SQL Reporting and have it either prompt for the asset ID to be entered or maybe even a drop down selection to pick the asset before executing the query but not really sure where to begin with this.

SELECT DISTINCT [CM_TAN].[dbo].[v_FullCollectionMembership].[Name] AS [Asset ID],

[CM_TAN].[dbo].[v_Collections].CollectionName AS [Collection Name]

FROM [CM_TAN].[dbo].[v_FullCollectionMembership]Left JOIN [CM_TAN].[dbo].[v_Collections] ON cast([CM_TAN].[dbo].[v_FullCollectionMembership].CollectionID as nvarchar(30)) = Cast([CM_TAN].[dbo].[v_Collections].SiteID as nvarchar(30))

Order by [Asset ID]

Answer 1

Hi @Culbertson Geoffrey

For a tutorial on adding parameters to reports, you can check out this link: https://learn.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-report-builder?view=sql-server-ver16.

If you want to know more about the concept of report parameters, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-parameters-report-builder-and-report-designer?view=sql-server-ver16.

Best regards,

Aniya