Help on Code for - Stop_Database Query before a value

Alex_de_KockAlex_de_Kock Bloemfontein, Free State, South Africa
edited 7:41AM in FastReport 4.0
Can someone maybe help me complete the code below. I need the report to only draw my departments from 1 to 20 and then stop.

if <SalesSummary."DEPT_CODE"> < 21
then
begin
;
end;

Thanx

Comments

  • gpigpi
    edited 7:41AM
    Try to use:
    MasterData1.Visible := <SalesSummary."DEPT_CODE"> < 21;
    
  • edited 7:41AM
    Can you change your query and write

    select * from SalesSummary
    where SalesSummary."DEPT_CODE" < 21

    Mick
  • Alex_de_KockAlex_de_Kock Bloemfontein, Free State, South Africa
    edited 7:41AM
    gpi wrote: »
    Try to use:
    MasterData1.Visible := <SalesSummary."DEPT_CODE"> < 21;
    

    Thank you!

    Worked perfectly

Leave a Comment