No one can help me in this!
Yes, because your question is not clear.
1 person found this helpful
Now I've created tow tables master and detail.
The master is used to save the main data of the report calling (user, date, report name ...) by adding an insert statement in the After Report Trigger.
I wanna use the detail one to save the parameters of this report and its values which the user entered when he called it
that is the detail fields are (Rep_Audit_id (FK for the master), Parameter name, Parameter value).
I can do this by adding insert statement for each parameter but this will take much time and effort
I wanna way to return the parameter name and its value to add one insert statement only for all parameters