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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

142779 Feb 19,2019 05:25 PM UTC Feb 27,2019 07:00 AM UTC Report Platform 3
loading
Tags: Report Viewer
Amanpreet
Asked On February 19, 2019 05:25 PM UTC

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

Mageshyadav M [Syncfusion]
Replied On February 20, 2019 11:39 AM UTC

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 


Amanpreet
Replied On February 26, 2019 08:15 PM UTC

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

Mageshyadav M [Syncfusion]
Replied On February 27, 2019 07:00 AM UTC

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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon