• Login

DataSoft Corporation

Functions for Stored Procedure Binding

The following functions are specific for binding reports to a stored procedure:

Sage 50 and Peachtree Accounting does not support Stored Procedures.

 

Function

Description

Example

Join()

Concatenates the multi-value report parameter's values into a string. This function can be used when mapping multi-value report parameters to query parameters generated from a stored procedure's parameters. Refer to the Query Parameters topic for more information.

This function has two overloads:

  • Join(parameter) - concatenates the specified parameter's values using comma as a separator.
  • Join(parameter, separator) - concatenates the specified parameter's values using the specified separator.

Join(?Parameter1)

CreateTable(Column1, ..., ColumnN)

Creates a table from several multi-value parameters' values. This function can be used when mapping multi-value report parameters to the query parameter that is generated from a stored procedure's User Defined Table Type parameter. Refer to the Query Parameters topic for more information.

CreateTable(?Parameter1, ..., ?ParameterN)

Related Links

Found in Category: Related Articles
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.