sql server - Insert info from one report to an empty report with only headers -

i try , explain query best can. using sql server , have 1 output report (call report a) numerous headers , values in rows, values in rows (not headers) report must inserted in report (call report b), report b empty no values in rows , headers, header names different report a. have considered altering report have same headers b , replicate b, not technically correct way of doing it.

here example of require.

report a

    mem-num|  total|  address|  dep|  contact number|  scheme code|     123       r100    gauteng   00    12345678910      16 

report b - no values headers

    member number|  product code|  total|  banking details 

output report b values of report a

    member number|  product code|  total|  banking details     123             16             r100    field blank 

thus

    report b (member number)     = report (mem-num),     report b (product code)      = report (scheme code),            report b (total)             = report (total),            report b (banking details)   = blank      there no data in report insert report b banking details 

well if understand write, why not ?

select mem-num 'member number'         ,scheme code 'product code'         ,total         ,null from( select mem-num,  total, scheme code reporta_table)