Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tawke
  • Order by date
  1. tawke

    Show montly variance percent in a cross-tab

    Thanks alot, that did the trick :) Next challenge I am mostly interested in showing the Services with either a high or low percent variance, is there any way i can do group sort based on the percentage value i get from that formula? I can only seem to sort on the fields added by the "Insert...
  2. tawke

    Exclude directories from "Limit profile size" GPO

    Hi, We use the "Limit profile size" GPO to limit user profile (and desktop) size to 30 MB We have identified a few directories that are not user generated and we would like to exclude those from this 30 MB limit %userprofile%\PrivacIE %userprofile%\Cookies %userprofile%\IECompatCache...
  3. tawke

    Show montly variance percent in a cross-tab

    Thanks alot for the reply, i agree that a manual cross tab would be best to use here. I cant seem to figure out how to setup the formula for it to Count the amount of calls, in addition to filtering it on dates I have grouped my report on {Service_Calls.Service}, i have DateTime entry...
  4. tawke

    Show montly variance percent in a cross-tab

    Hi, I have Cross-tab which i have set up to show Montly values, currently it just shows the values (10, 15, 5, 30) What i would like to add is to show the variance\difference from month to month between these values like in the example below Jan Feb Mar...
  5. tawke

    Supress rows from a cross-tab

    Cheers, that did the trick, but by using this i effectivly also drop all the other data from that table entry which kinda mess up the numbers. Ideally it would just drop or not use the empty location field in the specific cross tab report im using this for (similiar to be using specified order...
  6. tawke

    Supress rows from a cross-tab

    Hi, I'm working against a database that has a location (City, Building, Floor) for each entry, i have created a formula which groups these locations into their parent locations (City) local stringvar Location; Location:={Service_Calls.Location}; if location in ["BUILDING-A\2ND-FLOOR"...

Part and Inventory Search

Back
Top