To Open Form Using Form Entry Record ID in Summary Report


Sheetal More

2022-02-03 11:01:52


We need to take ID and Form iD in SQL of Summary

Ex. select id, (1852*1) as fid, state from table1852;

Default value should be

SQLEDIT500@1852@1@2

@1 is the column number of Report ID and @2 is the column number of Form ID. @2 is required only if the Form ID is changing. Otherwise, @1 is sufficient for Report ID.