thisisboni
Programmer
environ: CR10, SQL Server2000
Below is the report design (section wise) that works proper.
RH -
PH -
GH1 - tableA.col1
GH2 - tableB.col1 //initialize flag
GH3 - tableB.col2 // compute flag
Details balanace // display this row if flag <> 1
GF3 -
GF2 - SUM (balance) // display this row if flag = 1 and then reset flag
GF1 -
PF -
RF -
NOW , I need to regroup this regroup as below
GH1 - Table A.col1
GH 2 - TableB.col3
GH 3 - tableB.col4
I was thinking of passing flag value into a subreport and placing the subreport in GF1 to do this - but I am not all that sure as to wether this will do what I need.
Any inputs, ideas , help would be more that appreciated as I am under the gun to this done ---
Thanks
Below is the report design (section wise) that works proper.
RH -
PH -
GH1 - tableA.col1
GH2 - tableB.col1 //initialize flag
GH3 - tableB.col2 // compute flag
Details balanace // display this row if flag <> 1
GF3 -
GF2 - SUM (balance) // display this row if flag = 1 and then reset flag
GF1 -
PF -
RF -
NOW , I need to regroup this regroup as below
GH1 - Table A.col1
GH 2 - TableB.col3
GH 3 - tableB.col4
I was thinking of passing flag value into a subreport and placing the subreport in GF1 to do this - but I am not all that sure as to wether this will do what I need.
Any inputs, ideas , help would be more that appreciated as I am under the gun to this done ---
Thanks