"тнιѕ вℓσg ¢συℓ∂ ѕανє уσυя мσηєу ιƒ тιмє = мσηєу" - ∂.мαηנαℓу

Wednesday, 12 September 2018

SSRS Error -The report parameter has a DefaultValue or a ValidValue that depends on the report parameter Forward dependencies are not valid.

SSRS Error -The report parameter  has a DefaultValue or a ValidValue that depends on the report parameter.  Forward dependencies are not valid.  

This was actually a simple issue. But the error message was a bit confusing. So thought to post this scenario so that this could save someone's time. 

In our scenario we had a parameter called Country. And this Country parameter was used in another parameter to filter down further. So we had another parameter called States which was based on a query with Country parameter in the where condition along with some other conditions. Now the order of the parameters should be Country First and then States. Otherwise you would see the above error. Its super easy to change the order of the parameters. For the beginners, please refer the below link. It has a screen shot.

How to change the order of report parameters 

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-the-order-of-a-report-parameter-report-builder-and-ssrs?view=sql-server-2017


Azure Mobile App

Azure Mobile app is a cool way to monitor the usage of Azure resources. 

You could easily find it by searching 'Azure Mobile App' either in Google Playstore / Apple app store.

Below are some sample screen shots from the Android version.







Sunday, 5 August 2018

Powerapps- What's new

Two types of business apps could be created using Powerapps.

1. Canvas App ( Apps with great user interfaces can be built using these apps)

 2. Model Driven App ( Starts with data model and then build business process. UI automatically generated)

How to switch between the above apps?

Well, its very easy. When you navigate to https://web.powerapps.com
you could choose the app on the left bottom corner as shown below.



There are lots of learning materials available for these apps. Two are given below.

https://powerapps.microsoft.com/en-us/blog/introducing-model-driven-apps/

https://powerapps.microsoft.com/en-us/blog/microsoft-powerapps-learning-resources/



Friday, 13 July 2018

Azure Bots - Channel Supported Features

If you are developing azure bots you will need to register to channel / channels as well. But some features are not supported in all the channels.  Please see the below link to check which features are supproted in which channels.  For instance, buttons are supported in Skype channel but its not supported in Skype for business. You could also see a preview here

https://docs.botframework.com/en-us/channel-inspector/channels/SkypeForBusiness?f=AdaptiveCards&e=example1

Friday, 15 June 2018

HTML JS JQuery CSS Cheatsheet & Online Editor

Found it very useful. Thanks to Frank who developed it. Awesome job !

Very Useful HTML , CSS , JQuery CSS codes with online editor

http://htmlcheatsheet.com/

Here is a video how to use it 

https://www.youtube.com/watch?time_continue=3&v=6cC3_IZex9Y