Finance | Project Operations, Human Resources, ...

is there any function in Visual studio to HIDE EMPTY COLUMNS

(0) Share

Report

Posted on by @rp@n

hi all,

Can you please let me know, is there any function in Visual studio to HIDE EMPTY COLUMNS ?

3 columns i have in Visual Studio.

SBU,

BRAND,

COST CENTRE

So, in report dialog, if suppose user select Dimension set = Main account+ Brand

Then in report, COST CENTER AND SBU columns should be hide. Basically the column is hide based on parameters.

5732.vs.jpg

please let me know what to write on the expression for each 3 columns?

Please give me more shed on this.

Thanks!

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

Earlier you wrote that you don't want to use a temp table.

But if you would use a temp table, you could have separate fields for every dimension in the table. Then, based on the user selection on the dialog, populate only the fields that the user selected.

And on the report, hide the fields that are empty (no value in temp table).

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

yes i understand but our solution architect not allows me to create a new field in standard table "LedgerTransactionListTmp". they told me to create a new 3 columns in Visual studio and make it as hide or unhide based on parameters.

is it possible?

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

If the solution architect is telling you how to do the technical implementation, perhaps he/she can suggest how to implement it?

In general you can show/hide columns based on an expression (like we see in your own screenshot). But your current requirement is a bit different. Since you are working with a solution architect, did you discuss with him/her about the possibility of using Management reporter?

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

not yet, i will

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (1)

Report
Copy link

Link copied!

Hi @rp@n,

The requirement to hide empty columns is a little bit incorrect. What if the brand dimension in case if dimension set Main account+ Brand is empty for all transactions. Column still should be visible as it's part of the dimension set. I guess you still need a pass list of columns to be shown to report (could be a parameter in contract populated after dialog closed) with the list of dimensions from dimension set and based on this value you can hide columns.

Was this reply helpful? Yes No