I'm trying to link reports with a button...but I can't get it to pass the variable along....so wondering what I am doing wrong as it is supposed to be easy!
SELECT 'dbr.button', 'Next ->', 'button nextpage';
SELECT 'dbr.report', 'sp_DBR_complete', 'inID=ID';
SELECT @myID AS 'ID';
I have set @myID earlier in the code and want to pass it to the button and next page. The following page autoexecutes and has inID as the only parameter (and is added with the correct permissions). But it doesn't seem to pass the parameter.