CurrReport.PREVIEW disable Export to Excel in Report Viewer


I have a report that uses on PreReport Trigger the line “IsPreview := CurrReport.PREVIEW;”

The variable IsPreview is used to change the color and the decoration of some fields that have hyperlinks. I want this fields with color blue and underline if is a Preview of the report and black and without underline when I print the report.

This works fine. it change the decoration and color, but I will lost, by using the expression “CurrReport.PREVIEW”, the capability to Export to Excel in Report Viewer. Is there another way to do the same and keep this export functionality?



May not be possible to have export to excel option after using CurrReport.PREVIEW

You can write code to export the data to excel as in classic


Create boolean IsPreview in request page and use it code…