I have a named query that returns a single row of batch data, e.g.:
ID: ABC123
Description: My Batch
WeightSP: 100
WeightPV: 101
Status: Complete
…and I would like to display it in a table, looking just like it does above. However, when I bind the table data to the query, it returns it in a wide format:
ID Description WeightSP WeightPV Status
ABC123 My Batch 100 101 Complete
Is there any way to have the table display in narrow format without doing too much complex scripting which will break my ability to write the dataset back to the database with updated values?