Answer Questions

• maria_tachi Hiding group header/footer lines

  Is there any way to hide header/footer group lines in a table without displaying the white space For Example: Group 1 Label1 Group 2 Label2 Group 3 Label3 Detail If I put an expression in the visibility property of Group 2 to make Group 2 invisible for certain groups, it also makes Group 3 and the detail invisible as well. If I set the visibility to Label2 to hide the text for that group header, I still have the wh ...Show All

• Roger Tan - MS How to Update or Delete records with a SqlServer Destination

  I'm a novice to SSIS (and we've never used DTS). Writing a Control flow that inserts records worked fine, using lookups and all, but i can't find somewhere an example on how to update records of even delete records. Any suggestions .... Thx Harry Leboeuf   Harry Leboeuf wrote: (and we've never used DTS). This is a good thing. it helps not to have a DTS mindset   Ha ...Show All

• Robin27015 SQL Server 2005

  I have just recently downloaded and installed vs2004/ss2005.  So now I have the version of ss that comes with vs2005 and the developer edition of ss.  I have been able to work with  sqlexpress thru vs2005 but not with the developer edition.  When I engage the configuration manager which is what I guess to perform the same function as the enterprize manager in ss2000, I am unable to find my databases.  What am I miss ...Show All

• amitsinghkohli Understanding ADO

  Hello, I want to use OLE DB in my projects. Since I start my work with ADO, I have some troubles and questions.At first, I have MDAC 2.8 SP1 and SQL Native Client from MS SQL Server 2005. Here's list of them: What difference between "SQL Native Client" and "Microsoft OLE DB Provider for SQL Server" I have troubles with understanding API cursors: all my sql-statements always returns Forward-Only Cursor Type. Here's little test about it w ...Show All

• Gabriele Bertolucci SQL Server Connection problem

  Hi All I want to connect SQL Server in a remote pc [Windows XP] from my pocket pc but it gives an error message that SQL Server does not exist or access is denied But when I connect SQL Server in a pc running under Windows 2000 professional it works fine waht is the problem behind it please send some information Regards Bijaya It may be the Windows Firewall on Windowx XP. If it is turned on, and you want to access the S ...Show All

• Matt Milner - Pluralsight Can not change filter on model report - UPDATED 7th June

    I have a very simple report based on a test model. The report is filtered via a date field and runs ok. If I try to change the filter I get the following error message: Operation Failed Short time pattern does not include hours and minutes Does anyone know how I can correct this Regards John  UPDATE This only happens if I try to filter between two dates, a single date works correctly! ...Show All

• Damjank Reporting and the Express Products

  I have successfully downloaded and installed the VS C# 2005 Express, Web Developer 2005 Express, and SQL Server 2005 Express. I currently have VB.Net 2003 and SQL Server 2000 (Developer Edition). In the SS2K environment, I am able to develop reports using Reporting Services. In the xxx2005 EXPRESS suite, I have yet to find any reporting capability remotely approaching the Reporting Services functionality for SS 2000. The MSFT marketing info (e. ...Show All

• Remi 42 Dynamic (Parameterized) Page-Breaks

  Hi, I have a report, where depending on a parameter-value (e.g. Change in day: Yes/No), I need to display the records in one page or multiple pages (i.e. If Change in Day = Yes, display the records for each day in different pages. If No, display all the records in one page). In-short page break for each day, if there is a change in day, else no page break. Can anyone suggest, is this possible to do with SSRS 2005 RTM I had read somewhere t ...Show All

• Gustavo Carrazoni Error adding a new job

  I'm creating a new job and getting a failure when applying it to the server. When I script it is seems to work fine via SQL management studio. I haven't added any steps or a schedule yet, could this be the cause of the error the errors are a bit nebulous to say the least (hopefully the sql server errors will get passed through in next service pack)! Anyway heres the code, its a mixture of smo and my apps code: //refresh jobs from server, r ...Show All

• Peter999999 Incompatible Data Types question

  Hi, I've got a dimension table with an Int32 primary key.  I have a few fact tables that have an Int16 field, which is acting as a foreign key to the dimension table.  I can't actually change the data types of these tables in the SQL database, but I'd still like to create a cube that uses those 32 bit dimension tables with the 16 bit field entries.  Unfortunately, the cube designer won't let me specify a relationshop between the t ...Show All

• S Robbins Transfer SQL Server Objects Errors

  Hi. I'm totally new to SSIS (SP1), and I'm having a raft of troubles transferring DB's using the 'Transfer SQL Server Objects Task', which seems to be the closest replacement for the old DTS Transfer Objects tool. I'm trying to transfer a DB from an SQL Server 2000, where I only have SQL Server authentication (it's a shared hosting environment) to my local SQL Server 2005 server, where I'm logged in using Windows Authentication (although I have ...Show All

• Craig Harris Cannot create new or change existing subscriptions

  We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says Only members of sysadmin role are allowed to update or delete jobs owned by a different login When trying to create a new subscription the report manager displays "An internal error oc ...Show All

• Chris Lyon - MS Very important question about SQL Express and SSIS

  We're developing a WinForm app that is being deployed via ClickOnce.  The application will have the ability to import/export data with the intention of this being done via SSIS.  When this app is deployed and run against SQL Express, the following error gets generated: “Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to error: 80040154”. Is SSIS functionality suppo ...Show All

• abhi jain SQL Server scripts - Encoding type for file

  Hi I generated a script of my trigger or any other object and save it as a .sql file from SQL 2005 Management Studio. When I open the file in notepad I see the encoding type as UNICODE. I want the encoding to be ANSI because we have a version control tool wherein the .sql files with UNICODE encoding wouldn't show up. I have a huge batch say 3600 sql files that need to be encoded to ANSI. Is there any tool that can do this or any help wo ...Show All

• Alex DeJarnatt MSR Error exporting a subreport to Excel!?

  Hi All, I have a report sonsisting of two subreports. When I export it to Excel I get an Error!! I played around with it and I found out that if I use ReportItems in my page header it will cause this error! Does anyone have any idea why Is this a bug or there is some work around it! Thanks. Thanks for the reply. My case is different! I don't have a table or matrix with subreport in it! I just have a plain page with subreports. Exporting to ...Show All