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 Rhinorhino 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: TheLibrary
  • Content: Threads
  • Order by date
  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 - Formula Editor, Field Tree not Docking

    The field tree has floated free! The other two are still docked but the field tree refuses. Help!
  3. 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.
  4. 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.
  5. 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...
  6. 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...
  7. TheLibrary

    Using SubTotal in report, can't sort data

    Crystal Reports 9 I have a data source that contains monthly details of sales forecast for each product: Part No. Month SalesQty 7000-01 1-04 100 7000-01 2-04 250 etc SubTotal 2,500 I have a report that needs to include only the SubTotal amount...
  8. TheLibrary

    Running Total that Skips/Selects by Part Number

    Crystal Reports 9 I have a simple report that I want to add a running calculation for on hand inventory and order shortages: ShipDate Part No. ShipQty OnHandQty ShortQty 1-10-04 7000-01 10 15 0 1-10-04 8125-99 20 40...
  9. TheLibrary

    How do I suppress specific Graphics/Lines?

    Crystal Reports 9 Is there a way to have a line or graphic image conditionally suppressed? Thanks
  10. TheLibrary

    Delete .mdb Database Table

    I have a .mdb file that I keep appending tables to. How can I delete the tables I no longer need. I'm using Crystal Reports 9 to export a .rpt file to ODBC format into my existing .mdb file (using xtreme.mdb). Each time I have create a new table name. Thanks
  11. TheLibrary

    Create .mdb database file using Crystal Reports 9

    How do I create a database file .mdb using crystal? I have access to data in ODBC, but I need to have it summarized into a table so I can use it in other crystal reports. I don't want to use subreports. I don't have Access. I can easily create a .rpt file for what I want, but I can't find a...
  12. TheLibrary

    Linking Subreport to Subreport

    Crystal Reports 9 I have a subreport linked to the main report. How can I have a 2nd subreport linked directly to the 1st subreport? Option doesn't appear to be available.
  13. TheLibrary

    Cross Tab limiting # of columns of date/time data values

    Crystal Reports 9 Using a date/time value for the columns. Select Expert is not allowing date/time value as limiting factor, SQL fails to open rowsets (see previous thread). Supression of the CurrentFieldValue for the date/time value does prevent the display of the date/time, but the...
  14. TheLibrary

    Failed to Open Rowset - Select Expert Date Criteria

    Crystal Reports 9 Attempt to use Select Expert to limit entries based on date/time values and I get the following error messages: "Failed to open rowset" "Details: 22007:[IBM]Client Access Express ODBC Driver (32bit) [OD2/400 SQL] SQL0180 - Syntax of date, time, or timestamp...
  15. TheLibrary

    Alert Condition - Missing Report Formulas in Workshop

    Attempting to create an alert condition based on existing formulas in the reports formula fields and running total fields. When I enter the formula workshop from the alert condition button, not all of the formulas are listed in the report field section. Appears to ignore formulas with...
  16. TheLibrary

    Formula to Link Subreport retrieves only some data

    Crystal Reports 9 In the Main report I have a string field called NAME. The text is usually 7 characters long, but sometimes 10 (carries extra irrelevant letters). I have defined the formula LeftNAME as Left{NAME,7} in the Main report. The Subreport database has matching data for only the...
  17. TheLibrary

    Linking Subreport Based on Formula Fields

    Page 371 of The Complete Reference Crystal Reports 9 states "Once you've created the formula in the report that contains the separate Name fields, the Name formula field will appear in the Subreport Links dialog box and you can choose it as a From or To linking field". I have defined...
  18. TheLibrary

    SubReport Link using String Formula

    In the Main report I have an available field IMLITM which has data that includes variations of basic part numbers (such as 7123001, 7123001*OP1 and 7123001*OP2). I need to link to a SubReport that only has the basic 7 character part numbers in the related field WMCPIL. I want each of the...
  19. TheLibrary

    Program to print report's tables, links, formulas, settings?

    Where could I find a simple program to help establish a documentation record for my crystal reports? I know I can export the report as "file definition" format and create a text file, but is there a better software option? Suggestions?
  20. TheLibrary

    Don't count weekends/holidays in date formula ?

    I have a formula to check if a date is less than 3 days into the future. If {Date} < today()+3 then &quot;hot&quot; else &quot;ok&quot; How do I make the formula overlook weekends and holidays? (only check for &quot;workdays&quot; on my company calendar) Advice?

Part and Inventory Search

Back
Top