Assorted Frustrations

Had to stop enclosing a section in an Update Panel that had an Export button, since the script apparently does not support downloading of files inside it.  Had to be downloaded through a full post back within the browser.  Using triggers also failed to work. http://stackoverflow.com/questions/5461525/download-feature-not-working-within-update-panel-in-asp-net

Insert -> Group = pretty simple with that. For a subtotal for a group or for the grand total. Click the Sigma sign. Then you can select the field and the subtotal level (grand total or a grouping level). To print to a pdf from within Crystal Report, install CutePDF, a free program.  Then you can go to File->Print and then it will print to a filename and location of your choosing.  You can hide/suppress a level from the "Report Explorer" section. You can switch out a stored procedure with another similar one by rightclicking the sp name, and selecting "Set Database Location". Right Click on side section and select "Fit Section" will remove vertical whitespace. Note: it is possible to get a value from a subreport. http://forums.codeguru.com/showthread.php?449494-How-to-get-formula-field-value-from-Subreport-to-main-report

Server has been under a lot of load recently and some queries are taking longer than usual.  You might see errors like: " Time of error: 3/23/2015 7:01:11 AM Error message: Microsoft OLE DB Provider for SQL Server:Query timeout expired"  Go into the Properties -> Advanced of the "SQL Query" and set the seconds to a higher amount.  If it nothing, it defaults to a much lower amount. 

Surrounded with an UpdatePanel to resolve this issue.  This prevents the "Document Expired" issue if you press the browser back button in the detail. The reason is that when you click the back button the browser is  re-POSTing the same information, and the browser warns you about that. Normally the browser request is the POST/GET, however with the UpdatePanel it uses the XMLHttpRequestObject, which prevents the full page refresh, and does not use the browser POST/GET.   Thus side-stepping the issue. http://stackoverflow.com/questions/11639186/asp-net-webpage-expired-cache-issue http://aspalliance.com/1315_AJAXenable_an_Existing_ASPNET_Web_Page.3 http://stackoverflow.com/questions/21477464/post-back-and-browser-back-button-issue-in-asp-net

This nuke version was an older one, however this kind of error may pop up in different versions.  Had to go back and forth with Nuke Support on this one. First symptom was that I was getting an error in Nuke when trying to reset password with the following: " Admin\Languages\LanguageEditor.ascx.vb(562): error BC30389: 'di' is not accessible in this context because it is 'Friend'. " So with on line 562 added "dim di as object" right before "For Each di In resourcesGrid.Items".  And that got rid of the error above.  But the emails were still blank.  Then he looked at the Admin->Languages _>Site page, at the Site section to try and find the entry for the email language.  However, I got the following error. Getting an error when trying to view that GlobalResources file. "No records to display." Attached image of that. Also when I ran the "Verify Language Resource Files" There were some messages tha

Easiest way I found to clone the C drive is to use the free program Macrium Reflect.  You can select to clone a drive then select the destination.  A 128gb drive took about 30 minutes to clone.

  There are really two DNN upgrade paths.  The first and easiest is when the upgrade goes with a hitch.  The second case is nasty and seems to be very common with DNN.  The second case is when the upgrade fails to produce a working site.   The second case essentially destroys your site and database rendering them useless.  The only way to upgrade DNN sites safely is to make backups of your site folders and the DNN database.    Upgrade failing can occur in a three ways I have seen. The first is that the upgrade process itself fails at some percentage leaving both the site folders and database in some kind of halfway state between versions (ex: permission issue on the site folder).  The second way is that the upgrade completes, but the site cannot be loaded with some sort of DNN error (example :  Parameter count error on site load, but where or what was failing was not logged anywhere).  The third upgrade failure is when you upgrade the site, but there are some critical flaws or oddn

Notes on  Setting up Development DNN Site From Existing Site *Suggestion.  Make backups of your stuff before doing anything!  a. Make backup of the site database.   Restore it to a different database name.   Fix users if necessary.   I the DNN db’s   [PortalAlias] table input what the subdomain and domain will be (like subdomain.domain.com).                 b. ON the web server , create a copy of the site folder.   Make sure to change the web.config Connectionstring and Appsettings to point to development databses. In IIS Make a new Entry for a new site for the Development one, match it to the site copy of the folder.   Check the .net versions are the same (4.0 ,2.0 or 3.5, or whatever) in the App Pool.                 c.   On domain controller find in the “DNS Manager program”.   Right click select new host (“A or AAAA).   Enter in the sub domain on the top.                     d. Take that new fully qualified name (like subdomain.domain.com) and bind it to the site