I have a table with the following fields
SchPeriod
PartNum
SchQty1
SchQty2
SchQty3
SchQty4
SchQty5
.
.
.
SchQty31
Instead of showing all columns ie. SchPeriod;PartNum;SchQty1;SchQty2;SchQty3...until SchQty31.
Parameter isprovided to restrict those fields starts with "SchQty". for example if user enter 5 then report will only show SchPeriod;PartNum;SchQty1;SchQty2;SchQty3;SchQty4;SchQty5