• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

QReports Expression

Hi Experts,

I would like to extract from a query in QuickReport
A Total where a date = Now less 30 days using the expression label.

I have a Date field called SaleDate and a Currency Field called Total

How can I do this.

1 Solution
Hi Asw

Try using TQRDBLabel:=Valor

Select C."SaleDate", sum(C."Total") as Valor
from "Sales.db" C
where C."SaleDate"=C."SaleDate"-30
Group by C."SaleDate"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now