It is working from Xojo if I revert to [SQL] in the report's pre-build with the statement "Call genqrlabels(1)". The thing is, I have to provide an explicit value as a parameter for the stored proc. If I switch to [Javascript] with this statement:

report.datasource.sqlSelect( "CALL genqrlabels(" + report.parameterValue( "pHeaderID" ) + ");" );

... this one works from Valentina Studio because I provide the value of pHeaderID at runtime. From xojo, it shows nothing. I suspect that the parameter passing from Xojo does not get into consideration during the initialization of the report in the statement:

mReport = mProject.MakeNewReport(strReportFile, vconnect, strSelect)

This is an excerpt from my xojo code:

    mReport = mProject.MakeNewReport(strReportFile, vconnect, strSelect)

    

    mReport.SetParameterValue("cCompany",ReportModule.CompanyName)

    mReport.SetParameterValue("cAddress",ReportModule.CompanyAddress)

    mReport.SetParameterValue("cEmail",ReportModule.CompanyEmail)

    mReport.SetParameterValue("cWebsite",ReportModule.CompanyWebsite)

    mReport.SetParameterValue("cLandLine",ReportModule.CompanyLandline)

    mReport.SetParameterValue("cMobile",ReportModule.CompanyMobile)

    mReport.SetParameterValue("cTIN",ReportModule.CompanyTIN)

    mReport.SetParameterValue("pHeaderID",Str(me.HeaderID))

pHeaderID is passed AFTER the creation of the report not before, so I think the pre-build takes the default value instead and use it and cannot find the HeaderID value of "333" (your given default). Thus the report is blank.

Update: I tried changing the parameter pHeaderID value to "1" in Valentina Studio,still the result shows a blank report.

Hi Dale,

Thank you for the details, I think I recreated your structure but it still works for me from Xojo.

The report query is not executed in the MakeNewReport, but only when it is necessary - like getting the number of pages or printing, so it should not be a problem.

Have you tried also to pass a constant value to parameter, like:
mReport.SetParameterValue("pHeaderID", "1" )

My Dear Sergey,

Well, I'll be damned! You hit the nail on the head by suggesting to pass an explicit value instead of a variable. I just found out that I did not handle well the variable used to pass for the parameter to catch. Now my report works! You are a God-send, Sergey! Loads of thanks to you!!!

You're welcome!