Search results for query: *

This ended up being very easy. There were different versions of SP on different computers. I had to update them to be the same version and then the errors vanished.

Hi -We have SQL Reporting Services running in integration mode with Sharepoint and we recently updated sharepoint when we installed SharePoint Administrator Toolkit. We are now getting the following error everytime we run a report & I am thinking that something has to be changed on the report...

Hi - We have SQL Reporting Services running in integration mode with Sharepoint and we recently updated sharepoint when we installed SharePoint Administrator Toolkit. We are now getting the following error everytime we run a report & I am thinking that something has to be changed on the...

one time. OMG Skip, you are the best!!!! Thank you so very much!!!!!!!! This worked like a charm. Also thanks for the fast reply and have a great weekend!!! Angela

Hi - I have data for example like this: SmithTomandJane JonesAbbyandSam SothSandy TraceCasandra What I need to do is find the true "and" and remove it. I was hoping to find "and" where next letter is capital and replace with nothing so results would be: SmithTomJane JonesAbbySam SothSandy...

xlhelp - this is great and works for most. Just not something like LewisLisa where the first cap is the same as the second (L and L). But this gets me very far very quickly and I can just clean up the others manually since this is Data Conversion and only one time. Awesome! Thanks for the...

Just an update. What I did was created 26 diff columns and used the formula =find($A1,"A",2) and then =find($A1,"B",2) and so on for each 26 letters. This returned the position of the letter. Then I did a count and the ones that were 1 I was able to use the len and parse out. I am now having a...

Hi - In Excel 2007 is there an easy way (or anyway) to take one field and separate into 2 fields when the first upper case letter appears? For example - I have one column with the following SmithJane and would like one column to have Smith and another column to be Jane. Thanks for your help!

Hi - Can someone offer ideas? I have a report that has a lot of formatting and contains a subreport as well as one table in the body. The table only has 3 rows of data but this data contains a lot of records. I was hoping just for that table to be able to repeat the data ont the right side to...

The 380 report file was about 15 min...I just found out that adobe reader isn't installed on this machine...I am installing it now to see if that would help at all. I am going then to try the 714 page export and note the timing. I know that it doesn't sound that long for one file, but we have...

Hi - I created a report that has no graphs or anything but it has a subreport. The subreport is very simple with only one table...Anyway, the report generates fairly quickly but it takes an extremely long time to export to PDF. The report is large. This particular one is 380 pages and it is...

Hi - I have a question. We have had some performance issues with an application and have done a lot of traces. if there aren't any performance problems, the application routine processes in minutes. When there are performance issues, the application processing can take over 2 hours. It appears...

Hi - yes, I have. The config tool shows all green arrows and is ok. IIS appears to be working and set up fine. At this point, we may just uninstall and reinstall since we cannot seem to locate the issue.

Hi - I need some help. We had an existing SQL instance 64 bit configured correctly for SQL reporting services. Someone actually installed a new instance of SQL on the box - 32 bit instance - and decided to install SRS again too. Well, we started to experience all sorts of issues. We did some...

Hi - I have a table across 150 databases and I want to do a simple select statement and get the results from all companies in one view. I tried a cursor but it doesnt work in the FROM statement. Any ideas on how to be able to select FROM many different databases instead of doing something like...

Hi - is there a way to dynamically set page break group options? Sometimes we want a page break per group and sometimes we do not. Can you point me down the right path? Thanks for any assistance.

Thank you for the information. I have a call to Microsoft and they have put OS tools and SQL tools - so hopefully we will know what is causing the problem. I tend to agree that maybe it is a hardware issue - thanks!

I should have said this initially - nothing is listed in Application log or sql log for an error. I finally got SQL to start after waiting 1/2 hour - so there must be a memory leak - related/unrelated to SQL I do not know. So, I have to see if there are any ways to capture memory leaks - I guess...

Hi - All of a sudden, a sql server with SP 4 on Win Serv 2003 SP 2 is hanging. I cannot launch SQL services without causing server to hang. Server is fine until SQL 2000 services start - It appears that the databases start up and that perhaps it is hanging at tempdb. I saw the error before that...

Thank you - that is what I thought but wanted to confirm!!! Thanks!!!