Band "header" on left edge, and "footer" on right edge
I'm using FR 4 for the first time. I'd like my multi-column band to have something equivalent to a "header" on the left edge, and a "footer" on the right edge.
My report has a TfrxSubdetailData divided into 4 columns. This particular section should appear as a mini-table. That is, to the left of that band, there should be some "row labels" -- labels that apply to all four columns. And to the right, the there should be row suffixes -- effectively, additional row labels.
For example, this section should have a layout something like,
What is the best way to do this?
If it makes a difference, not all rows in this mini-table will have the same type of data. That is, a few rows will show the "volumes" measured in vehicles/hour (as shown in the above example), while other rows will show the number of lanes, the lane widths, etc.
Using a multi-column band has worked out very nicely for me for populating the contents of the mini-table, but I haven't figured out how to add row labels. I understand that FR supports cross-tab reports, and these would seem to be better suited for this purpose, but most of my report is not a table -- just this one subdetail data band (and one other that I'll create next).
My report has a TfrxSubdetailData divided into 4 columns. This particular section should appear as a mini-table. That is, to the left of that band, there should be some "row labels" -- labels that apply to all four columns. And to the right, the there should be row suffixes -- effectively, additional row labels.
For example, this section should have a layout something like,
                  Northbound  Southbound  Eastbound  Westbound
Through Volume:Â Â Â Â Â Â 540Â Â Â Â Â Â Â Â 620Â Â Â Â Â Â Â Â 380Â Â Â Â Â Â Â Â 407Â Â Â Â vehicles/hour
Left-turn Volume:Â Â Â Â Â Â 79Â Â Â Â Â Â Â Â Â Â 45Â Â Â Â Â Â Â Â 51Â Â Â Â Â Â Â Â 63Â Â Â Â vehicles/hour
Right-turn Volume:Â Â Â Â 38Â Â Â Â Â Â Â Â Â Â 82Â Â Â Â Â Â Â Â 54Â Â Â Â Â Â Â Â 61Â Â Â Â vehicles/hour
What is the best way to do this?
If it makes a difference, not all rows in this mini-table will have the same type of data. That is, a few rows will show the "volumes" measured in vehicles/hour (as shown in the above example), while other rows will show the number of lanes, the lane widths, etc.
Using a multi-column band has worked out very nicely for me for populating the contents of the mini-table, but I haven't figured out how to add row labels. I understand that FR supports cross-tab reports, and these would seem to be better suited for this purpose, but most of my report is not a table -- just this one subdetail data band (and one other that I'll create next).
Comments
For my purposes, it would suffice to simply put extra data bands to the left and to the right of my existing band.
A workaround has given me acceptable results. I added two additional columns to my multi-column band, and for the Memo of the TfrxMemoView on each row, I coded a script to print a column-dependent value. So the first column prints a row label, the last column prints the units, and the interior columns print the data. A typical script looks something like
It's a shade more cumbersome than I'd hoped, and it doesn't allow different widths for the data columns compared to the "header" or "footer" columns, but the result generally satisfies my needs.