How do I install an enhanced Forecast and History Report ?

Copy file K00430HISInclude2New.RPT to the folder {ProtelPath}\Report

Copy file PDC_ForecastAndHist.xml to the folder {ProtelPath}\System\Ckit\Xml

Run vw_pdc_history_and_forecast.sql in SQL Management Studio application

Setup the report:

                                               

 

The queries:

SetFormula(isnet,0);

SetFormula(fromdate,date({PDC_ForecastAndHis_XN.Datvon.1}));

SetFormula(todate,date({PDC_ForecastAndHis_XN.Datbis.1}));

{vw_pdc_history_and_forecast.datum} >= {@fromdate} and {vw_pdc_history_and_forecast.datum}  <= {@todate}  and {vw_pdc_history_and_forecast.mpehotel} = MPEHOTEL()

 

Have more questions? Submit a request

Comments

Powered by Zendesk