Print

  • Thread starter Thread starter Taher
  • Start date Start date
T

Taher

Hi there

I want to print a textbox at the end of every report.
Itried the force new page and page break property but it
does not work for me.

The text box comes from a table diffrent from report
table, and also its a memo feild.

My report has many initaitives and project for various
business unit. For each business unit initiatives and
project are printed.

I would appreciate if somebody could help me with this. I
am copying my sql report below

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);

Thank you.
 
You can do that with a subreport.

Create a seperate report without report header, page header and page footer,
have the report to query the data from desired table. Then, add this report
into all other report's report footer (or Report Header, if you wish) as
subreport.

This way, all your reports will have the same report footer/header with data
from a particular table.

Taher said:
Hi there

I want to print a textbox at the end of every report.
Itried the force new page and page break property but it
does not work for me.

The text box comes from a table diffrent from report
table, and also its a memo feild.

My report has many initaitives and project for various
business unit. For each business unit initiatives and
project are printed.

I would appreciate if somebody could help me with this. I
am copying my sql report below

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);

Thank you.
Click to expand...
 
Back
Top