SSRS creating own function? [Resolved]

Posted by Patnaik.Jyoti under Sql Server on 3/28/2012 | Points: 10 | Views : 2281 | Status : [Member] | Replies : 8
Can i create my own function in SSRS reporting Service?




Responses

Posted by: Sksamantaray on: 3/28/2012 [Member] Silver | Points: 50

Up
0
Down

Resolved
Let say you are showing a numeric column in a table .
Suppose Marks now you want that your function should return grade taking marks input.
For that you have create a function .
No go to table cell , then go to expression and call the function like Code.YourFunctionName(passthe marks field here)
Run your Report!!!

Thanks,
Sanjay

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/28/2012 [Member] Silver | Points: 25

Up
0
Down
Yes ,you can create your own function in code editor.

Thanks,
Sanjay

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/28/2012 [Member] Starter | Points: 25

Up
0
Down
Hi, Sanjay
can you let me where is it in detail?

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/28/2012 [Member] Silver | Points: 25

Up
0
Down
While you design a Report in SSRS, if you right click outside the body , you can see ReportProperties.
Clicking on that you can have a dialog box having an option - Code
Click on that- now you have code editor where you can write your custom function.


Thanks,
Sanjay

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/28/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
Thanks ,I got it.

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/28/2012 [Member] Silver | Points: 25

Up
0
Down
Hi,
Mark it as answer , if it solves your problem.

Thanks,
Sanjay

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/28/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
How to call that function?

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/28/2012 [Member] Starter | Points: 25

Up
0
Down
hi,
Gr8,thanks.

Patnaik.Jyoti, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response