Paginated report export To Excel does not have grids

[BishwaR]

Hello when I export my paginated report to Excel it gets converted to excel without grids.

Please advise how to get the Excel conversion with the gridlines

Thanks

[BishwaR]

Thanks a lot 

[sevenhills · Accepted solution]

Quick check ... whether the gridlines are coded or not in the report?

A) On the service, run the report , click view > Page view ... check whether you see the gridlines or not?

(or)

B) Download the rdl file, run the report, click print layout? check whether you see the gridlines or not?   Also, try to export here and see whether you get the gridlines.

If you dont see that means you did not code the borders.

If you see the grid lines in either of the case, then check your Excel , view menu, check box is checked next to Gridlines