I need to create a select list or popup parameter that is filtered based on the inLogin automatic variable.
I created the following stored procedure as the records source for the Select List in MS SQL
CREATE PROCEDURE sp_dbr_popup_projects @inLogin varchar(30)
SELECT iResourceID, Resource FROM f_lst000001Project(@inLogin)
I then have the following report stored procedure
CREATE PROCEDURE [dbo].[sp_dbr_ProjectTasks_select](
@inLogin varchar(30), @inParentID nvarchar(255))
SELECT 'dbr.title', 'Project Tasks';
SELECT * FROM [f_rrt000001ProjectTasks](@inLogin)
WHERE iParentResource_iRID = @inParentID;
I then created a query parameter as follows
Parameter Input Type Query
List Projects Select list sp_dbr_popup_projects
I need to be able to get the iResourceID from the Select List and pass it to the report Stored Proc as @inParentID.
This gives me an error when trying to run the report.
Is there a way of getting a popup list to be filtered by the inLogin variable?