Limit the columns when export RDL to TIFF or PDF image


  • I am working on a report page with around 10 columns. When the report appears, there is a export button for user to export the report to csv, excel, tiff and pdf. There is a problem with the PDF and TIFF image when there are many columns, as width of the image file is shorter than the total columns width, some columns are 'split' to the next page. Is there any way to limit the columns in the export feature to TIFF where we can specify the maximum columns to be exported to the image file?

    Monday, January 13, 2014 4:14 AM


  • One method you can try is to set visbility expressions for the column you want to hide based on RenderFormat. You can get this value from Globals collection. So expression for hidden property of those columns would be as below

    IIF(Globals!RenderFormat.Name = "IMAGE" Or Globals!RenderFormat.Name = "PDF",True,False)

    so as to not render them in those formats

    Please Mark This As Answer if it helps to solve the issue Visakh ----------------------------

    Monday, January 13, 2014 5:49 AM