grouping on a variable

madm

is this possible?!

I have created a report that creates a sub string from a string, and i wish to group on this sub string.

ara3n

You can add a second body section. In on presection you can add code to showout to true or false. You have to write the criteria on when to print or not.

For example

if (nextrecordgrouprecord = CurrentGroup) then
currreport.showoutput(false);

madm

thanks for your reply. one thing i ommited from my inital post was that im just using the group footer in the report.

for example :

the table has 3 fields:

Code ID Out In
10 1 12
10 2 13
10 3 14
11 4 39


anything ending in 0 will only have an in value, and anything ending in 1 will only have a out value which = the sum on the in. The initial value of the code is the "group". (the next job will be 20 and then 21)

I am trying to create a report which shows the totals of the in and out on one line in order to identify any differences ie :

In Out
1 39 39

So I have stripped the 0 and 1 out of the code in order to give a standard code. I have then created totals and put these in the group footer. This then generates code 1 over two lines (one for 0 and one for 1).

ara3n

Then add a second Groupfooter and move the code there and control the output.