How to get multiple records from table into free form report layout

• naisu1383

  Old Hand

  Points: 380

  More actions

  August 6, 2012 at 1:14 am

  #264779

  I have designed free form layout and depending on date range provided as parameter should get individual record on each page with same layout. However i am getting just single record repeating on different pages in PDF. So how can i get all the desired records in different pages? The dataset query is as:

  SELECT DM.MEMBER_ID, CONVERT(VARCHAR(10), DM.SUBSCRIPTION_DATE, 105) AS SUBSCRIPTION_DATE , LM.LOV_DESC, DM.AMOUNT, DM.CHEQUE_NO, DM.BANK_NAME, PM.FNAME, PM.MNAME, PM.LNAME,

  AM.ADDRESS1, AM.ADDRESS2, AM.ADDRESS3, CM.CITY_NAME, AM.PINCODE, AM.PHONE, DM.BILL_NO, DM.PRINT_YN, DM.D_CURRENCY_CODE

  FROM DAD_MEMBERSHIP DM, PERSON_MASTER PM, ADDRESS_MASTER AM, CITY_MASTER CM, ADM_LOV_MASTER LM, DAD_MAGAZINE_MASTER DMM

  WHERE AM.CITY_ID=CM.CITY_ID AND PM.PERSON_ID=DM.PERSON_ID AND AM.ADDRESS_ID=DM.ADDRESS_ID

  AND LM.LOV_COLUMN='DAD_PAYMENT_CODE' AND LM.LOV_CODE=DM.PAYMENT_CODE AND DM.D_STATUS_CODE=1

  AND DM.SUBSCRIPTION_DATE BETWEEN @date1 AND @date2 AND DM.MEMBER_TYPE=DMM.MAGAZINE_TYPE

  AND DM.MEMBER_ID NOT LIKE 'X%' AND MEMBER_ID LIKE @magtype + '%' AND DMM.MAGAZINE_DURATION > 1

  AND DMM.MAGAZINE_REGION LIKE 'I'

  ORDER BY DM.MEMBER_TYPE, CAST(SUBSTRING(DM.MEMBER_ID, 5, 15) AS INT)