1. Home
  2. Forum
  3. jQuery
  4. How do I blank out duplicate column values for SSRS reports in ejReportViewer?
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

How do I blank out duplicate column values for SSRS reports in ejReportViewer?

Neither of the following techniques work:
  • If I select the field, and change the HideDuplicates property to the parent group of the current row, all rows are still visible. The property seems to be ignored.
  • If I set the Hidden property for the field (see http://stackoverflow.com/questions/12940805/blank-out-duplicate-column-values-in-sql-reporting-services), I get the error: "An error occurred while processing the report item 'field name' and Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.
How do I blank out duplicate values below each other?

-Waldemar


3 Replies
SR Soundara Rajan S Syncfusion Team April 13, 2015 07:13 AM UTC

Hi Waldemar,

Thanks for using Syncfusion Products and Sorry about inconvenience caused.

If I select the field, and change the HideDuplicates property to the parent group of the current row, all rows are still visible. The property seems to be ignored.
As of now, ReportViewer doesn’t support the “HideDuplicates” Property in Tablix. However, a support incident to track the status of this feature has been created under your account. Please log on to our support website to check for further updates

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents


If I set the Hidden property for the field (seehttp://stackoverflow.com/questions/12940805/blank-out-duplicate-column-values-in-sql-reporting-services), I get the error: "An error occurred while processing the report item 'field name' and Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.
How do I blank out duplicate values below each other?
A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents




Please let us know, if you have any concerns.

Regards,
Soundara Rajan S.

GE geesoon April 19, 2023 06:01 AM UTC

Hi, what is the workaround for this issue? I am currently facing similar issue. 


AM Arumugasami Murugesan Syncfusion Team April 20, 2023 08:09 AM UTC

Hi Geesoon,


Thanks for contacting Bold Report support.


We have created a ticket for your query. Please check the ticket from the below site and follow further.

https://support.boldreports.com/support/tickets


Regards,

Arumugasami M


Loader.
Up arrow icon