Hello Giselda,

Thanks for your query.

The data we get in the "List Sections" popup is dependent on two parameters "component" and its "format". 

We get different lists for different formats. 

So, even if the "Export" option is available in the popup, you might end up creating multiple excel files for different component formats and merge them into a single file.

I agree that, it would have been nice if we had that option, but it might not help you much with your usecase. 

Please let me know if you need any other information on this.

On a side note, we always recommend to use UI-Kit that gives you greater consistency across different screens/applications. This might just limit your manual effort to handling minimal customizations(if there are any).

Thanks,

Sumanth.

Hi Arun,

Thanks for the question.

Unfortunately we cannot hide the columns conditionally from the report definition rule configuration. 

But we can restrict the access to the complete report data by configuring a privilege in the data access tab. 

However, you can hide/obscure the contents of any specific column by-

1. Creating a custom control which shows the values conditionally(based on access group in your case)

2. Refer the control as a column format in the RD.

Please let me know if you need any more information on this.

Thanks,

Sumanth

Hi Rajesh,

Thank you for the query.

I guess you could just summarize the required columns with "Sum" option.

In your example, you can do it for iphone, oneplus, redmi columns.

And the report looks like this.

I know it looks different from how you are expecting. Reports directly get the data from the table records and so you can only have good control over columns, like what data any column should have, applying formats and functions etc. 

Coming to row capabilities, you can fetch/avoid few rows based on the filtering criteria. But it is not possible to display heterogeneous row data(in your example,  total sales count for one row and provider sales count for other rows) in a report unless the summarization is applied.

If you slightly tweak your example to add total sales for each provider in a separate column, this is achievable by using sum function as a source for the fifth column(i.e., Total) that takes all the three column sales as inputs.

Hope this helps! Please let me know if you have any other questions on this.

Thanks,

Sumanth