Shadowfax Posted August 26, 2005 Posted August 26, 2005 Hi, I'm having a lot of trouble trying to build a particular report. Perhaps this will seem like a really simple problem to you FM wizards, but I'd definitely appreciate any help you can offer. I'm trying to create a report that shows: An Hour -- A Segment ----- And Any Guests Under That Segment The trick is that instead of being stuck with the phrase "Segment 2", the user must be able to modify that label name to whatever he/she wants. My initial thought was to have a "lines" table. This table has a row for each hour, segment, and contact. While there are numeric hour & segment fields for grouping purposes, the user-modified 'DisplayName' is to be shown on the report. However, whenever I group by hour, I cannot display the DisplayName field! Only the Hour field may appear. The same goes for Segment grouping. Perhaps this is impossible to do within a sub-summary, but I can't seem to think up an alternative. Is this whole "Lines" table a wrong approach? Or can I display a non-grouping field within a sub-summary section and I'm just doing it wrong? Thanks in Advanced!
aaa Posted August 26, 2005 Posted August 26, 2005 Display Name field you can see only for first record of group.
Recommended Posts
This topic is 7366 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now