Skip to Content
0
Former Member
Mar 25, 2009 at 03:09 AM

How to show fields based on parameter entered

19 Views

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