Some of the reports I have built will start to refresh and run when i am in design mode and insert the month beginning date and i have to wait to enter the month ending date. I have "Auto+Hide+Values" entered in cell A1 and thought that was suppose to keep report from starting until I press Refresh.
Date
Votes
3 comments
-
Jet Reports Historic Posts Not when in Desigh mode. Try using NP("Eval","=Options!E4") and reference that in your formulas. Where E4 is you start date. Replicate for all options.
-
Jet Reports Historic Posts So where my formula for my first cell is… =-Gl("Balance",$C9,E$3,E$4,,,,,,,,,,,,,,,,,,,$C$4) and "E3 and E4" are my beginning and ending dates I have to include… NP("Eval","=Options!E4") in each formula somewhere?
-
Jet Reports Historic Posts E3 and E4 on the options sheet is where you enter your filters.
Then on your Reporting sheet E3 = NP("Eval","=Options!E3") and E4 = NP("Eval","=Options!E4")
All the formula point to E3 and E4 on your Reporting sheet
Please sign in to leave a comment.