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 strongm 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: *

  1. tbpowers

    Sum Formula

    I tried the "WhilePrintingRecords" in the subreport, but the way I have it setup it wouldn't work. I tried passing the formula back to the main report and then setup the "WhilePrintingRecords" formulas and it almost works. For some reason my top record is 0.00 and it leaves off my last record...
  2. tbpowers

    Sum Formula

    I have a quantity field in my main report that I passed off to my subreport. In the subreport I took the quantity field and placed it in a formula ({@Valuation Material Costs}*{@Qty from Main Report}). This is placed in the Group Header. Now I want to setup a grand total of this formula but I...
  3. tbpowers

    Crystal Label

    I have created a crystal lab, but for some reason it prints four labels each time. Anyone know how I can fix this?
  4. tbpowers

    Number formating

    How do I change the options?
  5. tbpowers

    Number formating

    I set up a number field as one of my parameters and appended all database values. However, I can not figure out how to change the format. The current format is 4,611 and I want it to display as 4611 in the parameter list. How do I make this change? Any help will be greatly appreciated.
  6. tbpowers

    Labels

    I have more than one record in my database, but I may only need 5 labels for 5 motors that need to be shipped. All 5 motors will be assigned a serial number, so I need to print 5 labels. I open up my report, choose the part number, and enter the serial numbers I need to show on the label. Here...
  7. tbpowers

    Labels

    That is my main issue with this; I don't have anything that determines the number of records in my report. As it stands it will only print one record. I was hoping that when I setup the serial number as a range parameter that it would print that range with the appropriate numbers. I'm at a loss...
  8. tbpowers

    Labels

    I have copied my label to additional detail areas and used the code above to number. Not the greateast option, but it is working. How can I setup an ending number?
  9. tbpowers

    Labels

    We don't have a serial number in the database. This number is manually created and hand written on a log. The label we're making has to have the number in order to be valid.
  10. tbpowers

    Labels

    I am selecting records based on a part id. Here are the parameter prompts when I run the report. Part Id - drop down menu tied to the part table Serial Number(s) - manually entered (i.e.123-125) Cust Part Id - manually entered
  11. tbpowers

    Labels

    That sounds like my problem. As it stands I have no selection criteria. This is the first time I have created labels, so I'm learning as I go.
  12. tbpowers

    Labels

    Where does the range come into play? I updated the initialize code, but it only shows one record, which is my starting number.
  13. tbpowers

    Labels

    We set the starting number at 123. The label showed 124. We need to see each number, pluged in to the range by the enduser, on each label. We want the user to pick the range at report open, say 500-510. When the report runs we want it to return 10 labels numbered 500, 501, 502, etc..
  14. tbpowers

    Labels

    The user will need to enter the range of numbers when they fire off the report. The numbers will change depending on what part number they need a tag for. So one part may start with 512 and end with 515, the next start at 801 and end with 1001, etc..... Our users do not have access to the report...
  15. tbpowers

    Labels

    I created a label and setup a parameter where I just type in a number I want on the label. This works great, but there will be times when I want to print a range of numbers, one for each label. For example, my start range is 123 and my end range is 124. When I changed the parameter to a range it...
  16. tbpowers

    Autonumber Column

    I set up a new column and would like it to autonumber records. How do I go about this? Here is what I have setup. NMR_No (PK, varchar(30), not null)

Part and Inventory Search

Back
Top