B1UP SQL Report with Stored Procedure and Parameters
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
-
I've found the problem.
Just create a new UF SQL report instead of change the old one :-(regards Willem
Please sign in to leave a comment.
Comments
1 comment