0

Report mode - Users cannot update

Clifton Aquilina

November 26, 2020 10:52

None

Follow

Hi, 

Good morning,

Maybe someone can help me please, cause for sure I'm missing a step.

I've created a report to show G/L entry's per Account No. 

To make it easy for others, I've created a "filtering box" as below. So that they can change Date and G/L if need be, which is linked  Tab Options.

When I'm in design mode everything works fine.

But when a users are in Report mode and they change date and G/L it takes them back to the saved Date and Sheet becomes locked and they cannot redo it. 

what did i miss please 

 

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks May 11, 2022 20:01

  You should consider using the keyword of Option.  You are already hiding the option sheet (I see "hidesheet") so there is no need for the Hide in column A.   Instead use OPTION in column A in any row where you want the user to change values at runtime.  In this case, it looks like row 2, 3, and 4 should have OPTION.

  When the user runs the report, a dialog box will appear for them to put the values you need.