SQL Reporting drop down or prompt

Culbertson Geoffrey 60 Reputation points
2023-05-12T16:16:44.66+00:00

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]

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,117 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,853 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-05-15T02:15:42.8433333+00:00

    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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful