0

Conditional Hidesheet

Jet Reports Historic Posts

July 08, 2009 03:20

None

Follow

Hi Everyone,

I have created a report that calculates the data from the "Sales Shipments" and the G/L Accounts to check if there is any inaccurate information.
the report itself works fine.
It runs from the first of the month to "Today" with a new sheet for each day and a Summary page (which totals up using excel formulas, not Jet)

the problem I'm having is in B2 I have "Hide+?"
in B3 i have =TEXT(D4,"DMMYYYY") (D4 is the last date value)
in B4 i have =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))+1)which returns the current sheet name (which is the date value because of "Sheets")
in B2 i have =IF(B3<>B4,"Hidesheet","Show")
so if today is the date of the sheet leave it showing otherwise Hidesheet.

however when running the report it doesn't work.
the cell says "Hidesheet" but the sheet is still visible

Thanks for help in advance
-Bromy

• GL Tracking Expanded.xls

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 09, 2009 20:22

  This is the quote from the Jet help. It suggests putting Hide+? in cell A2.
  
  See if that gives you the results you are after.
  
  cheers, Mark
  
  

  Similarly, with "Hide+?" in cell A2 you can place a formula in cell B2 that conditionally returns "HideSheet" in order to hide the entire worksheet. Formulas that conditionally hide rows, columns, or sheets are typically IF formulas, such as the following.

• 0
  
  Jet Reports Historic Posts July 10, 2009 01:32

  the problem I'm having is in B2 I have "Hide+?"

  
  in B2 i have Hide+?
• 0
  
  Jet Reports Historic Posts July 10, 2009 11:09

  They help file says for hiding of the sheet to work you need Hide+? in A2 and a formula that returns hidesheet in B2:
  
  A2=Hide+?
  B2=if(condition,"hidesheet","show")
  
  I'm just going off the manual, haven't tried it myself.