So you want to use this formula as a SSRS formula?
In that case, it would be something like this:
iif(Fields!event_type == "c","R" + Format(Fields!event_type,"####0"),iif(Fields!event_type == "i",Format(Fields!event_type,"####0"),"P" + Format(Fields!event_type,"####0"))
Not 100% sure about the format function though, so you better check if it works.
ps: ik ben van België, maar ik spreek Nederlands 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP