Hi and seasons greetings
I've found a strange issue when I attempt to set a title in a dbr.report popup.
If I only pass one parameter I can create a title for the popup window. However if I add additional parameters the popup's title reverts to the popup report's title.
For example using the following:
CREATE PROCEDURE `sp_DBR_Budget_M2`(inSiteID int)
select 'dbr.title',concat('Month 2 data for Site ',(select Site_Name from hilmark.tblsitesjake where Site_ID =inSiteID ));
The popup's title is as in the 'dbr.title' statement.
When I add additional parameters as
CREATE PROCEDURE `sp_DBR_Budget_M2`(inSiteID int, inUnits int, inSales int) and leave the rest of the code the same the 'dbr.title' statement is ignored and the popup's title is the title of the report (created during creation).
Any thoughts and thanks