Create Report using SQL Qurey

Hello,
How to count the number of records showing in a Subreport. I want to stop the report on 12th record.(mean when show 12 records. no more records appear)

How to create report using SQL Query in CRYSTAL REPORT
Please help me

Quote:

---

Originally Posted by hafizfarooq

Hello,
How to create report using SQL Query in CRYSTAL REPORT
Please help me

---

Check out the crystal report tutorial at my signature see the post 3. :wave:

You can try this:

VB Code:

SELECT TOP 12 * FROM YourTableName