Thursday, February 9, 2012

a few questions ? (problems)

1) ok ... i have a few records in a detail section like this

record1
record2
record3
record4
record5

... i need to create a empty row after first three (only) rows like this

record1
record2
record3

record4
record5

so how to do it? i have splited detail section in two part and suppresed second, so i belive it would be necessery to put some code here like

if (recordNumber = 3) then ... don't suppress ??

how to do it?

2) second thing is how to make a simple counter for records (the RecordNumber function is not good)

1. record1
2. record2
3. record3

4. record4
5. record5

or something like it ?Hi ,

After Details section, insert new section
Put Record number special filed in Details section.
Right click on left corner of New section; select Section Expert.
There is option Suppress and right to that there is button labelled as x-2.
Click that and write the following code

if recordnumber mod 3 =0 then false else true|||As for your second Question, you can create a Running Total ('Field to Summarize' would be the field you want to count, 'Type of summary' would be 'Count', Evaluate 'For each record', Reset 'Never') and insert it into your Details section in front of the Record.|||thanks :)

No comments:

Post a Comment