Recent content by spiego

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?

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:

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...

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...

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...

Sometimes we need the obvious pointed out to us. It no longer gives that error, however, when I first open up this report and go to the data tab, a message appears saying "The Declare cursor SQL construct or statement is not supported." I click on OK and I am able to run the sql. Any thoughts on...

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)...

Thanks xlbo. Ok, I have put together the following statement: =IIF(@RunBy = 1,"Select Distinct INVOICEACCOUNT, SALESNAME From SalesTable Where DataAreaID = 'nuc' AND (INVENTLOCATIONID IN (@Plant))","Select Distinct CUSTACCOUNT, SALESNAME From SalesTable Where DataAreaID = 'nuc' AND...

Thanks mrdenny. How do I pass the value from the boolean parameter to the data set for the customers?

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...

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...

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...

MEL33, Did you find a solution? I am having to do the same thing? TIA

It's running and it shows that it is running on port 6400.

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...