Answer Questions

• John Hensley Header Textbox linked to Body Text box only showing data on first page???

  I have a field in my report that I want shown in my header. I have followed the directions in MSDN about doing this and have a text box in the body that is linked to the field parameter. textBodySiteNumber.Value = Fields!SiteName.Value  Then I created a header text box that has an expression to the body text box.. textHeaderSiteNumber.Value =ReportItems!textBodySiteNumber.Value Now, this does work... sort of... what I end up getting is ...Show All

• namlow How to convert a timestamp into dateTime in SQLServer 2000

  Hi Everyone,   We have a table in SqlServer 2000 with a column type TimeStamp and contain value such as 0x00000000656AC51F. Are there any way for me to convert that value back to DateTime I tried to use cast function like: Select cast (MyTimeStampCol as DateTime) myDate from MyTableand I encountered error below.   Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type dateti ...Show All

• Anky_007 Is this possible? How

  hello guys, I want to create a report using a bar chart data region from a cube. The cube contains Date and Time dimentions. Here is my question: The catagory field (x-axis) value of the bar chart is dependent on the paramaters value(i.e.StartDate and EndDate). For instance if the difference between StartDate and EndDate is greater than 1 year, the x-axis value for the bar chart should come from the Date dimention and display the year value. ...Show All

• Patrick Strateman Report Subscription sends wrong version

  I have a report that's scheduled to run once a month on a timed subscription (using a shared schedule).  The Report Delivery Options are set to include the report as a PDF embedded within the email notification.  The report has also been set to record a snapshot each time it is run. The first month, the report was embedded as planned. The second month, the wrong report was sent.  The PDF that was generated in the prior month ...Show All

• Seba Gomez (gmail) from Express to 2005? - How to?

  I have a database on SQL 2005 Express and i want to restore in SQL Server 2005 Beta 2 but it's not accepting it so how can i do it please any tool ..and in addition to that the license of beta is no longer valid since the RTM was published. if you want to move forward get a RTM version of developer or any version you want to migrate to. HTH, Jens Suessmeyer. --- http://www.sqlsevrer2005.de --- I ass ...Show All

• urs_r Using the same connection in multiple threads -> native exception

  I found a peculiar thing today while working with SQL Mobile in a multithreaded application (VS2005, application for Pocket PC 2003). I created a class which has one SqlCeConnection object. Every time I call a function to insert/select/delete something from the local db, I open the connection, execute the query an then close the connection again. But when I'm calling a function from the db class in thread 1 and in the meantime call a diff ...Show All

• xizzy44 ENDPOINTs in SQL Server 2005 April CTP

  Hi I've been happily using VS2005 Beta 1 to access ENDPOINTs on SQL Server 2005 Beta 2 for a while now with no problems.  Having just upgraded to VS2005 Beta 2 and SQL Server 2005 April CTP I now get this when I make a call to the ENDPOINT web service: "The request failed with HTTP status 505: HTTP Version not supported." Also, if I try to access the WSDL just through Internet Explorer by putting " wsdl" on the end of the url, I get: " ...Show All

• Kannan Pothi Creating "installation" script

  Hi all, I’m newbie with SQL Server. I need to create a installation script SQL (creating tables, indexes, permissions, databases). This script calls other scripts. In Oracle I use @script_name.sql, but in SQL Server I don’t know to do this. Other question: Is there a way to call the Query Analyzer in .BAT file, where the .BAT file calls installation scripts SQL. Thank U very much, []’s Yes sure you can do this, you have to call the equiva ...Show All

• Adam Boczek Can I set Excel connection manager's data source as a variable?

  I do not know the Excel file name to load in design time. Would like to pass the value to a variable in the package in run time How to do this Thanks, Guangming Property Expressions is the feature you want. You can assign and expression to most properties, including the DataSource property of a connection. The expression would just be the name of your variable, e.g. @[User:MyVar] Some UIs expose expressions ...Show All

• Kristofer Liljeblad Command line tools missing

  I have read about the dtexec utility, but I can not find this on my installation. Is it a seperate install or do I need to reinstall Bob How I found it was by clicking on Start-->Run then entering in dtexecui.exe Bob Everland wrote: I have read about the dtexec utility, but I can not find this on my installation. Is it a seperate install or do I need to re ...Show All

• Shula System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found

  I am trying to figure out how to correctly reference the directory to my subscriptions: Dim subs As Subscription() = rs.ListSubscriptions( "/SSS" , Nothing ) System.Web.Services.Protocols.SoapException: The item '/Hedi' cannot be found. ---> FYI: I replaced sss for privacy purposes only here Just saw your recent post.  let me have a look. because the "/" character is bein ...Show All

• gambas Invoice Pagination - How do I start next costomer on new sheet when needed?

  Someone has to have asked this question before but I could not find the answer.  I did find some places, not on this site, with the question. Basically like the title says, I'm just doing for a different purpose but figured invoicing would be the most popular reason.  If the last page of a group prints on the front of the sheet then I need to advance past the back of the sheet and onto a new sheet to start the next group.  ...Show All

• jbassmanp Does SSIS have these features????

  1> Support for rules based and change-data-capture extracts 2> Push and Pull methods supported 3> Convert between ASCII and EBCDIC 4> Ability to extract from packages like SAP and Peoplesoft natively 5> Extract from multiple sources simultaneously 6> Support for native database features like database bulk loaders 1 . Both the s ...Show All

• AndyHopcraft Synchronizing Data Within SQLCE and SQL Server 2000

  hi, Problem: Synchronize the data between sqlce in pocket pc emulator and sql server 2000 in desktop computer. Given: i have configured the IIS and while connecting the pocket pc IE to sql ce server agent..evreythings ok. called the synchronize method. ERROR: normally two error occurs: native error 29045 and native error 29006 connecting with sql server reconciler failed.. any bidy can tell me what is sql server recon ...Show All

• StuartF How to create a cover page

  This seems like it should be a very simple task. I need to create a cover page that appears as the first page of all my reports. It contains a confidentiality statement and I don't want any other report information on this page. I created the cover page in a separate report to be used as a subreport in any report that needs the statement included. However, I have searched all over the Web (including this forum) but cannot find any info on how to ...Show All