Friday, March 23, 2012

Formatting Problem

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:

General Information

Service

P&ID No.

Tightness Requirements

Tag Number

Line Size

Line Schedule

Line No.

Area Classification

Location

Process Data

Fluid

Specific Gravity

Transmitter Spec.

Mounting Type

Model No.

Support Materials

Accuracy

NEMA Rating

Power Supplied

Analog Outputs

Local Display

Operating Range

Dead Weight

Output Signal

Conduit Connection

Live Weight

Gross Weight

Manufacturer

Weigh Cell Data

Mounting

Temperature Compensation

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