Alpha Video Training
Results 1 to 5 of 5

Thread: How do you remove calculated fields from Report DragDrop list

  1. #1
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,201

    Default How do you remove calculated fields from Report DragDrop list

    Hello,

    I have a Report that was duplicated from another report which was originally a duplicate for another report... and so on. Now 4-5 generations later, with each prior generation adding new calculated fields, I have a Report with a very full DragDrop list filled with calculated fields. Does anyone know how/whether it's possible to remove unneeded calculated fields from a Report's DragDrop list?

    Mike W

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default

    I don't, without also deleting the calc field itself. Do you need help doing that?

    -- tom

  3. #3
    VAR davej's Avatar
    Real Name
    Dave Jampole
    Join Date
    Apr 2000
    Location
    Haughton, LA ( just east of Shreveport, Louisiana)
    Posts
    2,524

    Default Removing Calc Fields from Drag/Drop List

    Mike,

    If you mean remove the calc field from the D/D list BUT retain the calc field in the calc field editor, the answer is 'No'. If you click on the xy icon on the toolbar of trhe Report Editor, you can select and delete a calc field and then it will not appear in the D/D list, but I would suggest that you be very careful doing that. Sometimes a calc field is created because it is needed in a second-level calculation. If you delete the subordinate calculation, the 'parent' calculation won't work.

    Dave
    Dave Jampole
    www.customalpha.com

    Women and cats will do whatever they want. The sooner men and dogs realize that, the happier they will be.


  4. #4
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,201

    Default Answer to how to delete calculated fields fom DragDrop list

    Thanks all, I found the answer by sheer happenstance.

    Dave, I tried that many times. Just trying to delete a calculated field present in the middle of the list draws an error message. Over and over I tried this. But then I tried it one last time and IT WORKED, I figured it out. The difference I discovered is the little fact that deleting the field is only possible when the fields is located as the last calcuation on the list. So I highlighted the field, moved it to the bottom of the list with the blue arrows, and was able to delete, for all those that might search this.

    I appreciate the dangers of doing this, and I'll be mindful of that. I am playing around with these calculated fields on a steep learning curve and am generating misses that are accumulating. Thanks All.

  5. #5
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default

    Quote Originally Posted by Mike Wilson
    Thanks all, I found the answer by sheer happenstance.

    Dave, I tried that many times. Just trying to delete a calculated field present in the middle of the list draws an error message. Over and over I tried this. But then I tried it one last time and IT WORKED, I figured it out. The difference I discovered is the little fact that deleting the field is only possible when the fields is located as the last calcuation on the list. So I highlighted the field, moved it to the bottom of the list with the blue arrows, and was able to delete, for all those that might search this.

    I appreciate the dangers of doing this, and I'll be mindful of that. I am playing around with these calculated fields on a steep learning curve and am generating misses that are accumulating. Thanks All.
    Not sure why this is happening to you, but you should be able to delete calculated fields from the middle of the list. Just make sure you click on the very left of the row and that the entire row highlights. Then right click and delete.

Similar Threads

  1. Dragdrop list
    By Rosemary Anderson in forum Alpha Five Version 6
    Replies: 4
    Last Post: 03-11-2005, 02:45 AM
  2. Report Calculated Fields
    By Paul Main in forum Alpha Five Version 6
    Replies: 4
    Last Post: 02-25-2005, 10:19 AM
  3. DragDrop List
    By Gregory R. Zilliox in forum Alpha Five Version 5
    Replies: 2
    Last Post: 08-05-2003, 05:19 AM
  4. Nested calculated fields in a report
    By Howard G. Cornett in forum Alpha Five Version 5
    Replies: 0
    Last Post: 08-04-2003, 02:07 PM
  5. Remove old calculated fields?
    By JayMoskovitz in forum Alpha Five Version 4
    Replies: 3
    Last Post: 08-20-2001, 10:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •