Hey there,
I know this is backwards from the way the pivot subquery works.
There’s a single row of data (header record) in a UD table I need to display on a form sheet. It’s 140-odd columns. I’d rather not enter 140 text boxes plus labels, but maybe display them in a grid where the user can scroll up and down.
Anyone done this?
Thanks,
Joe
Hi Rob,
I don’t think I was very clear. No, I have just one row of data, an order header, but it has a lot of columns – too wide to display in this grid format. I’d like to do something like a paste-special/transpose in Excel, where it turns the columns into rows. I might have to convert it by hand, or just define a bunch of textboxes to display the data.
Thanks,
Joe
I would programmatically create the objects in a foreach loop of each field. Less code and less objects in your customization in design time (run time may be affected though).
When people want one-off things on a multi-pane dashboard I have built a ‘strip’ pane where you can just add unrelated stuff. To get as narrow as possible with a union query everything has to be cast to text but you can stack up the header, then the item underneath. People seem to like it and once set up it’s easy to add an item without reformatting the screen.
Oops just realized the OP wanted this for an updatable dashboard, I don’t think this union will work for that application
