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: spiego
  • Content: Threads
  • Order by date
  1. spiego

    How to get NDRs when the "From" email address is a distribution group

    When I send an email to a bogus address where the from address is a distribution group (which I am a member of) I do not get an NDR sent to me. When I look at System Manager, it shows that a NDR was generated. How can I get the NDR to show up in my inbox?
  2. spiego

    How to get fields to line up?

    I need the times to line up. How can I do that using the expression below? =Join(Parameters!DelDay.Label, space(15) + Parameters!time.Label + vbcrlf)+ space(15) + Parameters!time.Label When I run the report it displays the following result:
  3. spiego

    How to get a total after using the switch statement?

    I have a cell in my report that has the following statement Switch(Sum(Fields!Baskets.Value) >= 1 and Sum(Fields!Baskets.Value) <= 59,1,Sum(Fields!Baskets.Value) >= 60 and Sum(Fields!Baskets.Value) <= 108 ,2) Is it possible to get a sum of the values at the end of the report from the above...
  4. spiego

    How to convert a statement done in Crystal Reports to SSRS

    I need to be able to do the following statement in SSRS. What is the best way to do it? Select Sum {ARM340L1.Qty} Case 0: " " Case 60: "24/36" Case 72: "24/48" Case 84: "36/48" Case 96: "48/48" Case 108: "36/36/36" Case 120: "24/48/48" Case 132: "36/48/48" Case...
  5. spiego

    Parameters and Stored Procedures

    I have a stored procedure that I am using to create a report. At the end of the stored procedure I have the following select statement (rptset is a temporary table created in the proc): select * from @rptset where rordered!=rshipped If I want to use parameters from the report to...
  6. spiego

    Must declare the scalar variable &quot;@shippingDateConfirmed&quot; message

    In SSRS 2005 when I execute the query shown, I get the message shown below. Any ideas on why it is complaining? declare @rptset Table( rSalesName nvarchar(100), rCustAccount nvarchar(10), rInvoiceAccount nvarchar(10), rStoreName nvarchar(100)...
  7. spiego

    Dynamic Parameters

    I have a report where the user wants to have the ability to run it for either a bill to customer or a ship to customer. I currently have a boolean parameter "Run by bill-to customer?" and it defaults to true. Along with that is a drop down list of the bill-to customers. What I would like to do...
  8. spiego

    Weird Issue with Message Tracking

    I am having a weird issue with the Message Tracking Center in Exchange 2003 that seems to have started this morning. When doing a query on anyone (Sender or Recipient) it will not show any results for today after ~7:10 PST, but when I go and look in the folder where the logs are stored, it is...
  9. spiego

    Public Folder and Calendar issue

    For some reason when I create a calendar under Public Folders and give permissions (Author) to another user, that user is unable to see the calendar listed under public folders. I even had them close Outlook and come back in, log off the computer and log back in. Still nothing. Why can't they...
  10. spiego

    CMS error when connecting to CE XI

    When connecting to the respository from CR XI, an error message appears saying the following: CMS host 'address name' address was resolved properly, but cannot be reached to establish a CMS connection. Verify that your router/firewall communication is port 6400. The interesting thing is that...
  11. spiego

    Upgrade issue to 2005 in SBS

    I am testing out the SBS 2003 R2 (premium edition) upgrade from SBS 2003 SP1 (premium edition). The upgrade to R2 went fine; however, when running setup to upgrade from sql 2000 to 2005 a message appears saying that the install was blocked due to an invalid upgrade path. Shouldn't I be able to...
  12. spiego

    Registry mod via Group Policy

    Is it possible to modify the registry to a client's computer via Group Policy? If so, how? I want to add a value to the following entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Exchange\Client\Options TIA
  13. spiego

    Strange findings in the Message Tracking Center (MTC)

    Exchange 2003 While looking at the MTC for a user who was having some email problems, I noticed some entries where it was reporting that this user was sending email to the System Attendant. I have never seen this before, so I looked at his sent items folder and there is nothing there to...
  14. spiego

    Display holidays in a calendar

    Is there way to have a calendar in Sharepoint show the holidays like you can in Outlook? I'd rather not have to type them in or have someone else do it. Thanks.
  15. spiego

    Rename CompanyWeb domain name

    I am running SBS 2003 and I am just now getting into playing with SharePoint. I noticed that the default domain name that it uses is http://companyweb. However, I would like to rename it to a domain name that reflects our company name. How do I accomplish this? This is strickly internal, so I...
  16. spiego

    Unable to register local server in EM

    When logged onto the server, as administrator, that has SQL2K installed and I go into Enterprise Manager and drill down on the local server, I get an error "A connection could not be established to (LOCAL). Reason: Cannot open user default database. Login failed." I deleted the registration and...
  17. spiego

    Turn off BCC???

    Does anyone know if there is a way to disable the ability to BCC within Outlook XP/2003? Thanks, Dean
  18. spiego

    Internet_45 Error when using ActiveSync

    When trying to use activesync via GPRS to our corporate email, I get the Intenet_45 message, which states that "The security certificate on the server is invalid." However, that is not the case for we purchased a certificate via Equifax and it is good until next year. The server is running...
  19. spiego

    Odd Behavior

    I just installed VB .Net Pro on my XP Pro box and wrote a very simple app that is to display a form with two buttons, OK and Exit. Each button has a shortcut key assigned to it. When the OK button is pressed, a message box is to appear with a text message on it. Here is the odd behavior...
  20. spiego

    Replace SCSI HD with IDE HD

    I have a PC w/ a SCSI card that has a HD, CD drive, and a CDRW drive connected to it. The HD is ready to crash on me, so I went out and bought an IDE HD. With the IDE HD, I set the jumper on it to be the master and then connected it into the IDE slot on the MB. I then disconnected the SCSI HD...

Part and Inventory Search

Back
Top