Print

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.
 
N

Norman Yuan

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...
 

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 0
Print 1

Top