Sol Web Solutions Blog

Ever wonder how you can calculate the age of the list items in SharePoint?  The Today() function is not allowed in calculated fields, so what's the trick? ...

Upon trying to transfer several Foxpro files into SQL server, an SSIS package was failing.  Error message of: Selected Data Source is on a remote computer.  The bulk insert failed.  We fixed it, but how???? ...

A user reported a bug in an ASP.NET web application, and after running several test scenarios it was difficult to see where the bug actually resided.  Of course after much "hair pulling" and "keyboard banging", we turned to the debugger. ...

Getting SQL Server 2008 Reporting Services series chart line to start @ 0 (trying to mimic another chart in another application that does the same thing) was a bit of a challenge.  The line chart series is being used for accounting and starts at the January amount, say $10,000 for the first month data value. ...

After much searching to try to get around the division by zero issue, I had to create a custom code function for both the report rendering and interactive column sorting to work. ...

Ever have a SharePoint 2007 list where you need to create a custom autonumber column? ...and the ID system column just won't give you what you need?  Recently I found a fix for this issue. ...

When copying a previously created SharePoint site to another SharePoint site, an error was shown of: List does not existThe page you selected contains a list that does not exist.  It may have been deleted by another user. ...

A report is developed, but then the customer makes a request to have the headers visible as they vertically scroll. What do you do? ...

On a recent sub-report, there were 2 rectangles to control rendering, and the page size was left @ 11 x 8.5.The report looks fine in the Visual Studio IDE while developing the report, but if the user tried to print the report or export the report, there was a huge blank space on the page.  What fixed the issue? ...

We had users that were trying to export to PDF, and kept getting Object reference not set to an instance of an object. One work around that we used was when you print the report via the print icon (not an export), change your printer to Adobe.  We are looking into the patch 2008 R2 CU6 as of April 2011 to see if that helps. ...

Recently an upgrade from SSRS 2005 to 2008 threw our team for a loop.  The exact connection in 2005 was working perfectly, but in 2008, the reports were failing.  What was the issue, and how did we fix it? ...

We have a bug/enhancement list we use to show what items have been completed, if they are bugs or enhancement, assignees, etc.The description field is a rich text and multiple lines of text.  When the report is run, the HTML tags show up. How did it get resolved? ...

While trying to edit a Joomla article in IE9, neither the top Save nor the Cancel button would work.  I tried to enable Scriplets in the Tools/Internet Options/Security, but that did not work. ...

On a recent web application migration from ASP.NET 1.1 to 3.5, the AJAX Tookit had some errors where the Update Panel control was performing a full page postback. The culprit was this line in the web.config file: <xhtmlConformance mode="Legacy"/> ...

A Facebook business can like another business. Find the Page you want to follow Scroll to bottom left column and look for “Add to Page Favorites” Click that button and the pages you manage will populate, choose the appropriate page ...another option: Switch from your personal account to the Business Page Account Find the Page you want ...

A personal profile page is designed for individuals. This page allows you to engage and connect with family, friends, and coworkers as you choose. You can add as much personal information as you wish. Personal profile pages also have many privacy setting options, allowing you to control who has access to see certain things on your personal profile ...

How to get the user-friendly Facebook Url Click the following link: http://www.facebook.com/username Select the Fan Page you want to Create the user-friendly Url Enter the name you want to give your fan page and click on Check Availability Don't forget to save it! ...

If you've created a personal Facebook account, and wanted a business account, there may be questions about the difference.  Business accounts are designed for people who only want to use Facebook to administer Pages and run ad campaigns. For this reason, business accounts do not have the same features as personal accounts. Business accounts ha ...

Log into your Facebook account via computer and select Account at the top right corner. Then select Account Settings Scroll down to Account Security Check the box called ‘Login Approvals' Click the "Login Notifications" checkbox to you are notified of account changes This security feature seems a bit tedious to some, and if you may find ...