I just ran into a problem with "Period Name" being removed from the Date Table and am trying to find a solution. I'm trying to count the number of shipping days available in a given period. Here is the formula I was using before.
=NL("Count","date",,"period name","Monday|Tuesday|Wednesday|Thursday|Friday","period type","date","period end",".."&$D$15+1,"Period start",$C$14&"..")
Any advice on how to replicate this formula?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Eric,
Did you recently switch from using Web Services to the SQL Direct connector?
If so, the Web Services has some custom views built in as you have discovered. In Web Services, there is Period Name, but in the SQL there is not.
One workaround is to build into your functions that need those custom views a DataSource= and point to the Web Services data source.
That way you get most of the report pulling from the quick SQL connector and only a few functions pulling from the slower Web Services. -
Jet Reports Historic Posts Thanks! That worked. I just added this to the end of the formula.
,"DataSource=","NAV2013"
Please sign in to leave a comment.