Search results for query: *

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!

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

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

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

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

I am passing A muli select paramater from ssrs to a stored procedure. Within my stored procedure I am using the splitlist function to separate the values. However the error I get is Invalid object name 'SplitList'. WHERE @Location is null or L.LocationDWID IN (SELECT * FROM...

When I create a stored procedure or view it always appends dbo at the beginning of the name. What is the command to use so it does not add the dbo to the front of the name. THANKS IN ADVANCE FOR ANY HELP!!!

We have a database on a server. With 3 different users trying to access it. When one person is in the database, no one else can get into it. When that second person trys to open the database, they get a "File already in use" message. Please HELP! Thanks

Within a sql query, I am creating a field based on a case statement. CASE WHEN X IS NULL THEN 0 ELSE X END Temp Now I need to compare the created field (Temp) to an existing field. I have tried a sub query, but no luck. Thank you in advance for your help.

I am trying to connect to a sharepoint list from SQL Reporting services. The error message I get is "The XmlDP query is invalid. (Microsoft.ReportingServices.DataExtensions)". Has anyone tried this before? Thank you in advance.

I am receiveing the same error message in two different situations. I am using 2005, when I try to import an access database I get the error message (Microsoft.SqlServer.DTSRuntimeWrap). Also when I am using SQL Business Intellegence, and I try to create a connection for a package I get the same...

I have an access program that runs my business. I would like to print checks from the program like quickbooks. Has anyone did this before? I know about the convert function to convert numbers to words. THANKS!

Does anyone know if Access works with Hand Helds? I would like the hand held to have an access database on it, and then at the end of the day sync with the main database back at the office? Is this possible with Access. I know it is possible with .NET THANKS FOR ANY INPUT!!!!!!!!!!!

I am trying to open an access database. The database does not have security permissions attached. But when we try to open it we get the error message "do not have necassary permissions". We can not export the tables to another datbase either. We get the same message if we try to import the...

I am importing an access table into Microsoft project. I would now like to automate this procedure by writing an on open macro within project. I have not programmed in Project before, but lots of experience in VBA. Can anyone help or at least give me a couple of ideas? THANKS IN ADVANCE!

We have imported some data. The import has combined two fields into one. I would like to break them back into two fields. There is a space in between the two values (fields). How can I trim the field once there is a space? Thanks for your help!!!!

Througout my database, when we open a form, before it actually opens we get a "flicker". I think it is the form I leaving. Everything is working fine, but this flicker is very annoying. Has anyone experienced this? Thanks in advance!!!!!!!!!!

I have one sub form on my main form. I am trying to set a check box value from my sub form, to my main form. So when I click a button on my sub form, it checks my check box on the main form. The last expression I tryed was Me.Parent!ControlName Thanks for your help!!!