Dr. Evil Posted June 10, 2013 Posted June 10, 2013 Hello, thank you for your inters in my topic! Â I'm looking for some help on hiding record titles. In list I have a sub-summary with client name in it. I also have the client name in the body. When list is sorted and the sub-summary is in use I would like to hide the client name in the body. Any Ideas on how to do this or if it can be done??? Â I've attached screenshot to help illustrate the issue. Â I'm guessing I could use some conditional formatting, make the text color the same as the background, etc... Â Any help would be appreciated, THANK YOU!
mr_vodka Posted June 10, 2013 Posted June 10, 2013 Take a look at the Get(SortState) function. You can make your conditional formatting set to a font size of 500 when sorted. 1
Dr. Evil Posted June 10, 2013 Author Posted June 10, 2013 Yea, this was the idea, tho I do not know how to code it up. I will have more then one sub-summary part and I will need to tie a specific title hide to a specific sub-summary sort. Something like this... Conditional formatting formula: If( (Get ( SortState ) Sub-summary#Client) = "sorted"; 1 ) haha... don't laugh
mr_vodka Posted June 10, 2013 Posted June 10, 2013 Well if you have multiple subsummary parts, you can use something like: GetSummary ( zzs_kount; FirstBreakField ) GetSummary ( zzs_kount; SecondBreakField ) This is where the zzs_kount field is a summary count field that I usually use on the ID, and the FirstBreakField / SecondBreakField are the fields you are sorting / breaking on with the report.
Dr. Evil Posted June 11, 2013 Author Posted June 11, 2013 Mr. Vodka!.. This works so perfect, I can't express enough how cool this tip is to me. Thank you!!! I've attached a working demo for others to review, enjoy! redundant_title_hide_demo.fmp12.zip
Recommended Posts
This topic is 4240 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