Form Grouping

[cmw]

Specified field name grouping in form is possible or not? It is work done in report.I want Accounts type wise grouping in form.
eg
Purchase A/c
Purchase 1%
Purchase 2%
Sales A/c
Sales 1%
Also I want If reportdetail double click,another report open. Is it possible.

 

[Guus2005]

Specified field name grouping in form is possible or not? It is work done in report.I want Accounts type wise grouping in form.
eg
Purchase A/c
Purchase 1%
Purchase 2%
Sales A/c
Sales 1%
Also I want If reportdetail double click,another report open. Is it possible.

No. A report is much more dynamic than a form. But you can change values in a form not in a report. You could make a report look like a form if you don't need to change or enter data.
Yes. When you use a number of nested continuous subforms you could fake a report. However this is a lot of work.

No. The only events you can trigger are when the report was opened. There is no on-click event in the detail section. Again, you can fake this behaviour by creating a form which looks like a report. White background and all...

HTH

 

[cmw]

Thanks Guus, No way for grouping in a form, is it? How to do work
Decimal place round into 2. I try many ways round function but doesnot work. Then value=0 then Display blank , I try follow method
iff(debit=0,"",debit) but not work. Please help me.

 

[Guus2005]

try iif instead of iff

 

[cmw]

Sorry, I am using IIF Statement. But not work well.

 

[Guus2005]

0 is a number, "" is en empty string. perhaps that is the problem.

 

[cmw]

How do solve this pbm

 

[Guus2005]

need more info, what is the error message? Please post a sample database describing the problem!