Recent content by MustangPriMe

I'm using SSRS 2012 and trying to build the following chart: A stacked column chart of timesheeted hours, the series being grouped on (and therefore the columns broken down by) department. A single line overlay on a second axis showing the total staff headcount (not broken down) Both charts...

I have a ASP.NET website which uses a module to URL rewriting of page requests (including extensionless). The website started off as a VWD website in ASP.NET 3.5, and works happily on my development and production machines. I'm now upgrading it to a web application in ASP.NET 4, and am...

I have a ASP.NET website which uses a module to URL rewriting of page requests (including extensionless). The website started off as a VWD website in ASP.NET 3.5, and works happily on my development and production machines. I'm now upgrading it to a web application in ASP.NET 4, and am facing...

We've been running CRM 4, and I'd not like to test CRM 2011 to ultimately upgrade. CRM 4 is using SQL 2005. We have installed a new instance of SQL 2012 on the same physical box as the SQL 2005 Server. CRM 2011 itself has been installed on a separate virtual machine. The question I have...

Yes, went there first, and there's a single SMTP connector pushing email out through a smarthost, so I can't see why it's routing email for the other site into a separate local queue. Thanks

We have a VPN link with another site. Both sites have their own domains, active directory and Exchange server. Up to now, the Exchange servers have pushed mail destined for the other site directly over the VPN link to the other server, and all other mail is routed out over the internet. We...

I'm trying to integrate CRM with a bespoke database on another server. I've setup the CRM server as a linked database, and need to query a table from the bespoke database with a Join on the CRM Accounts. The linked server cannot connect to the CRM server using an AD login for various reasons...

That makes perfect sense! Thanks for clarifying Andrea, Thanks, Paul

I'm just trying to get to grips with the security model in CRM. However, one thing is currently confusing me. The concepts of Read, Write, Delete, and the relevant access level (User, BU etc) all make sense for existing records, but what about the Create permission? What is the difference...

Hi Adam, Thanks for the response. Sorry - re-reading my query, I wasn't clear enough in my question what the problem was. Saying that, I also wasn't aware of the "LastIndexOf" method, so that's given me a simpler way of getting the filename - thanks. The query is how do I get that filename...

Got it. That makes sense, thanks. I'm trying to get into the habit of using parameterized queries because of SQL injection. Previously, I'd have just used ... WHERE fldPermissionID NOT IN (" & strSelectedIds & ") ... - nice and simple. This requirement seems like a quite bit of extra work...

I'm trying to parameterize a SQL command with SQL IN() as part of the WHERE clause: Dim sqlCommD As New OleDbCommand("DELETE * FROM tblAdminUsersToPermissions WHERE (fldUserID=@UserId) AND (fldPermissionID NOT IN (@PermissionList));", sqlConn) sqlCommD.Parameters.Add(New...

Hi all, I have a form view on a page to amend a given record in the database. All the controls are bound to an Access data source. The form view includes a file upload control to upload a PDF related to the record to the server. Both the bound controls, and the file upload control are working...

I'm new to ASP.NET, coming from classic ASP, so apologies for what will be a simple problem for anyone with more than a couple of weeks experience, but at least it should be simple to answer! I'm working on 2 pages currently, one with a DataList to list selected fields from a table, and a...

I'm trying to export a table of data to excel, for two languages, using ASP output in an HTML format. For English users, it's fine. In the output I see ...<TD>123.45</TD>... and excel recognises it as a number which can be summed etc. For French users, the output correctly shows...