Limiting number of rows in a databand

Paolo Patri

Hi,
I'm not able to filter the number of details record printed out in an advanced databand within a master-detail report structure

Obv.sly I cannot use direct query sintax like TOP into the detail user query, so ...

it's possible to limit the munber of details lines acting directly from the designer editor?

(I've tried some scripting sintax involving LineNumber or PageNumber with no success)

Thanks
Paolo

Philipp Knecht

Hi Paolo

If you cannot change the Query you can put the following Expression on the visible Elements (Header, Detail, Footer) within the dataBand :

dataBand.LineNumber < 11

hth

Paolo Patri

It works!

Thanks!