OLE-object and report designer

Permanently deleted user

• January 14, 2010 14:57

Made a connection to a access database. In 1 of the tables there is a OLE-object field. Is it possible to get this object into a selection report, made with the report designer?   I´am able to add all the text fields that i want to. But can´t figure out how to import that image.   Best regards, Wilfred

0

• 

  Permanently deleted user

  • January 14, 2010 23:48

  Hi Wilfred,   I believe it is possible to extract the OLE-object as an Image (e.g. create a System.Drawing.Image out of it) and insert it into the report.  You should be able to do this with an embedded script in the RPX itself.   Unfortunately, programming and debugging embedded scripts in RPX files can get very tricky, as the script editor in the Report Designer does not have intellisense or links to help documentation.  Also, our reporting does not tolerate exceptions in the report or allow the compiled code to access the Geocortex.Logging classes, so you'll have to "code defensively" to ensure you get the report built.

   

   

  When debugging a troublesome report I usually add an extra text field and then catch all exceptions and print them to the extra field.   Regards, -Malcolm  

   

  0
• 

  Permanently deleted user

  • March 08, 2011 03:43

   

  Hi Malcolm-   What are the steps to adding this RPX control?  I just want to be able to add a picture in my report designer and have it update to the appropriate picture based on the user selection.  

   

  0
• 

  Permanently deleted user

  • March 11, 2011 00:09

  Hi Josh,

  It's the same process as dynamically setting the text in a text control, except you are setting a System.Drawing.Image attribute.

  I have attached an example RPX file that dynamically inserts a random image from the Internet (from gravatar, for easy implementation).  I'm using a WebClient request to download the image; if your images can be loaded from disk things will be easier.

  For a production site, please implement better error handling - WebClient can throw a vast number of exceptions (can't find file, bad URL, etc) that are all being swallowed and discarded by my code.

  This RPX file can be loaded as a main Print Template into the REST elements.  I haven't tried it with the ADF.  It also exposes a minor issue with our REST printing - you must have a _MainMap Image on your template for it to work.  (Mine is hidden)

  Regards,

  -Malcolm

   

   

  (https://support.geocortex.com/Data/Sites/1/userfiles/20/missingperson.zip) Attachment: MissingPerson.zip

   

  0
• 

  Permanently deleted user

  • July 05, 2012 22:48

  I am interested in viewing the sample report you have generated, but the link fails.

  Is there a way I can get a copy of this report?

  Thanks

  Cathy

  0
• 

  Permanently deleted user

  • September 28, 2012 03:59

  Hi Cathy,

  The forum doesn't like serving RPX files (since they are actually XML).  I've put it in a ZIP file and now the link works.

  Regards,

  -Malcolm

  0

Please sign in to leave a comment.