Home  >  Blog  >   MSBI

Action Properties Dialog Box (Report Builder and SSRS) - MSBI

Rating: 4
  
 
3389
  1. Share:
MSBI Articles

Action Properties 

a) Go to report → refer to the drill-through report concept for this action
b) Go to URL:  → Calling a URL while doing report actions.
Ex: After clicking the respective party location value it displays the respective URL location.

If you would like to Enrich your career with a SSRS  certified professional, then visit Mindmajix - A Global online training platform:"SSRS Training and Certification Course".  This course will help you to achieve excellence in this domain.

Sol: = Switch (fields! Partyloc.value= “HYD”,
“https://www.hyderabade.com”,
Fields! Partyloc.value=”CHE”,
“https://www.chennai.com”,
Fields! Party loc.value = “MUM”,
https://www.Mumbai.com,
is nothing (fields! Paryt loc.value), Error! Hyperlink reference not valid.)

c) Go to book Mark:  → Refer to the chart report concept where there is an example for bookmark option

 MindMajix YouTube Channel

More examples for custom coding

1. Take this code in Report properties public function Vinay msg (by Val opp as string) as str Return “MSBI opportunities at 11 & opp end function
2. In the text box → expression write the below
= code. Vinay msg (“DWH Technologies”)

Frequently Asked MSBI Interview Questions & Answers

Adding custom Assemblies

1) Open an instance of vs.net and create a new class library template. Here I am using C# (you can use any language). Give it a name “vinayhib” and specify its locate on.
2) Rename class1.cs to welcome class. Cs, open it and add the following methods to the class

Public string vinay msg (string name)
{return “MSBI opportunities at “+ name:}
Public static string svinay msg (string name)
{return “MSBI opportunities at “ + name:}

 

In the above case two methods

  • Static
  • Normal

3) Build project, take “vinaylib.dll” in bindebug folder to “IDE private Assemblies” in your machine.
4) Go to report, report  → report properties → references       ↓
Browse: vinay lib.dlc ←             Add     ←     ↓
Add (or) remove classes:
Click ← Add

Class Name                                           Instance name
Vinaylib. Welcome class.cs             My welcome class

5) Take text box and call the functions with the below syntaxes
a) = code.class instance name. Instance method name (List of Para)
b) = assemblyname.classname. staticmethodname (list of para)
Eg:-
=code. Mywelcomeclass. Vinaymsg(“DWHTechnologies”)
 =Vinaylib.welcomeclass. Svinaymsg(“DWHTechnologies”)
 
6) Copy “vinayhib.dll” in the “Report serverbin” folder in your machine

7)  deploy and see the results.       

                   

Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!

List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSAS SQL Server
 SCCM SQL Server DBA
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
MSBI TrainingMar 23 to Apr 07View Details
MSBI TrainingMar 26 to Apr 10View Details
MSBI TrainingMar 30 to Apr 14View Details
MSBI TrainingApr 02 to Apr 17View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15