earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
How to

How to


Products: WebReports
Functionalities: Reports
Product version: 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
6/15/2012

Uploading an Image

You upload an image when you want to add the image to the Image Library and use the image in the header of your reports. You can upload one or two images, and then decide to add the images to the left or right of the header.

Show More
action_close

WebReports provides an image library where you can upload and preview images to be used in your reports. You can also delete images from the image library.

When you upload an image, you need to select where you want to position the image on the report. You can position an image on the upper left side of your reports and on the upper right side of your reports. For more information, see Uploading an Image .

You can upload images with the following file types:

  • .bmp

  • .gif

  • .jpeg and .jpg

  • .png

The maximum size of an image file is 512 KB.

In order to maximize the quality of the images in your reports, use images with a pixel width and height of 168 (width) x 72 (height).

Images in Reports Created in Report Builder

You can add images to any reports that you create using MS Report Builder. You can add an image file to the reports database in the same way that you add images for normal reports. However, the image will not be visible in the report (nor in WebReports) unless you insert an image frame in your report and reference the database image file by way of a dataset in your report.

A dataset contains the data that you want to use in your report. The data is accessible in textual or tabular form, or as a stored procedure. Datasets can contain any type of data, including image-related data. The data is extracted by way of queries, and having created a query, you select a dataset field through the image frame that you draw in your report.

For example, you can create a dataset in your report and then type a query statement, such as:

(SELECT imagedata FROM tbreportimages WHERE ImageName='SchneiderBlack' and ImageType='Category3')

where 'SchneiderBlack' is the name of an image you have previously uploaded into the reports database, and 'Category3' is one of the category selections you make when uploading the image. You then select the dataset field when creating your image frame. For more information, see Adding an Image to a Report .

As another example, you can add left and right hand images to your reports by first selecting the spRDLClientInfo stored procedure dataset, and then selecting the FactoryDefault and ProductDefault dataset fields when drawing your left and right image frames.

 
action_zoom_plus_stroke Factory and Product Default dataset fields relating to report images

Factory and Product Default dataset fields relating to report images

This will produce the same left and right images that you selected in the WebReports Manage Images section for normal reports.

 
action_zoom_plus_stroke Left and right report image selection

Left and right report image selection

To upload an image
  1. In WebReports, on the menu bar, click Images .

  2. In the Image file box, enter the image file that you want to upload.

     
    action_zoom_plus_stroke
  3. In the Image tag box, select a tag to identify the image in the image database.

  4. In the Image name box, type a name for the image.

    Important:
    • Do not use the name “Default” as this name is reserved for Schneider Electric images. Images named “Default” cannot be deleted.

     
    action_zoom_plus_stroke
  5. Click Save .

  6. In the Left image box, select the image that you want to position on the upper left side of the report.

     
    action_zoom_plus_stroke
  7. In the Right image box, select the image that you want to position on the upper right side of the report.

  8. Click Save .

  • Report Images
  • Manage Images Page