Eric's Tech Blog

I did a Dynamics Business Central report with an RDLC layout using the txt2nav tool and I have a couple of notes. First, the txt2nav tool uses delta files to generate it's output but if you don't want to compare anything, just export the objects as described in the documentation and rename them to .delta files. Second and most importantly, if you're doing extensions with RDLC files, VS Code will want the layouts in the root folder of your project.  If they're not there, it will create them for you and leave you with reports that have no output.  If this happens to you, you will notice that the copied file is much smaller than the original.  The solution is to either copy or move your RDLC layout to the root folder so that VS Code doesn't try to do it for you.

I had a situation where I needed to create a replica database for reporting using log shipping with two servers that aren't on the same network.  There is an excellent article describing the process on Niall Best's blog .  The instructions got me the setup that I needed on my remote SQL server but when I went to run the restore process, nothing happened. Running the sqllogship.exe command from a command prompt gave me a "Could not find a log backup file that could be applied to secondary database" message in the results.  After confirming that my path settings were correct in the log_shipping_secondary table, I ran the sqllogship command with Process Monitor going.  Process Monitor showed that sqllogship was looking for files named "MyDatabase_*.trn".  Because my primary and secondary database names are the same, I'm not sure if the MyDatabase value is the primary or the secondary.  I would start with the primary and if that doesn't work, try the s