Hello everyone,
I have a view called ‘news_vw’. It has different fields i.e. NewsDate, Sector, Issues, IssueCount. What I want is to create a summary report having all the fields except NewsDate grouped by Sector. However, I want filtering/extending searching facility on NewsDate. Is there any mechanism to do it? If not what’s the alternative way to do it.
Thank you.
- Make sure you have already enabled Show option from Fields setup → Report Page
- Make sure you have already put this code in Page_DataRendering server event of your Summary Report:
$this->YourFieldName->Visible = false; // adjust YourFieldName to your actual field name
Thank you. Actually, the issue is that if I make the visibility false, it will only make the column hidden. I also want to omit Group By aggregate calculation on NewsDate field.
You may Inspect HTML element and find out the CSS classes of those rows/cells, then you may try to add your CSS styles to hide them.