Search results for query: *

Thanks for the reply. The strange thing is, sometimes the subscription works and at times it does not. When it does not work, it will give the number of errors. I need to find out what error log I can read these errors. Thanks!!

I have a data driven subscription. The status sometimes comes back with the message:Done 23 processed; 23 errors. The subscription is writing 23 reports to a drive file. How can I view the errors? I have been to some of the ssrs logs, however they do not have my errors. Thank You!!!!!!

I need to sort by values within a field. I can not do it within the dataset as it is based on a cube. I am hoping you can do it within the sort tab for the group. A sample of the values I would like to sort by is below: Young 5's Kindergarten 1st grade ...... Thanks for your help!

Thank you for your help. Turns out, there was another table in the report that was calling the same stored procedure. So it was complaining that I did not update that table with the correct parameters. I did not create the report, so no idea this was happening. Thanks again!!

Hi Riverguy, I forgot to mention that everything works fine when I pass one parameter. It is when I pass two parameters that an error comes up ( @SchoolParameter,@AcademicYear). THANK YOU FOR ANY HELP YOU CAN PROVIDE

The problem is, that I execute the stored procedure with the dataset, then I insert the results of the sp into a temp table. So if I set the type to stored procedure, it removes all the code within the data set. I have the top part of the data set below. THANKS!!!!!! CREATE TABLE #FinalResult...

From my data set with ssrs I am calling a stored procedure. That stored procedure is passing two parameters. For some reason, it will not let me pass two parameters. I can pass one, just fine. The error I get is "The value expression for the query @SchoolParameter contains an error" I am using...

Thanks Everyone. Turns out I had to change how I was passing the parameter from reporting services. The function is just fine.

I would like the cell to get wider if needed. Based on what a user selects from a dropdown, the values could vary from 1 digit to 5. If it is 5 digits, I would like the column to show all 5 digits. If there is only 1 digit, I would like the column to decrease in width. Should the autogrow...

I am using a split list function to handle sending multiple values in a parameter. When I send it a value with an apostraphe, it does not work. I have attached the function below. Thanks!!! /****** Object: UserDefinedFunction [SplitList] Script Date: 10/12/2009 13:46:30 ******/ SET...

Perfect!!!! Thanks!!

Hi everyone, I need a string manipulation function to return all of the text to the left of a comma. For example.. City, Large: Territory Suburb, Midsize: With the two records above, I would like to return "City" for the first record. For the second record, I only want to return suburb...

Riverguy, Sorry I got the names messed up. I tried your code example, it was perfect. Thank you!!!!

RiverGuy, The only thing with doing the cases statement that way, is it creates different fields. I need all of the case statement for one field. Looking at my case statement I need all the values to be under the category field. Markos, I will give your example a try... thanks!!!!!!

Thanks Markos, I will run with that type. How does that affect performance. Riverguy....I tried that, and an error came up pointing to the IN operator Thank you for your help!!!!!!!!!!!!!!!!!!!!11

How do you use the IN operator within a case statement? For example I need to do the following Category = CASE J.JobCodeDMID WHEN IN(77,98,965) THEN 'Administration' WHEN IN (62,102,654) THEN 'Teachers' WHEN IN (73,34,693) THEN 'Support Staff' END It seems like I can not use the IN...

It is working. I did not have the word fieldname (IN (SELECT FieldName FROM ) after the select. I thought you wanted the actual field name. Thanks Markos !!!!!! Thanks again George.

If I changed the values for the date parameters, then the results change. If I change the values for the @jobcode and @location, then the results do not change. Thanks for your help

Should'nt the fieldname by L.LocationDWID ??? If not, I guess I do not understand what it is looking for

This is what I use to test the procedure EXECUTE dbo.TurnoverDetail @IncludeTemps = TRUE, @Location = '1,3,6' , @Job_Code = '10,11,12', @fromdate = '11/01/2007', @todate = '01/01/2009'