Groups

[Joel]

I have multiple fields in a detail per my group. Is there a way to have
different fields depending on the group value.

e.g. If my group value is New Jobs, i want fields like PO Date, and
estimated ship date. But if my group value is Shipped Jobs, I want fields
like ship date, and invoice date.

Thanks,
Joel

 

[hcj]

Hi Joel,
Interesting idea. If someone else picks up the issue
with an experience-based solution, then I yield. But if
no one else picks it up, I have a concept that might work
for you - involves text boxes with iif() clauses that pick
the value to be printed based on the value of "group".
You'd want label fields that work the same way, too.
Layout is a potential problem, but with properly placed 0-
height text boxes that can grow, it might work. I've
played with it a bit based on what you've set out, and it
works for simple cases.
I'll be looking to see if anyone else plays, or your
signal that you want to look at this further. Might take
a little back and forth discussion, perhaps off line, but
I'm interested to work on it - has possible payoff for me,
too.

hcj

 

[Joel]

Sorry for the delay - That's an excellent idea. I understand what you are
saying and it sounds like it should work no problem, but have difficulty
with syntax. I know the iif() command, but don't know the command for the
Group. Can you give me a small example? Really appriecate your help.

Joel