Report Header dynamic bitmap name

[askoog66]

I am now forging on and learning reports. Since my web application is multi tenancy, I have different companies needing to have their logo across the top of my reports.

I have the path to their bitmaps contained in a session variable and am having trouble directing the report's bitmap to this session variable. I read on another post from Peter Greulich saying that session variables need to be put in calc fields which I have declared rptlogofilename = session.logofilename in the calculated values table. I am getting an error in that table, but when I set the expression in one of the header cells to rptlogofilename, it correctly prints the filename and directory.

When I set the dynamic file name of a bitmap to rptlogofilename, I get something, but is so small I cannot read it and it is certainly not the jpg file. I have checked the jpg files to make sure they are good.

Therefore, I think I am close, but not quite there.

Thanks for looking.

Andy

[Keith Hubert]

Re: Report Header dynamic bitmap name

Hi Andrew,

If you have uploaded the images why do you need to have their bitmaps contained in a session variable? I have done what you are asking see my site and check out Featured Vacancies. Click on item under Post title.

[askoog66]

Re: Report Header dynamic bitmap name

Thanks Keith,
I did look at your site and am not sure I am following the parallels. If I am understanding your site, it is popping up a dialog or PDF of job vacancies. Though it is quite possible I am missing your demonstration.

I am trying to have a bitmap control reference an external file at the system level. I am not loading the JPG into Alpha or PostgreSQL. Down the line I will need to do something similar for reports containing pictures of potentially thousands of plants. Therefore, while at this juncture I could conceivably just load the JPG's into Alpha or Postgres, at a later time I will need to know how to reference them in the file system.

Thanks....Andy

[Keith Hubert]

Re: Report Header dynamic bitmap name

Hi Andy,

What I was hoping to show you was, how an image can be used in a report that had been uploaded. The image itself is not stored in a table, only the reference to it.
Are you trying to reference the image file manually?

[askoog66]

Re: Report Header dynamic bitmap name

I am not sure of the proper terminology for what I am trying to do. The best example is that my tabbed ui menu references the session.logofilename variable which then shows the appropriate company logo in the upper left of the tabbed menu. The variable is set when a user logs in by referring to the employee table and seeing which company they work for. Therefore, the end result is a menu that looks like it was custom built for each company, but wasn't.

I am attempting to do the exact same thing with the layout table reports by allowing the space and control for a company logo in the upper left, yet the exact filename is ?dynamically? set from the session.logofilename variable. Therefore, one report will work for many companies, yet look like it was designed for each individually.

Hope this makes sense.

Thanks..

[mjfunnell]

Re: Report Header dynamic bitmap name

Hi Andrew

I am also trying to use an image reference field on a MySql based report - at the moment I only seem to be able to use a Blob saved version of the image rather than the referenced filename, i.e. the relevant datafile is going to get rather large rather quickly.

I will also be wanting to use an image referenced by a session variable filename in future reports.

The joys of web programming!

[mjfunnell]

Re: Report Header dynamic bitmap name

Hi Andrew

Did you get anywhere with this?

I really need to know how to include an "image reference field" image in a report from an SQL database.

Maurice

[aburningflame]

Re: Report Header dynamic bitmap name

Click on your image, set it to embedded image, choose some dummy image.
Click on the Report>Calculated Fields

Do: dim company_logo as C=if(eval_valid("session.__protected__logo"),session.__protected__logo,"placeholderimage.jpg"))

Click on your image again, in the properties change it to Dynamic

For the value you do calculated_fields->company_logo

Or something similar.

Goodluck

p.S ive struggled with this too and just had to figure it out myself.

[jmsilva]

Re: Report Header dynamic bitmap name

Hi Keith,

I am trying to do exactly what you mentioned above, have a reference field in one of my SQL tables. I am using the HTML cell content with this syntax; <img src="{logo}" width="2in" alt="Company Logo" /> where {logo} is my reference field with a content of subdirectory/filename.jpg. But no matter what it does not show up.

Any ideas?

[mjfunnell]

Re: Report Header dynamic bitmap name

This may help - if you edit the data source definition for the report, there is an Advanced Options button which allows you to override field definitions - see the attached jpg.
Here you can say that the field actually holds an image reference.
The image will not display on the report preview but, after publishing, it should appear quite happily on the web report.
For a multi-tenanted application, I link the tenant information file (which holds this image reference) to the main report files via a tenantid field on all of the datafiles - this link being "added" to the data source definition.

$RTTAHJ2.jpg

[jmsilva]

Re: Report Header dynamic bitmap name

Thank you Maurice,

Found it and changed my definition, but my image is still a no show, so far tried laying the field directly on the report and also inserting it as an HTML <img src="{Logo}" style="width:3in;height:px">, but all I get on the web after publishing is the Alpha wait working message.

My picture is a png and only 37k, also tried fully qualified file name and root reference.

[mjfunnell]

Re: Report Header dynamic bitmap name

Juan

Attached are two images showing my data source definition and the report in design mode - the companylogo record is C:\A5Webroot\Web Accounts\images\complogos\stlogo.BMP.
As you will see, I start with the tenant's compinfo record (picked up via a session.tenantid session variable) and then link subsequent files via the tenantid fields.

All I do is lay the field from the SQL datasource on to the report - no special HTML code.

File type should not be an issue but you could try a different one.

rep_design.jpgreport_dsdef.jpg

[jmsilva]

Re: Report Header dynamic bitmap name

Thank you again Maurice,

Turned out I had defined filter conditions at both the report query definition and the report open report action JavaScript and that was preventing any data from loading. This is my first report and I am still getting the hang of it.