Search results for query: *

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

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

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

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

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

Hi - I have a SQL maintenance plan on SQL 2000 that says to delete backups of more than 3 days. It is failing. I think that since it is part of a maintenance routine job, that also contains backups as a part of the job, it is not deleting the older stuff because it is also failing on one of the...

Hi - I have a report that is a table allowing drilldown. The thing is that I want to hide columns in this table until the user clicks on month - Right now all the details are hidden however it is still showing column name and has a placeholder for the information. I would like it to only show 3...

Hi - I installed SQL 2005 with reporting services...and all was fine. Well, IIS was then uninstalled and re-added through windows components - and now, I still have reporting services and can create reports; however, I cannot deploy them to the reportserver. This is a development machine - so I...

Hi - I have 2 tables, a header and a detail table. What I need to do is be able to select the header contracts when the detail table contains ALL the records in a list value. So, for example I have the following: header table ContractNumber 100 200 300 400 detail table ContractNumber...

Hi - Does anyone know of any SQL tools to be able to track & capture any database (data only) changes that have been made through enterprise manager and/or query analyzer?

Hi - I have a sharepoint site and nobody, not even admin or contributors, can add/upload information to ANY lists - When we try to add content (by hitting NEW button) for a list type, the page opens to add the information; however, the page is not editable meaning that it looks like it is "read...

Hi - I posted a similar question in SRS forum, but thought that I would try here too - I installed SQL 2005 and SQL reporting services 2005 on the server. I do not own visual studio .net 2005 and was told that I do not need it since SQL 2005 will install the VS.net shell for SRS 2005. Well...

Hi - I installed CRM 3.0 and SQL 2005 with SRS 2005 on the server. The thing is that the user wants to create reports from his workstation and not from server. I did some research and saw that I need to install 2 components on client machine: 1) 2005 SRS report designer - which is OK and I can...

When viewing datasets, can you sort by field name instead of field position to make it easier to scroll through fields needed in a database?