Posts

Showing posts from 2015

Push notification with SignalR across session state

Using SignalR is pretty simple for implemeting push notification service. One thing to keep in mind is:  SignalR connections (including the connection underlying all Hub operations for a client) do not support Session state. So it's not possible to access session data from signalr hub. Now let's assume one scenario, where we need to perform a database operation on postback ( e.g. post action in an mvc controller ) based on a user action and after that we need to redirect to a listing/default page. But we want to let user know if the operation succeeded or not. Here is a Hub implemented to send client notification: Here is how it is initialized: And here is the client side script: The final thing is to invoke the client side  showNotification() function when the redirected view page is loaded. But problem is: the calling page and the redirected page are two different views and the session state is changed in the meantime. After redirection client hub in...

Adding dymanic filters in reports with SSRS

Image
SSRS report paramters doesn't support runtime selection of operations by default. For example: we want to let users filter data by checking any criteria that equals, not equals or contains any specified value. W e can achieve this by using ssrs expressions. Below is outlined a step-by-step guide to do this. Following is a snapshot of a simple cube to be used in this example: The cube contains orders data including two measures: quantity of products and dollars of orders. It has four dimensions, but for this example lets focus on the Product and Quality dimensions only. The aim is to create a report to view total dollars received from the orders per product quality for specific product categories . Before starting we need to create the reporting project using SSRS and then add the data cube as a shared datasource. I've also added a dataset using query designer. It includes Dollars as measures and Product Name, Category, Quality to group the measure va...