Print

T

Taher

Below is the query by which i get my repor printed.

SELECT DISTINCT [REPORT QUERY SUPPORT].P_Name, [REPORT
QUERY SUPPORT].O_Name, [REPORT QUERY SUPPORT].I_Name,
[REPORT QUERY SUPPORT].LOB_Name, [REPORT QUERY
SUPPORT].OU_Name, [REPORT QUERY SUPPORT].CM_Name, [REPORT
QUERY SUPPORT].TDCM_Date, [REPORT QUERY
SUPPORT].CM_ReportSort, [REPORT QUERY
SUPPORT].CM_Audience_Type, [REPORT QUERY
SUPPORT].CM_Value_Type, [REPORT QUERY
SUPPORT].O_ReportSort, [REPORT QUERY
SUPPORT].I_ReportSort, [PROGRAM SIGN OFF].S_SignAnswer,
[REPORT QUERY SUPPORT].DDCM_Start_Date, [REPORT QUERY
SUPPORT].DDCM_End_Date, [REPORT QUERY
SUPPORT].DDCM_Baseline_Nominal, [REPORT QUERY
SUPPORT].DDCM_Goal_Nominal, [REPORT QUERY
SUPPORT].DDCM_Baseline_Percent, [REPORT QUERY
SUPPORT].DDCM_Goal_Percent, [REPORT QUERY
SUPPORT].Jan_Nominal, [REPORT QUERY SUPPORT].Feb_Nominal,
[REPORT QUERY SUPPORT].Mar_Nominal, [REPORT QUERY
SUPPORT].Apr_Nominal, [REPORT QUERY SUPPORT].May_Nominal,
[REPORT QUERY SUPPORT].Jun_Nominal, [REPORT QUERY
SUPPORT].July_Nominal, [REPORT QUERY SUPPORT].Aug_Nominal,
[REPORT QUERY SUPPORT].Sep_Nominal, [REPORT QUERY
SUPPORT].Oct_Nominal, [REPORT QUERY SUPPORT].Nov_Nominal,
[REPORT QUERY SUPPORT].Dec_Nominal, [REPORT QUERY
SUPPORT].Jan_Percent, [REPORT QUERY SUPPORT].Feb_Percent,
[REPORT QUERY SUPPORT].Mar_Percent, [REPORT QUERY
SUPPORT].Apr_Percent, [REPORT QUERY SUPPORT].May_Percent,
[REPORT QUERY SUPPORT].Jun_Percent, [REPORT QUERY
SUPPORT].Jul_Percent, [REPORT QUERY SUPPORT].Aug_Percent,
[REPORT QUERY SUPPORT].Sep_Percent, [REPORT QUERY
SUPPORT].Oct_Percent, [REPORT QUERY SUPPORT].Nov_Percent,
[REPORT QUERY SUPPORT].Dec_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Percent, [PROGRAM SIGN
OFF].Source_document
FROM [REPORT QUERY SUPPORT] LEFT JOIN [PROGRAM SIGN OFF]
ON ([REPORT QUERY SUPPORT].P_Name = [PROGRAM SIGN
OFF].P_Name) AND ([REPORT QUERY SUPPORT].TDCM_Date =
[PROGRAM SIGN OFF].S_Date);

No i want that [PROGRAM SIGN OFF].Source_document
be printed at the end of every report. I would appreicate
if somebody can help me.
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print 1
Print 1

Top