Skip to main content

Andy Wingate

Search This Blog

Simple expression to Hide things in SSRS

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

=iif(logical expression, true, false)

Using the if function to colour text the same as background for quick fix on divide by 0 errors in the middle of a report.

SSRS

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Popular Posts

QNAP installation of Serviio - a free DLNA server.

QNAPs come with a media server pre-installed ready to go - Twonky - which is pretty decent app with iPhone apps for beaming and controlling playback from your library. However, after a recent update Twonky was unable to play MKV files. It did appear that by renaming the files to .avi or .wmv they could play, but that is a rather boring solution to the problem. I read that Serviio could possibly do the job better so set out to install and test. First needed the JAVA files from here . You can download either Java SE for Embedded 7 or Java SE for Embedded 6. The version you need is either "ARMv5 Linux - Headless EABI, SoftFP ABI, Little Endian" (for Java 7) or "ARMv5 Linux - Headless EABI, SoftFP, Little Endian" (for Java 6). Put the file into your /share/Public folder leave it as .tar.gz also for some reason the file only downloaded properly with IE. After installing JRE crack on with the Serviio install, there is a QPKG you can grab here http://forum.servii

Dynamics 365 BC - Architecture and Compliance

I am often asked to about the architecture and compliance for Business Central SaaS. There is a huge amount of info to be found on this topic across multiple Microsoft docs pages. Below I have collected together a few handy links and images from these pages. Architecture Here is a simple diagram of the Business Central Architecture Component and System Topology - Business Central | Microsoft Learn Figure 1 - BC system architecture simplified overview With BC SaaS direct access is not possible to any of the elements shown in the grey box as these are all managed by, and are the responsibility of, Microsoft. Web Servers Application Servers SQL Databases Data Protection On the SaaS platform your data is treated in the following manner Security in Business Central - Business Central | Microsoft Learn Here is a simplified view of the authentication layers to access the application Layered security model in Business Central - Business Central | Microsoft Learn Figure 2 - BC uses a lay

How to filter the current user with measures in your Dynamics 365 Business Central embedded Power BI report.

Embedding Power BI reports directly in Dynamics 365 Business Central is one of the many synergies of the Microsoft 365 platform. Giving users context relevant analysis right on the page where they need to see it helps make faster and better decisions. Previously I have looked at how to easily publish a new data set as a web service from BC and use this data in a Power BI report shown on the BC role center page . An interesting requirement that came up this week was the need to filter a BI report to only show data related to the current user. Initially row level security was considered; but this was not as easy to implement as using a basic visual filter and the 'Measure of a Measure' approach. Credit goes to the Power BI community, the original solution was described here and here . This approach relies on your data model having the user emails on the rows you wish to filter to. Add 2 new measures to your data model to the table

Powered by Blogger