Joined: 27 Mar 2015
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: Adding rows dependant on results Posted: 08 Apr 2015 at 2:14am
Im writing an inspection report I need to add a number of rows dependant on another result field in my report.
Example,
Part Qty = 10 (this result may vary from 1 to 300ish)
(so I need the report to add 10 rows)
Inspection Report 1
Inspection Report 2
Inspection Report 3
UPTO
Inspection Report 10
Ive thought about having the rows pre-inserted and supressing the ones I don't want (haven't had a go yet).
Was wondering if this request is possible?
How much wood would a woodchuck chuck if a woodchuck could chuck wood
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 08 Apr 2015 at 3:20am
if I understand your question, unless your source (e.g. a stored proc) is dynamically altering the number of rows coming into the report your basically on a good track with adding suppression criteria on extra inserted sections (e.g a details a,b,c...) or possibly sub reports.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum