Automation for copying records in a report to a new table

My head hurts trying to understand both the question and the replies. You people are so deep into the native feature jargon and their associated limitations I have no idea what you are trying to accomplish. Just state in simple terms what you are trying to accomplish and exemplify it with field and table names and sample data if necessary.

The following may or may not help lead to a solution:

One thing you may not be aware of is that if you take a saved summary report URL (say qid=5) and add the parameter &opts=csv to the URL you will in fact get a CSV response of the summarized data (not the raw un-summarized fields). This makes it almost trivial to import the summarized data into a second table with script. For example code like this will copy the CSV associated with a summary report (qid=5) and import it to a second table:

var dbid = "";
var dbidRecords = "";
var dbidSummaryOfRecords = "";
var apptoken = "";
$.ajaxSetup({data: {apptoken: apptoken}});
$.get(dbidRecords, {
  a: "q",
  qid: "5",
  opts: "csv"
}).then(function(csv) {
  console.log(csv)
  $.post(dbidSummaryOfRecords, {
    act: "API_ImportFromCSV",
    records_csv: csv,
    clist: "6.7",
    skipfirst: 1
  }).then(function(xml) {
    console.dirxml(xml);
  });
});