Warning error used without being initialized in Flexreport designer

Warning error used without being initialized in Flexreport designer

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

• 

  desousa.alexandre23

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  sonu.singh

  

  • Post Options:
  • Link
    Copy

  Posted 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,