Skip to main content
Solved

Is there a way to make the columns fixed when using Tabular report with report designer?

  • May 20, 2021
  • 1 reply
  • 194 views

Forum|alt.badge.img+5

Hello,  

 I’ve wrote a tabular report to show customer(as row) sales in 4 warehouses (as column).

The values are the total sales qty.    

 

The column right now is dynamic, that if 1 warehouse has no sales at all, this column stands for this warehouse would not show on the report.      

 Is it possible to always show 4 columns, even if that warehouse has no sales.

 

 

Best answer by ray20

Hello,

    I found another way to fulfil my need. I do NOT use tabular report, I am using the visibility to control.

Since I need 4 fixed columns,

So I hard code them

 

But I make the line value visible only when this value is from that column warehouse

 

The results are like below:

 

 

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+5
  • Captain II
  • May 20, 2021

Hello,

    I found another way to fulfil my need. I do NOT use tabular report, I am using the visibility to control.

Since I need 4 fixed columns,

So I hard code them

 

But I make the line value visible only when this value is from that column warehouse

 

The results are like below:

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings