on 2011 Oct 20 5:58 PM
I have a query I have built which take the following parameters:
- PeriodOpenDate
- PeriodCloseDate
- Client
- InterestRate
When I execute the query, which simply calls a stored procedure and passes the parameters, I get the following labels for the fields:
- Posting Date
- Posting Date
- BP Code
- BP Code
I want to clean up the labels so they are meaningful, but I am not sure how to proceed. I have seen the thread about creating a User-Defined Table with a map between a fieldname/parameter and a friendly description, but is it possible to just pass a text label to B1 to present or will I have to use a UDT and database query just to get friendly field names?
Thanks in advance,
Rob
Request clarification before answering.
Hi,
UDT is needed here. You cannot bypass this if you want to get meaningful names.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in the UI you can hold ctrl button and left click to rename a field in any data window.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
39 | |
8 | |
6 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.