I am trying to upgrade a WebI report with many html objects from v5 to v6. The following is the sql being generated by the report. If you see the part that is in red, the SQL should reference another object which contains ‘/wi/tripimages/’. In one part of the SQL, the reference object worked, but not in the second place, even though it has the same tags and references.
SELECT
View__4.METRIC_NAME,
‘
| <img src=’ || ‘/wi/tripimages/’ || ‘Platinum_Partners_Logo.bmp’ || ’ width=“162” height=“36” alt=“Platinum Partners”> | 2004 Platinum Partners Performance Summary | <img src=’ || ?170 || ‘Platinum_Partners_Logo.bmp’ || ’ width=“162” height=“36” alt=“Platinum Partners”> |
FROM
(
SELECT METRIC_NAME
FROM TRIP_PP_METRIC_D
) View__4
Upon trying to run the report, I get the following error. Please note this worked in v5.
Database error: ORA-00911: invalid character. Contact your administrator or database supplier for more information. (Error: WIS 10901)
Anyone know what’s up with this?
Thanks,
Ken
Ken Raffel (BOB member since 2002-08-29)