Martin Hart Turner's Q&A profile
SharePoint Products and Technologies Use Reporting Services to print SharePoint lists?
Has anyone found a way to have SQL Server Reporting Services dynamically generate reports of SharePoint 2007 lists based on the onscreen filtering/sorting and the underlying SharePoint View (columns, groupings) We like the flexibility to give power users a way to set up their own custom views of SharePoint lists but we need to find a way to let them produce reports based on their views. Unfortunately, our users still have a requirement to generate professional looking paper reports. The print capabilities of IE7, although much improved over IE6, are still not good enough for reports that are sent outside of our company. Specifically missing from IE7 are customization of page headers/footers (for company names/logos); and the abillity ...Show All
SQL Server SQL Server Performance Testing? ...
Hi all, We're looking to migrate our SQL Server cluster from a handful of huge boxes to a new blade with some AMD dual-core processors. The OS will be Windows 2003 I think. We of course want to test the new implementation to make sure it performs at least as well as it did before. I think we plan to do some performance testing by hitting SQL Server directly, rather than going through an end-user's application (like a web site). I've used LoadRunner to test a bunch of things using different protocols, but never to hit a DB directly. Are there any other good freeware/open-source tools I should be considering Any tools from Microsoft to do this We're fairly well grounded in performance testing in general, but could use advice re: hittin ...Show All
SQL Server how to include the nulls??
Hi, I have the following query stored: SELECT dbo.OrderDetails_Retail.ProductID, dbo.OrderDetails_Retail.ProductName, SUM(dbo.OrderDetails_Retail.Quantity) AS ProdQtyPerWeek, DATEPART(wk, dbo.Orders_Retail.OrderDate) AS SalesWeek, YEAR(dbo.Orders_Retail.OrderDate) AS SalesYear FROM dbo.OrderDetails_Retail INNER JOIN dbo.Orders_Retail ON dbo.OrderDetails_Retail.OrderID = dbo.Orders_Retail.OrderID WHERE (dbo.Orders_Retail.account = @Account) AND (dbo.Orders_Retail.OrderStatus <> 'Deleted') AND (dbo.Orders_Retail.PayStatus <> 'Pending') AND (dbo.Orders_Retail.OrderStatus <> 'Refunded') AND (DATEDIFF(d, dbo.Orders_Retail.OrderDate, @StartDate) <= 0) AND (DATEDIFF(d, db ...Show All
Visual Studio 2008 (Pre-release) Set Url for XmlDataProvider in Code?
Hello, how can i set the DataSource for XmlDataProvider in code When i try this, i get the following error: "System.Security.SecurityException" Fehler bei der Anforderung des Berechtigungstyps System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089. Code: Dim x As New XmlDataProvider Dim u As New Uri(url) x.Source = u <-Error Thorsten Sorry, my english is not really good You might have to give full trust, http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=740994&SiteID=1 ...Show All
SQL Server Filtering Records Created Today [Cast or Conversion required?]
Thank you for your time: Trying to populate an SQLdatasource with records entered today, based on a select statement against a single table containing DateTime field that defaults with GetDATE() upon insert: sample = 01/18/2007 14:31:02 Can't find the right combination in WHERE clause to make it work. Tried the following with no result records: TRIED: Pasting an existing value in QueryBuilder Filter = '2007-01-18 10:45:28', but it auto corrected into WHERE (CreateDate = CONVERT(DATETIME, '2007-01-18 10:45:28', 102)). Resulted in row of NULL fields TRIED: Editing the auto code above to WHERE (CreateDate = '2007-01-18 10:45:28')... Resulted in row of NULL fields TRIED: Possible function statements (DATE(), NOW(), TODAY()) th ...Show All
Visual Studio Tools for Office VSTO Visual Studio 2005 Problem
I have been trying to install VSTO SE Beta. But after the installation the new project types (office node) are not available in visual studio 2005. So i can't start to develop. Ok... Windows XP Professional (German) Office 2007 Professional (Beta) (German) Visual Studio 2005 Professional (German) VSTO 2005 SE Beta i can't found vsto projects nodes in vs after the installaton. Thank You..... ...Show All
SQL Server Padding blank spaces when exporting to PDF?
I know that some people have already asked this question, but answers were not usefull to me. I want to export the content of my textbox to PDF and can't find the way to save it's formating on pdf. I'm creating a report for invoice. I have one TextBox at the end of report for displaying terms of payment. There can be several paragraphs in this text. This text is stored in one column, which is nvarchar, in database. Is there any way to keep the blank spaces that I use at the beginning of paragraph Is there any non-printable character that won't be ignored when trying to insert a new paragrapf in PDF I can't use tab and blank spaces-these are ignored. And I don't know how many paragraphs there will be-this changes. ...Show All
SQL Server Can't add database to projects
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=497273&SiteID=1 I have gone through the above and, while I can connect to the sql server and activate connections, I can not add a sql database to a project. Open a project Right click - add new item Choose sql database or Add existing item choose existing sql database results in: "Connections to SQL server files (*.mdf) require sql server express 2005 to function properly blah blah blah" Like I said, I can connect to the DB through the server explorer and view table definitions and data. I just can't add one to a solution. I have reinstalled sqlexpress already and am trying to avoid having to reinstall visual studio. OK, is the SQL Exp ...Show All
Microsoft ISV Community Center Forums Loop causing MS Word freeze
I tried to run a simple loop I created as a macro employing a user form that contains a label and a command button. I want the label caption to alternate between OFF and ON as the command button is clicked. There must have been an error of some sort as when I ran the macro it froze MS Word completely. No compile error ever appeared and the macro DID begin to run without protest. I looked at the task manager and everything under MS Word was "not responding". I ended the macro under the task manager and MS Word completely shut down! Here is the code. I realize it is not structured correctly, but should trying to run it cause MS Word to to freeze up and require a shut down via the task manager Surely it can't have creat ...Show All
Visual Basic win forms DataGridView Save Update Delete
What is the .Net Professional way of saving , Editing, Deleting in DataGridView. Mirza Ashraf, According to your code in the post, it seems that you are familiar with the VB6 because of the Pointer int variable looks like the RecordSet in VB6. In your code sample, you try to show each rows in the TextBox controls. However, you never create the DataTable on the columns and rows in the DataSet for your table. I suggest you to read the related information on the DataTable class and try to create a DataTable object with the DataColumn, then add the rows in the table. The following link shows the DataTable class and there is the code example on creating DataTable by program. Please take a look at the code and have a try: http:/ ...Show All
Visual Studio Express Editions Change date format in DatePicker control
I want to cahange the date format in the datepicker control to Eg:-1-Jan-06 I know the string is "dd-MMM-yy" i just dont know where to use this what's the exact code you used I cannot see this error during compile or runtime, with option explicit set to on also make sure you added, just before setting the customformat value: Me.theDateTimePicker.Format = DateTimePickerFormat.Custom Me.theDataTimePicker.CustomFormat = "dd-MMM-yy" ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Unable to render mesh
Hello there, guys! I've a little problem with Direct3D9. I'm following a book written by Jim Adams, called "Advanced Animation with DirectX" This book show you how to extend the classes D3DXMESHCONTAINER and D3DXFRAME, and using them to render meshes. Now i'm trying a my example, that you can see here http://phpfi.com/182098 But there are some problems: At first, the mesh is not rendered, i've tryied so much position with camera but nothing i can't find it., but the Device->Clear works... I'm also using a simple shader, here is it... float4x4 matWorld; float4x4 matView; float4x4 matProj; float4x4 matTotale; texture TextMesh; sampler2D STextMesh = sampler_state { texture = <TextMesh>; MIPFILTER = linear; ...Show All
SQL Server Exporting results grid to CSV file, header isn't exported
Hi all.. By using SQL Server Management Studio 2005 (and even in SQL Server 2000 Query Analyzer) when a result of a query is shown in the grid, and then export that data to a CSV file, column names aren't exported. Is there a way to do this Thanks Jaime Hi Is this posible in SRS 2000 also I am also facing same problem when exporting data to CSV. I didnt find the Query results pane in Tools - Options of VS2003 environment while designing SRS 2000 reports. Regards ...Show All
.NET Development Access to remote folder
Hi, I have an app which must read, change and save (update) files on remote PC. I have a special user/password to access the remote computer. Is there any way to loging to remote computer from inside the app, do the job and then log off. App works fine if I logging to remote PC before starting nut I don't like this. I'd like to have evrething hidden from enduser. Thanks Oleg Hi, I have the same problem. I can "net use" to the file share using a user name and password. But I can't do it using .NET code: NetworkCredential ncred = new NetworkCredential("administrator", "admin_pwd", " mymachine "); CredentialCache ncache = n ...Show All
Windows Live Developer Forums Could not get performance report today
Here is the response for my request to generate performance report: < xml version="1.0" encoding="utf-8" ><soap:Envelope xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/ " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Server was unable to process request. ---> |-400063|-1|ERROR_API_REPORT_NONE|</faultstring><detail /></soap:Fault></soap:Body></soap:Envelope> This is the first time I saw that. Any ideas --Wei Hello Wei, It seems that ...Show All