Hello, just in case this is helpful, I had exactly the same issue, and upgraded the OLE DB provider on the machine I deployed to, and it finally worked.
I was planning on using one report and determining the text for each of the text boxes in the expression using an IIF with the &ReportServerURL global. But now I'm...