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!

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

Recent content by TheLibrary

  1. TheLibrary

    Crystal 9 - Limit Acess to Report with Parameter Password

    How can I install a parameter to prompt a user to type in a "password" in order to run the report? Is there an easier way?
  2. TheLibrary

    Crystal 9 Report Output to Excel/Access Database

    I think I found my own answer, NO. http://support.businessobjects.com/library/kbase/articles/c2010131.asp Had to try.
  3. TheLibrary

    Crystal 9 Report Output to Excel/Access Database

    Thadeus, Yes, maybe I am using a knife. I don't know anything about Access. At this time, I have a crystal report generating an excel output file (data only) that is emailed to me daily. I take the file and append it to a master excel spreadsheet. I would like crystal to output directly to...
  4. TheLibrary

    Crystal 9 Report Output to Excel/Access Database

    Query tool to populate a DB to run from.
  5. TheLibrary

    Crystal 9 - Formula Editor, Field Tree not Docking

    The "Allow Docking" option is not accepting the selection. I can turn the other two trees on and off, but the Field Tree is stuck off (check mark never appears).
  6. TheLibrary

    Crystal 9 - Formula Editor, Field Tree not Docking

    The field tree has floated free! The other two are still docked but the field tree refuses. Help!
  7. TheLibrary

    Crystal 9 Report Output to Excel/Access Database

    Crystal 9 How do I have a report output to a database (excel or access format) and have subsequent runs of the report append the same database file. The database file will be accessed by another report periodically to extract information.
  8. TheLibrary

    Field Tree is not Docking

    Crystal 9 Formula Workshop Undocked the field tree, function tree and operator tree. Can right click function and operator to "Allow Docking" but no success on making "check" reappear for field tree. Seems stuck in floating mode.
  9. TheLibrary

    Selected Running Totals - Use Formula?

    Crystal 9 I need to monitor parts to stock and status of completion: Part No. OnHandQty ShipQty 1000-22 20 10 1000-22 20 1000-22 15 1022-05 30 10 1022-05...
  10. TheLibrary

    Setup Views for Collecting Running Totals on Unique Fields

    Crystal 9 Having trouble setting up a View to create a table where I can store "running totals" for specific field data. I have a date received, part number and qty received (Date, Part, Qty). I must sort by date but I want to show a running total of qty recieved: Date...
  11. TheLibrary

    Running Total that Skips/Selects by Part Number

    Lyanch, "To get the "amt remaining" set up a subselect in your query that totals up all uses for the current partnumber up to (and including) the current date." BullsEye! That's what I am trying to do. I believe the "subselect in your query" means to include the...
  12. TheLibrary

    Running Total that Skips/Selects by Part Number

    Synapsevampire, Thanks for getting in on this one, your help on other issues I have raised has been most helpful! I am researching the View option. The report is for tracking availability of parts for outgoing sales orders. The on-hand qty starts as my current stock (yes, from my MRP). I...
  13. TheLibrary

    Running Total that Skips/Selects by Part Number

    Nagornyi, The running total is not to be displayed, it is to be used behine the scenes to furnish data to the updated QtyOnHand, which is one column. Lyanch, Have Crystal 9, add commands?, how can I "easily handle in a stored procedure"? Are you refering to use of array vaiables? My...
  14. TheLibrary

    Running Total that Skips/Selects by Part Number

    Nagornyi, Yes, 1000 parts tracking independently. Madawc, Speed is not important (overnight batch), could you show me more of how to setup this subreport idea? I've tried subreports and shared variables with no success. Thanks
  15. TheLibrary

    Running Total that Skips/Selects by Part Number

    Good idea, but I have 1000 part numbers.
See more

Part and Inventory Search

Back
Top