• Replies 3 replies
  • Subscribers 1 subscriber
  • Views 4 views
  • Users 0 members are here
Options
Related

RunGlobalPRocedureOnServer within report

Admin
When running RUNGLOBALPROCEDUREONSERVER from HTML report, the error
"The function RUNGLOBALPROCEDUREONSERVER is not supported when it is configured as a string expression between curly brackets."

is received. (screenshot attached).

Even when running the report generation function, the same error is received.

Anyone experience this?

  • You could try executing the procedure before running the Report and store the results in a tag. Then replace the procedure call in the report with the tag. This should work as long as the returned value is less than 1024 characters. The report function is processed using background tasks and there are restrictions related to calling RunGlobalProcedureOnServer from background tasks.
  • Thanks for your reply.

    I did see that a tag can be used, but it seems a string tag does not store vbCrLf characters properly. Or a maybe I am not appending the vbCrLf to the tag properly. I am temporarily using an array of string tag to generate the table rows, and it's working for now, but I would like to implement the more manageable solution of calling the RunGlobalProcedureOnServer directly from the report.

    In any case, the plan is to build the HTML report tables into this string tag, so I believe 1024 characters may be exceeded in some cases. This method of embedding a RunGlobalProcedureOnServer within an HTML report was taken straight out of an Indusoft blog article, so I assumed it would work.

  • Do you have 'Enforce Web functionality equivalence in local project screens' enabled in your Project Settings-Preferences?

    Also, FYI, in most (if not all) cases, you do not need CR/LF in HTML. It is there for readability of the source code.