how do we fetch only 10 records and how do we get particular date of birth records?

General
, ,
1

I have Scenario like

Need to fetch only 10 records and how do we get particular date of birth records from the results.

2

@SudhaV17184692

Depends on your requirement we can follow below approaches -

  1. If restriction to put on DB query level ?

you can mention 10 in max rows to retrieve in data access tab In reports.

  1. Need to fetch data from DT?

you can fetch report data in activity/DT and filter it.

Regards,

Sindhu.

3

Hi @SudhaV17184692,

Create a Report Definition ,In the Query tab, set the Maximum Number Of Rows To Retrieve to 10., Add a filter condition in the Query tab to filter records by DOB and pass the required DOB as the Parameter, You can use RD directly or you can use Data Page with giving the RD which you have created as a Data Source.

Regards,

Prasad