If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print
Hi there
I am the same guy who is having trouble with printing textbox on the last new page of report. If you can see my last two posting both with Print heading you will get what the issue is. Also i tried the force new page property but it does not work with my form. I am sending you the sql of my report, and i would appreciate if somebody could help me with this. 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. |
#2
|
|||
|
|||
If you have nothing else in the report footer section beside
the signoff text box, then setting the report footer section's ForceNewPage property to Before Section should be all you need. If you have other data displayed in the report footer section then add a Page Break control just above the signoff text box. I would also consider using DLookup in the signoff text box instead of messing with every report's record source query. Assuming that P_Name is a text field and TDCM_Date is a date field: =DLookup("Source_document", "PROGRAM SIGN OFF", "P_Name=""" & txtPName & """ And S_Date = #" & txtTDCMDate & "#") where txtPName and txtTDCMDate are the names of the report text boxes bound to the P_Name and TDCM_Date fields. -- Marsh MVP [MS Access] Taher wrote: I am the same guy who is having trouble with printing textbox on the last new page of report. If you can see my last two posting both with Print heading you will get what the issue is. Also i tried the force new page property but it does not work with my form. I am sending you the sql of my report, and i would appreciate if somebody could help me with this. 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Can't print from MS Office Programs | AL | General Discussions | 0 | August 4th, 2004 11:33 PM |
Can't Print Frames? | Bart Van der Donck | Outlook Express | 0 | May 31st, 2004 11:08 AM |
Print Reports | Bill | Setting Up & Running Reports | 2 | May 26th, 2004 02:57 AM |
Excel Printing | Annette | Worksheet Functions | 2 | October 17th, 2003 01:14 AM |