Joined: 21 Feb 2012
Online Status: Offline
Posts: 18
Topic: automated section insertion Posted: 22 Aug 2012 at 9:45pm
Hi I have a report with one details section. It shows data from 1 row in a table+ there is a count on number of times the section has been shown. I need to make the same section to show as many times as the user wants based on a parameter he insters. It could be up to 100 times. Additionally every section should have a different number as a count, so I can't just copy everything solid the data must be recalculated in each section.
Basically the parameter the user inserts should start an acction inserting a number of details sections additionally showing a number of that section in it. Anyone has an idea how to do it?
Joined: 21 Feb 2012
Online Status: Offline
Posts: 18
Posted: 23 Aug 2012 at 12:18am
creating a temporary table that would multiply the row I am working on as many times as the client likes, using a parameter. Do you think sth like that can work?
Joined: 21 Feb 2012
Online Status: Offline
Posts: 18
Posted: 23 Aug 2012 at 2:24am
it turned out I had to add a table to the database with a numerical column and another one with constant information that I could link to another table used in the report. Num Dat 1 aaa 2 aaa 3 aaa etc. So my numerical column was used to group by it. and this way I could get the same details section over and over, depending how many times it was entered in the table. A suppress condition allowed me to control number of times the details section was repeated. I added a user parameter and it worked.
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
IP Logged
