Flexreport print pictures from DB

Flexreport print pictures from DB

Posted by: saidnai on 25 May 2020, 3:01 am EST

• 

  saidnai

  • Post Options:
  • Link
    Copy

  Posted 25 May 2020, 3:01 am EST - Updated 3 October 2022, 2:53 pm EST

  Dear all,

  The Problem is as follow:

  • The Pictures for the report to be printed are physically saved in Temp Folder.
  • The Path for the Pictures is saved in a table in SQL-DB.
    
    Record 1 = ID = 1, Picture 1
    
    Record 2 = ID = 2, Picture 2
    
    Record 3 = ÍD = 3, Picture 3
    
    Record 4 = ID = 4, Picture 4

  •   I Need to print the Pictures bind to the selected Report in the Detail 	report close to each other not one line is one Picture. Lets say 2       
      Pictures in one line as per the sample report attached.
    

  is there a dynamical way or sample in Visaul Basic to do so?

  Thanks a lot
  
  Said

  

  637×901 91 KB

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 25 May 2020, 7:34 pm EST - Updated 3 October 2022, 2:53 pm EST

  Hi Said,

  I don’t know whether this works, but hopefully it will do as expected ;-):
  
  Render the images in a subreport. This subreport can hopefully have a multi column layout: set designer property “Layout.Columns” to “2”. Probably, you will also have to change the “ColumnLayout” property.

  

  Best regards

  Wolfgang

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 25 May 2020, 9:37 pm EST

  Hello Said,

  When using FlexReport in bound mode the Detail section renders for every record. There is no direct way to render the records side by side.

  But to achieve the desired result you can follow the approach suggested by @Wolfgang. I have created a demo report which renders the record of the detail section side by side, you can follow the same approach.

  @Wolfgang, thank you for the suggestion.

  Regards,
  
  Prabhat Sharma.
  
  demo.zip

• 

  saidnai

  • Post Options:
  • Link
    Copy

  Posted 26 May 2020, 1:52 am EST

  Hi Wolfgang,

  This is exactly what i was looking for. It is great :).

  Thanks a lot.
  
  Said