Search code examples
sqlsql-serverdelphistored-proceduresquickreports

Delphi QuickReport COUNT problem

I have one very simple, but very annoying problem. I'm trying to count number of rows with specific condition (for example, some column has value 1) in QuickReport. Data in report are given using stored procedure from SQL Server. I tried to use COUNT function in QRExpr but it shows me some error. Another idea is to use query in code and count number of rows directly from procedure and put it in Label, but also didn't succeed.

Do you have idea how to solve this?

TnX in advance!

Nemanja

Solution

  • Because I have flag column (value 1 if condition is achieved, 0 if not), one solution can be to use SUM function at that column, so summarized value will be number of rows with that condition. That can be one solution.

    But still interested in COUNT function and is it possible to add WHERE condition etc. Also, same question for code solution...