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 Wanet Telecoms Ltd 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: dk87
  • Order by date
  1. dk87

    Should the ASP server need to be restarted ?

    If you are referring to an .aspx web page, there is no need.
  2. dk87

    Streamwriter to export data

    I am using a streamwriter to create a comma-delimited file. When there is no data, rather than writing ",,," it writes ", , , ". I've tried trimming the field and checking for nulls, but to no avail. How do I fix this? Thanks.
  3. dk87

    Can't reach External Company Web site

    Add a record to your DNS server, or if you don't have DNS internal, you can add an entry to your HOSTS file.
  4. dk87

    Weirdness in COUNT(*) WHERE .... IS NULL

    Rather than a count(*) in the original, does count(AddrId) yield different results?
  5. dk87

    Challenge

    What's to prove? Nothing. Except that some people like to challenge themselves. If you can't compete, don't.
  6. dk87

    identify users locking database

    Take a look at this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;176670
  7. dk87

    v8.5-Totals not coming out correctly

    You may want to try creating a variable to use as a running total. Since you have no grouping, you will not need to zero out the variable. So you will need only two formulas. In the details section: WhilePrintingRecords; Global NumberVar RunningTotal; If not IsNull({Table.Field}) then...
  8. dk87

    store procedure in CR X!

    You can do either or both. What is it you want to do? If you want to pass a parameter from the main report to the subreport, use sub report linking. If you want the user to enter a parameter for the subreport (sp2), don't do anything. They will be prompted. You did not provide much...
  9. dk87

    Pull Related Field To Summary Field

    Ok, so in your detail records, use a formula to check for max(NoteID). You will need to use a variable to make sure you don't overwrite it with invalid data. In your invoice group header: Formula: ClearGroup1 WhilePrintingRecords; Global StringVar strInvNotes; strInvNotes := ''; In your...
  10. dk87

    Code to stop user exiting a text box if null

    Did you try me! rather than me. ?
  11. dk87

    Code to stop user exiting a text box if null

    How about checking the length on lostfocus?
  12. dk87

    Xp workgroup

    Set up identical users on both machines. Since you are not using a domain, they only have themselves to authenticate to.
  13. dk87

    How to check if button is visible

    How about If Me.CM_EditButton.Visible then
  14. dk87

    sql command parameter

    Not running Crystal on this machine but if memory serves... If {?Status} = 0 then ({Command.LICENSE_STATUS} = 1 OR {Command.LICENSE_STATUS} = 2) else {Command.LICENSE_STATUS} = {?Status} Also, use the "View SQL Query" feature and post that along with your selection criteria.
  15. dk87

    store procedure in CR X!

    Yes you can. You can link your subreport to main report data or to a formula.
  16. dk87

    AR Customer Statement problem.

    Maybe try using the current month info as your main report and pull the detail in a sub report.
  17. dk87

    Mailing Labels

    I don't know how you can do it in the mailing label template, but you can group or sort (depending on your data) by client and just fill the page with your desired text. Use the main part of your current report (the white part) to determine approximately where to end each column of data.
  18. dk87

    Pull Related Field To Summary Field

    Can you sort by Invoice, then note ID? If so, suppress the detail lines, and show the details and note text in your group footer.
  19. dk87

    Domain Browsing Problems

    Is this an NT domain or 2k? Do you have domain controllers in other locations? How do you connect your locations (ie Frame relay, DSL, ISDN, etc)? Do you have anything in place that would prevent traffic at certain times of the day (such as ports 135-139)?

Part and Inventory Search

Back
Top