HI

this is my need

1- i have create report "Create Direct Database Request" and this is my code on it

---***********

declare @temp table

(

SORTID INT,

ROWORDER INT,

LABEL varchar(255),

VALUE INT,

DATE DATETIME,

groupid Nvarchar(50),

groupnamee Nvarchar(50),

CUSTOMERTYPE Nvarchar(50),

CUSTOMERTYPEDESCRIPTION Nvarchar(50),

DISPLAYORDER Nvarchar(50)

);

DECLARE @return_value int

INSERT @temp EXEC @return_value = [dbo].[SP_BI_DW_KPIReports_Daily]

@FromDay = N'@{SBUZZ_FROM_DATE_V}{Direct}',

@ToDay = N'@{SBUZZ_TO_DATE_V}{Direct}',

@FromSalesman = NULL,

@ToSalesman = NULL,

@FromSupervisor = NULL,

@ToSupervisor = NULL,

@FromSalesmanCategory = NULL,

@ToSalesmanCategory = NULL,

@FromRouteID = NULL,

@ToRouteID = NULL,

@RTM = NULL,

@FromCustomerCategory = NULL,

@ToCustomerCategory = NULL,

@FromBUID = N'1AXAX23',

@ToBUID = N'1AXAX23',

@BUID = N'@{SBUZZ_BUID_V}{Direct}',

@Grouping = N'@{SBUZZ_GROUPING_V}{Direct}', ----********* MY NEED

@ShowMoreFields1 = NULL

select

SORTID ,

ROWORDER ,

LABEL ,

(CASE WHEN VALUE IS NULL THEN 0 ELSE VALUE END) VALUE ,

DATE ,

groupid ,

groupnamee ,

CUSTOMERTYPE ,

CUSTOMERTYPEDESCRIPTION ,

(CASE WHEN DISPLAYORDER IS NULL THEN '0' ELSE DISPLAYORDER END)DISPLAYORDER

from @temp ORDER BY DISPLAYORDER ASC ;

-----------------*********************

and this code it's working fine, but if you looking on this line (---- MY NEED) this variable has been created on RPD, and must have an ID, So i need create dashboard Prompt have on two columns one for description and the other one for ID (Ex: if the user chose any description, by automatic the ID for this description return on this variable to return on my code ), and i need this ID return on this variable

thanks