In SSRS reports you can easily determine which table columns are visible by default. Not everyone knows that you can give user possibility to choose which columns should be visible.
Continue reading “Hide / show column in SSRS using parameter”
In SSRS reports you can easily determine which table columns are visible by default. Not everyone knows that you can give user possibility to choose which columns should be visible.
Continue reading “Hide / show column in SSRS using parameter”
Using “Lookup” function in SSRS you can combine data from two datasets in one table.
UML notation allows you to use a lot of diagrams that help you to prepare a complete software specification. After several years and projects working as a business analyst I want to point out those diagrams that I think are necessary and sufficent. I will not describe how to create individual diagrams (there is a lot of theory, examples, templates in the web) , but what are their goals and advantages.
Continue reading “Essential UML diagrams in software specification”
Everybody knows how difficult is it to create a good schedule for a project. Today I want to tell you about Budget features in MS Project (screens from MS Project 2016, but it works the same in 2013 and 2010 versions).
Not many MSDN subscribers know about this, but as part of the MSDN subscription you can use the free credits to try out Microsft Azure.
Continue reading “Monthly Azure credit for Visual Studio subscribers”
To set alternating row colour you need to:
Select the row you want to change the height of. With that row selected bring up the properties pane (Alt+enter if you don’t see it). Scroll down to the position group of properties and specify the width and height there. The “cangrow” and “canshrink” properties are useful too sometimes.
http://stackoverflow.com/questions/2386857/ssrs-setting-table-row-height
All you nedd to do is set Hidden property of control to expression:
Continue reading “Hinding controls when rendering report into interactive mode (eg. Excel)”
If You want to break line, put & vbcrlf & in textbox expression
eg.
=”Issue list:” & vbcrlf & Parameters!pListName.Value
If you want to sort dataset/tablix using parameter follow these steps: