If you are like me and have a report that dynamically calls a sub report that then calls sub reports (using the sub report control), you may have run into the occasional sub report overlap nightmare. The latest encounter for …
Active Reports 6 – Inputbox
Instead of passing a parameter to a report with a value set to preexisting data, you can instead prompt the user running the report with an inputBox (Microsoft.VisualBasic) in order to capture the data on the fly to be used …
SQL Server – Loop through an existing table and process a column with a delimited string
As mentioned in my last post (Loop through an existing table), I said that I would expound on its example by reading a column that contains a delimited string. In this case, it will be an address that …
SQL Server – Loop through an existing table
In T-SQL you may want to loop through an existing table and do something. You may want want to use this type of processing in a SSRS report.
Here is an example of walking through a table that simply extracts …
SQL Server Reporting Services (SSRS) – How to union or join tables from different databases on the same server
This example applies to SSRS 2008
SELECT a.datafield1 As Col1, a.datafield2 As Col2, b.datafield6 As Col3 LEFT OUTER JOIN databaseB.dbo.Table4 b on b.datafield6 = a.datafield1 FROM databaseA.dbo.Table5 a UNION SELECT a.datafield7 As Col1, a.datafield8 As Col2, b.datafield12 As Col3 LEFT…
SQL Server Reporting Services (SSRS) – How to page break when main report calls a sub report which calls sub reports
When all else fails, add the page break to the row group of the main report.
…
Microsoft Visual Studio – How to log LINQ sql calls
How to log SQL when using LINQ to SQLs DataContext
‘Dim LINQ log variables
Private sbLog As New StringBuilder Private swLog As New StringWriter(sbLog)
‘Execute of LINQ ** dcNwind is the instantiation of the DataContext **
dcNwind.Log = swLog
‘To …
Microsoft Visual Studio – How to Strip RTF Data
Dim mRTFData As String = '{rtf1ansiansicpg1252deff0deflang1033{fonttbl{f0fromanfcharset0 Times New Roman;}{f1fnilfcharset0 Arial;}}
viewkind4uc1pardsb100sa100f0fs24 BLAH BLAH BLAH rdblquoteparparpardf1par}'
Dim mStrippedofRTFData As String = String.Empty
If mRTFData.Length > 0 Then
If (mRTFData IsNot Nothing) AndAlso _
(mRTFData.Trim().StartsWith("{rtf")) Then
Using rtfTemp As New System.Windows.Forms.RichTextBox()
rtfTemp.Rtf … SQL Server – Finding duplicate records
Finding rows on a table is straight forward when filtering on columns, but what if you want to find duplicate data.
Let’s say I have a table that represents parents and children. The key to the table is the parent …
WordPress – Stop trackback spam
In Settings/Discussion, uncheck the box “
This will stop trackback for all future trackback spam.
To modify your older posts, you need to change the ping_status to “closed” on each row …