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.
Now, I bet I can just add a column to use for the popup, but would love to know if there is a programmatic way to escape these single quotes so that the javascript does not get confused.
