I have a stored procedure that has hyperlinks in it when I call that stored procedure into a gridview those hyperlinks are displayed which is fine. I want them removed when I export the gridview to excel but remember they are in my stored procedure.
Here's the query
SELECT '' AS reg, RegionAcronym, '<a href=nation.aspx?RegionAcronym=' + Regionacronym + '>' + 'PHI' + '</a>' as area,
SUM(totpenfodds) AS 'totpenfodds',
SUM(pendinfo) AS 'pendinfo', SUM(pendndds) AS 'pendndds',
SUM(pendfo300) AS 'pendfo300',
SUM(penddds300) AS 'penddds300', SUM(pend250) AS 'pend250',
SUM(pend300) AS 'pend300', SUM(pend351) AS 'pend351',
SUM(pend400) AS 'pend400'FROM T16Report where reg='c'
group by reg, RegionAcronymUNION
SELECT reg, RegionAcronym , '<a href=areaDistListing.aspx?reg=' + reg + '&Area=' + Area + '>' +'Area ' + right(area,1) + '</a>' as area,
SUM(totpenfodds) AS 'totpenfodds',
SUM(pendinfo) AS 'pendinfo', SUM(pendndds) AS 'pendndds',
SUM(pendfo300) AS 'pendfo300',
SUM(penddds300) AS 'penddds300', SUM(pend250) AS 'pend250',
SUM(pend300) AS 'pend300', SUM(pend351) AS 'pend351',
SUM(pend400) AS 'pend400'FROM T16Report where reg='c'
GROUP BY reg, RegionAcronym, areaORDER BY reg, RegionAcronym, area