Report Formatting

[Raymond]

Hi all,
I have two divisions of a company..and i have 1 sales report. This report is
opened by both the divisions whatever the choice may be. Now my report has a
logo(image) at its header which is different for both divisions. How do I
code it so that according to the division chosen by the user, the report
opens with the respective image..

Please help since I don't want to create two reports for both these
divisions because that would be simply ridiculous....

 

[fredg]

Hi all,
I have two divisions of a company..and i have 1 sales report. This report is
opened by both the divisions whatever the choice may be. Now my report has a
logo(image) at its header which is different for both divisions. How do I
code it so that according to the division chosen by the user, the report
opens with the respective image..

Please help since I don't want to create two reports for both these
divisions because that would be simply ridiculous....

Use an Image control to display the logos.
You can....
1) Use 2 Image controls.
Include both images, one on top of the other, in the report.
Then code the Report Header's Format event, something like:
If Me.[Department] = "Sales" Then
Me.ImageName1.Visible = True
Me.ImageName2.Visible = False
Else
Me.ImageName2.Visible = True
Me.ImageName1.Visible = False
End If

Or....
Just use one Image control.
Code the Report Header Format event:
If Me.[Department] = "Sales" Then
Me.ImageName.Picture = "c:\PictureFolder\SalesLogo.jpg"
Else
Me.ImageName.Picture = "c:\PictureFolder\ManufacturingLogo.jpg"
End If