warning error used without being initialized in Flexreport designer

Posted by: desousa.alexandre23 on 7 February 2021, 6:53 am EST

  • Posted 7 February 2021, 6:53 am EST

    Hi,

    I have added another sql statement to my report by clicking on data tab then add a data source to count each "yes" value i have in a column named CHECKED. Here is my query :

    SELECT
    CHECKED,
    COUNT(*) AS `POINTS VUS`
    FROM
    ARCHPOINTS
    WHERE CHECKED='yes'
    GROUP BY CHECKED


    My problem is now when I drag the new field POINTS VUS to the designer I have an error message that says to me "Warning : Evaluate expression variable POINT VUS used without being initialized" and I can't find how to get through this... Maybe I have to use a parameter or vbscript but I still don't find it on another questions here or in the documentation
    Thank you in advance for helping me.
  • Marked as Answer

    Replied 9 February 2021, 6:47 pm EST

    Hi,
    This is the behavior of C1FlexReport. We cannot use field(s) from two data sources in a single report.
    If you want to count of your records based on some condition then you can just use count() function and set the field's Text property like:
    =Count(Checked, Checked = True)


    Hope, it will solve your issue.

    Thanks,

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels