Hi I'm new to crystal reports and i've been asked to create a report with a TOC as the second page. I did some research and it seems that this is no easy task (correct me if it is). The options i've found are :
Trouble is i can't seem to get it to excute the insert statement! i've simplyfied it down to a wizard generated report to which i've added a subreport in the report footer section. This subreport is connected to a command which is static insert statement. When i preview the report i get no error messages but it's not updated the table either.
I'm new to crystal reports so please state any obvious things i've missed. is a sub report the best way to run an insert query?
Thanks!