An interesting problem. I have 2 linked reports, the first one calling the second thus:
select 'dbr.report', 'sp_DBR_Product_Entry_Edit', '[product]', 'popup', 'zID=[pid]', 'zDescr<=Descr', 'zFulldescr<=Fulldescr', 'zKeywords<=Keywords';
I am using the [column reference] this way, for shorthand:
select x.productid as 'Productid[pid]', . . .
Using the column name itself, Productid, doesn't seem to make any difference in the problem I am having.
It returns the appropriate records, and the [product] column text is underlined, as one might expect for a link. The problem is, some of the links open up a popup for editing and everything works. Some do not. The rows that do not work have single quote characters in the text for the product column.