0

Subtotals and hiding rows

Jet Reports Historic Posts

May 14, 2008 12:47

None

Follow

See the attachted file

How I can place automatically sub-totals as the first three positions of the field No. modified. The yellow marked cell in the attached file

How I can let hide the rood marked rules with conditional to hide

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts May 14, 2008 14:42

  I don't see your attached file? Can you reply and attach the file?

• 0
  
  Jet Reports Historic Posts May 15, 2008 07:26

  Attacted file posted

  • JET.FINANCIEEL OHW 0.1.xls
• 0
  
  Jet Reports Historic Posts May 21, 2008 20:06

  Can you please make sure that Auto+Hide+Values is in cell A1 on the report page. When I looked at the report everything went to #VALUE's.

• 0
  
  Jet Reports Historic Posts May 28, 2008 06:33

  See Attached file

• 0
  
  Jet Reports Historic Posts August 28, 2008 16:35

  It doesn't look like your attachment came through in your post. Can you please try again?

• 0
  
  Jet Reports Historic Posts August 28, 2008 17:43

  Here is my suggestion.
  
  In C12, change Rows=3 to Rows=5
  In Row 16, put subtotal(9,H12:H15) in whatever column needed
  Put 'hide' in the start of row 15.
  
  Now, the subtotal gets replicated as needed.
  
  The exact implementation may be difference, as don't have the same table you refer to. See if the attached does the job

  • JET.FINANCIEEL OHW 0.1.xls