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 Chriss Miller 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. genekr

    Equipment needed?

    Thank you very much.
  2. genekr

    Equipment needed?

    What would I need to setup a home wireless network? I have a cable modem, so I assume I would just plug the incoming cable to a wireless router. Then, would each of the PC's/Laptops need a wireless card to connect? What type of card. Sorry, so basic questions. I checked FAQ's and White...
  3. genekr

    Create view in PSQL 9

    Super. Thank you very much.
  4. genekr

    ToText/ToNumber not working for number field

    Awesome! Thank you very much.
  5. genekr

    ToText/ToNumber not working for number field

    I've tried using Whileprintingrecords; stringvar MyDate:=totext({APDISFIL.AP_DIST_DATE},0,""); val(mid(MyDate,5,2)) and it seems to sort correctly, but I also need to group by the month and when I try it the @month formula, which I uesed above, does not show up a a group option.
  6. genekr

    ToText/ToNumber not working for number field

    I have a field that is a number field and is displayed 20,051,101.00 which is a date 20051101. I need to take just the 5th and 6th char's to be able to sort by Month. I've tried (ToText(mid({APDISFIL.AP_DIST_DATE},5,2))) but get error "A string is required here" and it highlights...
  7. genekr

    Wrong field values displayed

    Thank you. I'm embarassed. I must have had a really bad brain cramp this morning. Thanks again for your assistance. Gene
  8. genekr

    Wrong field values displayed

    I have a report where I have a parameter that selects from a drop-down menu that display's all the default values in a field. There is only 1 table in the report. CR9, PSQL9, W2K3. When I select one of those values, it displays all of the values in the field rather than just the one I...
  9. genekr

    Create view in PSQL 9

    Good morning. I'm very new to PSQL and need to create a view. Is it possible to take a value, have that value in a view and take the first 5 char's and put that in another field and the second 5 chars and put that in another field. My result should be like: Item Main...
  10. genekr

    Do not include items where 8th & 9th char = PE or RE

    Worked super. Thanks synapsevampire !
  11. genekr

    Do not include items where 8th & 9th char = PE or RE

    I have a report where I do not want to include any item numbers where the 8th & 9th char's are PE or RE. CR9, PSQL9 Server 2003. This is my formula: (not ({IMITMFIL.ITEM_NO} startswith ["ALMISC", "ALSCRAP", "AWELD"])) and {IMITMFIL.ITEM_NO} >= "A%" and {IMITMFIL.ITEM_NO} <= "AZ%" and (not...
  12. genekr

    Parameter Mask

    I may not have been specific enough. CR9, PSQL9, W2003 server. The user is only going to know the 4 digit number, not the whole string. Is it possible to have them enter a parameter of 4402 and have the report select file xxx4402xxxx ?
  13. genekr

    Parameter Mask

    Thanks all. I'll try it. Gene
  14. genekr

    Parameter Mask

    Is there a way to take a field, xxx4402xxx, and in the parameter select only char's 4,4 to run the report on? I thought I could do it with mask, but am having some difficulty. Thank you. Gene
  15. genekr

    Insert Sum into Formula?

    Yes, grouped on {imitmfil.item_prod_cat}
  16. genekr

    Insert Sum into Formula?

    I put: if isnull({imitmfil.item_prod_cat}) then 0 else {imitmfil.item_prod_cat} in a formula but it's giving me an error that says: "A number is required here" and it highlights the last line of the formula {imitmfil.item_prod_cat} The field item_prod_cat is a char field with a size of 3...
  17. genekr

    Insert Sum into Formula?

    Thank you. I tried using this as a formula in the Group Header if Count({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) > 0 then sum({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) /Count({cphsttrx.hist_trx_sale_amt},{imitmfil.item_prod_cat}) else 0 but I still get the error A...
  18. genekr

    Insert Sum into Formula?

    Actually for Sale Amount, I'm taking (Sale Amount)/Total Qty Sold. I couldn't enter a Sum for a formula. All these calculations I'm putting in the Group header because I'm grouping on the Code.
  19. genekr

    Insert Sum into Formula?

    Crystal 9, PSQL 9, W2003 server. I have a report where I'm taking a specific Code Category, Sale amount, dividing it by Lbs sold to get $/Lb. Code Total Lbs Sold Sale Amount $/Lb 60 172.80 $392.80 $2.2731 For Total Lbs Sold I'm using {Qty...
  20. genekr

    Take certain chars from a field and multiply by another field

    My mistake. Thank you.

Part and Inventory Search

Back
Top