CF Report Builder

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NCMike - 28 Feb 2005 15:07 GMT

I am trying to generate a pricelist report using the new CF 7 Report Builder.
When I add an image to the reprt and try to dynamically build the filename the
preview very quickly goes to 'Page cannot be displayed'. I've also tried using
a BLOB field and I get the same thing. I currently use Crystal Reports using
the same BLOB field and i works fine. I am trying to migrate from Crystal to
CF.

Reply to this Message

NCMike - 28 Feb 2005 15:41 GMT

Addendum. My mistake. I switched browsers and found that there was an error
message from the BLOB request. It said that the image had to be in GIF/JPG
format. They are. However some may ba blank or null. How do I ignore those
should be the better question to ask.

Reply to this Message

Dean Harmon - 28 Feb 2005 20:37 GMT

In the print when expression of the image, set it to be something like this:

iif(query.imagefield IS "", false, true)

so that the image will try to print when it has something but will not print
if it is blank (ie null)

Dean

> Addendum. My mistake. I switched browsers and found that there was an error
> message from the BLOB request. It said that the image had to be in GIF/JPG
> format. They are. However some may ba blank or null. How do I ignore those
> should be the better question to ask.

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / February 2005

CF Report Builder