Control if group visible base on page

[PShiers]

If it possible to change if a group is visible based on what page a different group is printed on.

The report I'm working on is a Invoice and it has subtotals in one group and totals in another group.

If the totals are going to print on page 1 then there is no need to print the subtotals. Is there a way to know what page the totals will print on so I can set visible for subtotal group to true or false?

Many Thanks

 

[Meltdown]

I don't know of any way to know what page a sub-total or total might be printed on -- as a workaround, I'd suggest allowing your users to decide if a value or group should be printed, after they've previewed the report.

Beside your report button place a checkbox that the user can click to hide the subtotals or group.

On the report check if they've selected the checkbox and show/hide accordingly.

Regards
Melt

 

[PShiers]

Workaround is a good idea

Thanks

 

[Simon_MT]

If you were to put a Count on the Subtotal and if it is greater than one Print the GrandTotal.

Simon

 

[PShiers]

Simon,

Could you explain a little more, not sure what I should be counting and how.

Thanks

 

[Simon_MT]

On your SubGroup create an unbound Field SubCount on the SubTotal Group Footer:

Function ReportSection6_Reveal()

    With CodeContextObject
        If Not .HasData Then
            Exit Function
        End If
        
        If .[RecordCount] <> 1 Then
            .Section(6).Visible = True
        End If
    End With
End Function

Also:

On the Header:

Function ReportSection6_Hide()

    With CodeContextObject
        If Not .HasData Then
            Exit Function
        End If
       .Section(6).Visible = False
    End With
End Function

Simon

 

[PShiers]

Thanks Simon

I'll give this a try in the next couple of day and post how it went.

Cheeers