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

  • Users: Crystalfire
  • Content: Threads
  • Order by date
  1. Crystalfire

    Outlook 2003 continues to run...

    After closing Outlook, it continues to run. I can go to the task manager and close it that way. Any Ideas on how to resolve this problem. Running Window Office 2003 with Window XP
  2. Crystalfire

    Group of users

    I have a report that counts the number of days a user has logged into an application within a given timespan. My existing report looks like this: Username # of logons User 1 15 User 2 15 User 3 12 User 4 3 The...
  3. Crystalfire

    Table Field Not showing All

    I have a report in which I have a parameer of Vendor Name. When I try to use the parameter, it only shows Vendors up to Vendors starting with the letter J. If I remove the parameter, the report shows all Vendors. Why is the Parameter limiting my Vendor Choices. I am using the Allow Multiple...
  4. Crystalfire

    Drop Down Menu

    I have created links on one of my Sharepoint pages and when the operator goes to view the drop down menu of the link ( View Properties - Edit Properties .......) the entire widows does not show. It is cut off on the right side and bottom with no scroll bars. Any Ideas. Thanks!
  5. Crystalfire

    Formula result question

    I have a simple formula {QUOTE.CITY}+" "+{QUOTE.STATE}+" "+{QUOTE.ZIPCODE} which sometimes works fine and other time does not bring over any info when there should be. If I use the fields by themselves then the info comes over. Any ideas would be apprieciated. Using Crystal 8.5
  6. Crystalfire

    Error Code

    When I rry to open this access form ( Msster Issues Form ), I recieve the following message: The object"Master Issues Form" isn't open. * The macro you are running ( directory or indirectory ) contains a GoToRecord, RepaintObject, or SelectObject action, but the Object Name argument names an...
  7. Crystalfire

    SitStat.xml error

    I have approximently 100 PC's that I have the Dat file to update atomaticaly. Two PC come up with a " Error occurred while downloading file SiteStat.xml" Any Ideas? I can update manualy.
  8. Crystalfire

    Application Hang Error

    In the event viewer: Hanging Application OUTLOOK.EXE version 11.0.8000.0 hang module hungapp, version 0.0.0.0, hang address 0x00000000. The PC hangs up and is frozen. Must reboot to free up. Event ID: 1002 Using Window XP with OFFICE 2003.
  9. Crystalfire

    Parameter Question

    Crystal 8.5 I have this formula in my report: if isnull({CUST_ADDRESS.TERRITORY}) then {CUSTOMER.TERRITORY} else {CUST_ADDRESS.TERRITORY} What I need to do is create a parameter using this formula. I don't see the option to choose this formula in the parameter selection area. Is this...
  10. Crystalfire

    Need Formula Fix

    I have this formula which works fine until the {QUOTE_PRICE.TRADE_DISC_PERCENT} is null or 0. Then I don't get a value. {QUOTE_PRICE.UNIT_PRICE}*{QUOTE_PRICE.QTY}-({@UNIT * QTY}*({QUOTE_PRICE.TRADE_DISC_PERCENT}/100) ) Using Crystal 8.5
  11. Crystalfire

    Scrolls too fast

    When I open my Outlook 2003 and scroll my emails the messages scroll too fast. I tries the mouse properties adjustment to the number of lines scrolled but it has no effect. Using Windows XP Office 2003.Thanks!!
  12. Crystalfire

    Text Field Limitations

    Does Crystal 8.5 have any limitations in the amount of characters displayed in a text field? I have a comments field which only shows the first 255 characters. Of course there are two to three paragraphs in the comment. Any Ideas or comments? We are on Visual 6.28, Oracle 8i and Crystal 8.5...
  13. Crystalfire

    Is this possible to do ?

    I have Two ( 2 ) formulas called @NEW XXX and @Show This Amount Credit I hope I can explain this right, but what I need to do is have a Cumulative sum of both formulas shown as Need This EX: @NEW XXX @ Show This Amount Credit Need This...
  14. Crystalfire

    New Page Setting

    I have a report in Crystal 8.5 that shows information for each GroupName ({RECEIVABLE.CUSTOMER_ID}. What I would like to do is have the report show each group on its own page.Where would I make this setting. Formula? Thanks!
  15. Crystalfire

    Sum of Formulas

    I have a formula {@test} shown below; Sum ({RECEIVABLE.PAID_AMOUNT}, {RECEIVABLE_LINE.INVOICE_ID})/Count ({RECEIVABLE_LINE.LINE_NO}, {RECEIVABLE_LINE.INVOICE_ID}) Everything works fine but I need to get the sum of this formula in the report. Is there a way to do this. Crystal 8.5
  16. Crystalfire

    Summerized Fields input

    if Sum ({@new amount}, {@NEW TEST GROUP})=0 then 0 else Sum ({@Total }, {@NEW TEST GROUP})/ Sum ({@new amount}, {@NEW TEST GROUP})*100 This formula shows the % of gross profit I need to see on my report. Its work fine but I cannot insert it into a crosstab I need to create. It does not show...
  17. Crystalfire

    Groups in Columns

    I need to have a report show Group 1's in a column format. EX: Group 1 = ASIA " 1 = CANADA Group 2 = LP " 2 = SSF So instead of showing up as ASIA LP SSF CANADA LP SSF I need it to look like: ASIA CANADA LP ( Group...
  18. Crystalfire

    Problem with isnull Field

    Works good except when the {CUST_ADDRESS.COUNTRY} is null. Then I still need to see the {CUSTOMER.TERRITORY}. How do I insert that isnull factor into this formula? Thanks! if {CUSTOMER.COUNTRY}<>{CUST_ADDRESS.COUNTRY}then {CUSTOMER.TERRITORY} else if isnull ({CUST_ADDRESS.TERRITORY}) then...
  19. Crystalfire

    Modify Current Formula

    This formula limits the AccountID's I need to see. I had a request to also show the account # 30850000 but not any accounts between 3080000 and 30850000. How would I modify this formula. Thanks! {RECEIVABLE_DIST.POSTING_DATE} = {?POSTING DATE} and {RECEIVABLE.INVOICE_ID} = "INV-10355" and...
  20. Crystalfire

    Division by 0 error

    When using this formula I get a Division by 0 error. Count ({CUST_ORDER_LINE.CUST_ORDER_ID}, {CUST_ORDER_LINE.CUST_ORDER_ID})/Sum ({SHIPPER_LINE.SHIPPED_QTY}, {CUST_ORDER_LINE.CUST_ORDER_ID})=0 Crystal 8.5

Part and Inventory Search

Back
Top