B1UP SQL Report with Stored Procedure and Parameters

Dan Roos

Hello

I try to use a stored procedure with parameters(s) in the Universal Function, type SQL Report.

It will works fine with the paramater hardcoded like:

execute [InterCompany].[dbo].[HM_Test] '9917'

But I receive an error by using SQL variabelen.

execute [InterCompany].[dbo].[HM_Test] [%0]

SQL Variabelen: %0[0|Custom string];

The survey variablen window will pop-up, but after fill it with an value and press oke, an error follows.

I try several variaties without any result. Does anyone know the solution?

 

Error Launching Report: SBO.UserDatasouceException: Error working with userdatasource: BOY_14S on form BOY_41_SQLREPORTVAR_UF-759 (Defineer survey variabelen) [UID can max be up to 10 chars long], or userdatasource is missing     at SBO.UI.FormItemCollections.UserDatasourceCollection.get_Item(String uid)     at Shared.Function.InputVars.Controller.InputVarController.GetSource(B1Form eventform, Int32 variableNumber) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Shared\Function\InputVars\Controller\InputVarController.cs:line 411     at Shared.Function.InputVars.Controller.InputVarController.GetVarDataString(B1Form inputForm, String inputString, FormatType formatType, Dictionary`2 varsToUse) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\Shared\Function\InputVars\Controller\InputVarController.cs:line 565     at UniversalFunctions.Functions.SqlReport.View.SqlReportVarsForm.LaunchSqlReportWithVars(B1Form sqlReportVarsForm) in C:\TFS\B1 Usability Package\Main\Source\Code\Modules\UniversalFunctions\Functions\SqlReport\View\SqlReportVarsForm.cs:line 169

 

Comentarios

1 comentario

  • Comment author
    Dan Roos

    I've found the problem.
    Just create a new UF SQL report instead of change the old one  :-(

    regards Willem

    0

Iniciar sesión para dejar un comentario.