We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

How do I show/hide columns in a generated report?

Hi Team,

When a report is shown or exported, how can I hide/show the columns of a generated report. Also, how can I hide/show with the headers and footers for a generated report.

Looking forward for your response.

Thanks,
Amanpreet

3 Replies

MM Mageshyadav M Syncfusion Team February 20, 2019 06:39 AM

Hi Amanpreet, 
 
Please find the response for your queries. 
 
Query 
Response 
When a report is shown or exported, how can I hide/show the columns of a generated report 
If your case is to show/hide any columns based on your process of report viewing or report exporting then you can achieve your requirement by using this built in fields “Globals!RenderFormat.Name” to make condition in Column Visibility Expression while designing the report 
 
Please find the snapshot traversing to Column Visibility Expression, 
 
 
 
Please find the reference condition to set in visibility expression, 
 
=IIF(Globals!RenderFormat.Name == "RPL",  false, true) 
 
In the above expression “RPL” value will come when report is viewed hence you can modify the expression accordingly 
Also, how can I hide/show with the headers and footers for a generated report. 
 
No, We don’t have option to hide/show header and footer while exporting. We can decide whether header and footer needs to be visible or not while designing the report only. 
 
Regards, 
Mageshyadav.M 



AM Amanpreet February 26, 2019 03:15 PM

I am not able to understand the steps. Can you please explain in detail. My requirement is to be able to operate on the generated report. I should be able to hide or show the columns or header/ footer in a generated report.

Regards,
Amanpreet


MM Mageshyadav M Syncfusion Team February 27, 2019 02:00 AM

Hi Amanpreet, 
  
Can you clearly share some additional details or snapshot on your requirement and confirm us whether you are expecting to hide/show any columns and hide/show header/footer while exporting the report alone so that visibility of columns/header/footer will be varying for both viewing the Report in ReportViewer and exporting. Based on your confirmation, we can provide further clear steps for your understanding. 
  
Regards, 
Mageshyadav.M 


Loader.
Live Chat Icon For mobile
Up arrow icon