What I don’t understand is that in typical queries, the Code property can be excluded.
It’s only when you enter Nested Grid that the code property becomes grayed out. I get that the code is required as a key in order to perform the joins tying the data sets together, but why is that information necessary to be displayed?
This is starting to cause issues with regards to being able to send reporting out via automation to outside clients.
On one hand, I can subscribe to the report, and forward it to my clients with all the data they need. However, they will also then receive our internal product and segment codes.
On the other hand, I cannot create automated reporting for these clients and it requires that I first receive the report, manipulate it in excel every time it needs to be sent, save it, and then e-mail the ‘redacted’ copy to the client.
The client needs their data either way, and the current Phocas method of forcing the internal codes onto potentially outward facing reports is problematic.