Report using table to hold parameters

sp4tc

I need to run a report based on a table holding GL codes so I would have the table as;

GLAccNo
101000
107000
108000
110000
111000
201000
201100
202000
203000
205000
206000
207000
207100
207200
207300
207400
207500
207900
208000
208100
208500
208900
209998
211120
211130
211140
211160
211170
211320
211330
211340
211360
211370
212300
259999

and for each of these codes I need to know in the GL Budget Entry table the amount per line

Any help is appreciated.

Reinhard

Mark all the records in G/L Budget Entry and then set marked only to true, and then pass that record in to your report. This way you don't need to have a table to hold all those numbers.

Or if you do have to have that table, set it as the primary data item in a report. Then indented below it have G/L Budget Entry and have a DataItemLink between G/L Budget Entry "Account Number" and the number field in your table.