Refresh fields in Advanced Print Routing (APR)\ Breaking and Routing

Has anyone found a way, hacky or otherwise, to update the available fields in an APR workflow?

I added a UD field, regened, recycled, but it doesnt appear within the workflow for use.

I’d prefer not to go tweaking records in the DB if at all possible…

As far as I can tell, the entire data structure is built when you (initially) select the break table on creation.

3 Likes

Sounds like you do though…

1 Like

A trace of setting one up might reveal something. Never looked at it.

1 Like

Did you add the field in the report data definition?

No, seems it was auto added\enabled, I did check the RDD to confirm.

2 Likes

Dont tempt me with a good time

3 Likes

hahaha nice man

You need to update the RDD with the new fields, make sure you add teh SysRowID field or none of your UD fields will come along. if you create a new RDD, routing rules cannot (last I looked) change the RDD assigned.

I think someone edited the routing rule RDD in SQL once. Not me, I wouldn’t do that.

4 Likes

Good to know. In this case it and the newly added UD are not excluded from the RDD ds.

Short of redoing 6 more complicated than I would like routings, I may have to pivot. Perhaps creating a new one just to see the refs to the new UD field would be useful :innocent:

1 Like

Just wanted to update that I am not sure what I did, if anything, but after sorting the field list, I can see my field in there now.

2 Likes

I have been doing quite a bit of SSRS recently. My experience is that you can go back any time and add fields into the RDD, and they will be available to select in the Print Routing workflow.

My advice - when you create a breaking/routing workflow it locks in the RDD and you can’t change which one it uses. So always create a custom RDD before adding APR, so that if you do need to add a field later you easily can without recreating the APR. Annoying that you cannot copy/paste within the print routing workflow designer.

3 Likes

I agree, we can do it in BPMS and data directives but not SSRS routing designer.