Link to home
Start Free TrialLog in
Avatar of Shamanth
Shamanth

asked on

Dynamic Hiding

How can we hide columns in Crystal without any white spaces? Is there any auto fit width of fields option in Crystal? Conditional suppression will leave some white space.  
I want to hide some fields based on the user prompt response and dynamically move the fields to the left or right side and adjust the layout
eg:-
I have 10 fields.  I want to hide field 3, 5, 7 if the user input some value in the <? Hide Fields> prompt.  The 4th, 6th and 8th field should automatically adjust/align without any whitespaces.

Thanks!
SOLUTION
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shamanth
Shamanth

ASKER

Thanks rhinok. I will try your approach.

Peter, How do two detail sections help me here. I am not clear.

Is there anyway to shrink the field widh based on a formula/parameter. I see 'Can Grow' option. but it is not doing what i am looking for...
lol - I had to make things much too complicated - couldn't see the forest through the trees...

Peter's approach is better - same concepjt - just create multiple sections and suppress one when the other is displayed....

~Kurt
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you create two detail sections then they can have completely different layouts even though they show some or all of the same fields.
Then in the Section expert you use the conditional suppression button for each detail section and for one you say something like :

{?HideFields} = "Yes"

which will suppress this detail section when the parameter has the value Yes
and in the conditional suppression button for the other detail section you use the opposite condition..

{?HideFields} <> "Yes"
I agree. Peter's approach is much simpler. Thanks everyone for tall the inputs
Thanks
I would say accept Peter's comment as the solution, not your own.  Other than that, I'm good.
COmment being accepted is not part of the solution but simply asker saying thanks
Use this as the solution

peter57r's comment #34926553 (250 points) as the solution and rhinok's comment #34926503 (150 points),  and mlmcc's comment #34926654 (100 points) as the assisted solutions

mlmcc
All,
 
Following an 'Objection' by mlmcc (at https://www.experts-exchange.com/questions/26836410/Automated-Request-for-Review-Objection-to-Split-Q-26831409.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
Vee_Mod
Community Support Moderator