Counting a data

lazanya

Hi. I have a database for a library and I would like to count how many times a book has been read.


This is with Quickrep and it is okey.

IBQuery3.close;
IBQuery3.SQL.Clear;
IBQuery3.SQL.Add
('SELECT KTAPADI,YAZAR,BARKODNO,COUNT(*) FROM alisveris GROUP BY KTAPADI,YAZAR,BARKODNO');
IBQuery3.Open;
Form13.QuickRep1.Preview;

_________________________________

But I haven't been successful to do it with fastreport. I think the code is the same. But what should I do in the frxREPORT, how should I design it?

The book has got a barcode(barkodno) and I would like to count it, how many times has it been read?


IBQuery3.close;
IBQuery3.SQL.Clear;
IBQuery3.SQL.Add
('SELECT KTAPADI,YAZAR,BARKODNO,COUNT(*) FROM alisveris GROUP BY KTAPADI,YAZAR,BARKODNO');
IBQuery3.Open;
form23.frxreport1.showreport(true);