SSRS routing info... is that in the database somewhere

Kinetic ERP
1

Does anyone know if the details of the routing are stored anywhere in the DB? Like… who it will email to, etc.?

2 Likes
2

I think this comes from Breaking/Routing at the report style level. Is that what you mean?

1 Like
3

Yep, it’s stored at ReportStyleRule.RuleBody
The entire routing is stored in its entirety as xml, which is annoying if you want to query specific components.

4 Likes
4

And breaking/Routing is all tied up in that stupid Kinetic Power Tools thing…

2 Likes
5

I have functionality to edit it from my Dev Tools dashboard, but I didn’t publish it yet, because the XML is super ugly.. it needs an abstraction layer to make it decent to work with in kinetic.

I’ve had luck describing a schema for it to a gemini gem i have configured and doing some edits that way.

3 Likes
6

I wish they’d keep Classic Directive and BAQ designers in Power Tools while the bugs in the Kinetic versions get worked out.

4 Likes
7

Thanks let me check that out. All good, I’ll figure out the XML thing.

2 Likes
8

Right, thanks Gabe. I’m trying to build a system task agent report that shows what is routing/emailing to people on schedules.

2 Likes
9

Cool! That’s how I know where to find the info, I was doing the same thing. I don’t need it, need it, so never got around to sorting out the xml parsing bit. Just been reading xml with my eyeballs like a caveman ever since.

4 Likes
10

Haha, I mean I just started reading it last night to see what I would even parse… it’s not that helpful when logic is complex, but it’s a start. Thanks again.

1 Like