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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fnpuff

  1. fnpuff

    SQL 2005 - System.OutOfMemoryException

    Hey SQLBill, Using SQL Server Management Studio, I looked into the "Activity Monitor" and things look normal (low). From the Performance Monitor I looked at; SQLServer:General Statistics / User Connections = 16 Do you know how I can find out if Windows is not terminating idle connections...
  2. fnpuff

    SQL 2005 - System.OutOfMemoryException

    Specs: SQL 2005 (9.0.1399), Win 2003, 3GB Ram We have 2 SQL Servers running 4 databases each, the servers are in different offices (sister company). Server_A goes down (IIS) about every 2 weeks with an error message of: Exception of type System.OutOfMemoryException was thrown. Server_B of...
  3. fnpuff

    Record Count changes when I add Chart

    Found out its a problem with a lockup table. Thanks
  4. fnpuff

    Record Count changes when I add Chart

    No formula, testing this a on a new blank report. Olny thing I have on this report is the Chart. Chart Data on change of: regions.name-A Show value(s): count of Programs.programnumber
  5. fnpuff

    Record Count changes when I add Chart

    Note, I tried distinctcount and that did not help
  6. fnpuff

    Record Count changes when I add Chart

    There are 273 Programs in our database (SQL). I can display this with a summary count of Programs.ProgramNumber. Problem I'm having is when I insert a pie chart using a count of the same field above I get 274 as my total. Any suggestions? and does this happen often?
  7. fnpuff

    CR XI - 3 Pie Charts using same fields

    Thanks LB, that looks like it will work great. Any books you know of that explain simple syntax code?
  8. fnpuff

    CR XI - 3 Pie Charts using same fields

    I have a working Pie Chart pulling data from 2 different places. I will do my best to explain below, but my question is, I would like 3 different pie charts using the same data but based on when the data is entered into our database (sql 05) 1st Pie chart is done: shows the total count of all...
  9. fnpuff

    Convert Y & N to Yes and No

    I am new to Crystal (Ver XI) and this is probably a simple question (sorry.) Pulling data from SQL 05. Table "Program_dates" field "Confirmed" currently shows "Y" & "N" I need to view it as "Yes" or "No" I thought I could use a Boolean but I’m having no luck. Thanks in advance for the help.
See more

Part and Inventory Search

Back
Top