Create page footing in crystal report

Hi Hans,

You can refer following help material in our F1 DOCS.

https://wit.ifsworld.com/f1docs/apps9upd16/foundation1/050_development/025_reporting/010_operational_reporting/200_cr_as_operationalreport/030_ex_cr_operationalreport/default.htm

Hope this helps.

Best Regards,

Sangeetha Jayamaha.

/

Hi @Hans Andersen ,

You can add FOOTER_FIELD and FOOTER_CONNECTION views and map the REPORT_ID in report view accordingly.

Thank you @Sangeetha Jayamaha ,

It helps a lot, and then not so much.

The report I am working on uses data from several views related to Business Opportunity and Estimate. I do not have a result_key. Instead it takes opportunity_no as input parameter.

My course right now is to make a CLU that stores the data needed (similar to s30, s31.. in ORDER_INFO_SERVICES_RPT). Unfortunate, I cannot find the api that extracts the data. I tried with this:

select 
client_sys.Get_Key_Reference_Value(d.PAGE_FOOTING, 1),
client_sys.Get_Key_Reference_Value(d.PAGE_FOOTING, 2),
client_sys.Get_Key_Reference_Value(d.PAGE_FOOTING, 3),
client_sys.Get_Key_Reference_Value(d.PAGE_FOOTING, 4)
from COMPANY_INVOICE_INFO d where d.company='1'

But the result is not as expected. 

You can add FOOTER_FIELD and FOOTER_CONNECTION views and map the REPORT_ID in report view accordingly.

I did consider that, but then I will have to change all other reports.