I have this report which is having stepnumber,stepname,paidamt,batchid in the details section. When i look into the backend database i see that I have 5 stepnumbers for the clientcode:XYZ. I have record selection saying that table.stepnumber in [1,2,3,4,5] to look into these stepnumbers..And i have the detail Section Expert setting checked on the Format with multiple columns. For some reason i only see 3 steps in the detail section for the Batchid for clientcode:XYZ. not sure why am unable to pick the other 2 stepnumber. I have an inner join btw the 2 tables on Batchinfoid. Any thoughts would be helpful.

 

 

Thanks.

 

My Layout is as follows in the detail and i have selected format with multiple columns

 

stepnumber  stepnumber  stepnumber  stepnumber

 stepname    stepname       stepname     stepname

 paidamt       paidamt           paidamt         paidamt.

 

For some reason i have the duplicates in First page with stepnumber repeating 3 times and the second page starts with new stepnumbers repeating 3 times. Why is this happening? Any ideas?

Thanks