Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dynamic images in Impromptu
- Thread starter ADB1
- Start date
This is one approach:
Description:
How can I dynamically display different pictures depending on the data in an Impromptu report?
Solution:
Prior to accomplishing this, the pictures should be created in a bitmap format
and stored on a drive that the Impromptu application can access. Additionally,
there must be a filename associated to the data whether by adding the filename
to the database or in a HotFile that has been joined to the datasource.
For example, if you wanted to display a different company logo for each company
in the report, you could create a HotFile that contains the following columns and
data:
CUST_NO FILENAME COMP_DESC
1001 1001.bmp Company A
1002 1002.bmp Company B
1003 1003.bmp Company C
1004 1004.bmp Company D
You would then join this HotFile by CUST_NO to the header/master table in the
database.
To insert this picture into a header of a report, insert the column that contains the
filename for the picture into the report and perform the following:
a) Select the Insert menu item.
b) Select the Picture Frame from the Insert drop-down menu.
c) Ensure that the Source tab has been selected.
d) Enable the option of 'Load using file name in column.'
e) Select the filename column 'Load using file name in column' drop-down list.
f) Select the Prefix with path check box.
g) Browse to the file location of the bitmaps.
h) Run the report.
Description:
How can I dynamically display different pictures depending on the data in an Impromptu report?
Solution:
Prior to accomplishing this, the pictures should be created in a bitmap format
and stored on a drive that the Impromptu application can access. Additionally,
there must be a filename associated to the data whether by adding the filename
to the database or in a HotFile that has been joined to the datasource.
For example, if you wanted to display a different company logo for each company
in the report, you could create a HotFile that contains the following columns and
data:
CUST_NO FILENAME COMP_DESC
1001 1001.bmp Company A
1002 1002.bmp Company B
1003 1003.bmp Company C
1004 1004.bmp Company D
You would then join this HotFile by CUST_NO to the header/master table in the
database.
To insert this picture into a header of a report, insert the column that contains the
filename for the picture into the report and perform the following:
a) Select the Insert menu item.
b) Select the Picture Frame from the Insert drop-down menu.
c) Ensure that the Source tab has been selected.
d) Enable the option of 'Load using file name in column.'
e) Select the filename column 'Load using file name in column' drop-down list.
f) Select the Prefix with path check box.
g) Browse to the file location of the bitmaps.
h) Run the report.
- Thread starter
- #3
Have not had hands on experience of the product (purchase has been refused !) but maybe Visualizer might be used to enhance the presentation of the Impromptu report - although this approach would probably only be justifiable if other Impromptu/Powerplay displays were also present.
- Status
Similar threads
- Locked
- Question
- Locked
- Question