Hi,
I'm trying to format the output of a report and can't seem to figure out how use the Matrix control to get what I want. Currently, I have it formatted as:
General Information <-- Head
Tag Number Line Size Line Schedule <-- Information
Service P&ID No. Tightness Requirements
Line No. Area Classification Location
Process Data
Fluid Specific Gravity
Transmitter Spec.
Mounting Type
NEMA Rating Power Supplied Analog Outputs
Ideally I'd like to have it formatted as:
General Information <-- Header centered
Tag Number Line Size Line Schedule
Service P&ID No. Tightness Requirements
Line No. Area Classification Location
__ <-- Divider Line between sections
Process Data
Fluid Specific Gravity
__
Transmitter Spec.
Mounting Type
NEMA Rating Power Supplied Analog Outputs
Any ideas or suggestions would be greatly appreciated. This shouldn't be THIS hard to do.
Thanks,
John.
It'll be a lot clearer to understand if you make up your examples in Excel and then just copy paste that into your post.|||Adam,
Thanks for taking an interest. Ok, here's what's going on: I'm trying to render information where I have multiple (unknown at design time) Catagories which have multiple Attributes (also unknown at design time). The relationship is One Catagory, Many Attributes.
I'm using a Matrix control because it seems to be the Control to use? If it's not, let me know. What I'd like ideally is to: Add a Line to separate the different Catagories (i.e. General Information, Process Data, etc.), and center the Catagory title. Currently I'm forcing the Matrix to wrap at 3 by setting a property in the List Control's "Edit Details Group..." property to: =Ceiling(RowNumber(Nothing)/3). If you have any ideas on how to solve this through the designer, please let me know.
Here's an example of the data as it's currently being rendered:
Power Supplied
On a side note, I've tried adding a Line control to the List, but it renders on every line. I also have no way to detect when the last line of a Catagory is being rendered. I've tried every way I can think of using the tool, but it's just not working for me.
TIA,
John.
|||I would suggest placing the matrix inside a list control. Group the list control by category which will result in a separate matrix being rendered per category. You can then place the category in a textbox above the matrix and also inside the list and center it.|||Adam,
Mad thanks, that did the trick!!
John.
No comments:
Post a Comment