Tips and Tutorials

To Open Form Using Form Entry Record ID in Summary Report

Author
Sheetal More
1 min read Share

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.


Related Articles


View all articles