Images in Reports

[Jolee]

Hi,

I am trying to get an image out of the database to display in a report.
This works fine.
What I now want to do is only get one image for each camera to display.

Business Object - Camera
Attributes:
Number
Location
Image (links to Camera_Images)

Busines Object - Camera_Images
Camera (links to Camera)
Date
Image

My Report is an embedded report in the main Build Sheet Report, which also has other embedded reports in it.

So the Camera Report has elements of:
Camera.Number
Camera.Location
Camera.Image.Image

it's the Camera.Image.Image element that I want to only show the 'latest' image.
There can be many Images attached to a camera.

I hope I have given you enough info ...

cheers
Jolee

[aware_support2]

Jolee,

You need to create a separate report that displays an image as Camera_Images.Image and include this report as a sub-report into the Camera Report. The query in the Camera Report for the sub-report should be:

FIND Camera_Images WHERE Camera_Images IN Camera.Image ORDER BY Camera_Images.ImageDate DESC TAKE BEST 1

[Jolee]

Thanks, one more thing.

How do I find the number of cameras per IPU from my BuildSheet report.
I have tried SUM and COUNT to no avail. Possibly using these wrong.

Business Object - Camera
Attributes:
Components (links to Camera_Hardware)
IPU (links to IPU)

Busines Object - Camera_Hardware
SID
Camera (links to Camera)

I want to get the number of SIDs per IPU to find the number of cameras per IPU.

cheers
Jolee

[aware_support2]

Jolee,

On which report/sub-report you want the number of cameras per IPU to be shown?

[Jolee]

On the main Build Sheet Report.

[aware_support2]

If you want to get the total number of all components within all cameras within a given IPU, the expression is:

COUNT Camera_Hardware WHERE Camera_Hardware.Camera.IPU = IPU

If you want to get the total number of all cameras within a given IPU, the expression is:

COUNT Camera WHERE Camera.IPU = IPU