That's how I would do that:
1. Add the following expression to the query (image is a field with filename):
CONCAT( $P(pImgFolder), image ) as full_path
2. Add parameter pImgFolder and set the default location, e.g.:
C:\\Users\\USERNAME\\Project\\img\\
3. Add Picture control to the report and set its source as "URL from field" and select "full_path"

Later, in your Python code, you construct an absolute path to your "img" directory and set it as a value for pImgFolder parameter.

@Sergey Pashkov I'm kind of confused with your reply.

1. I'm working with only just one table which contains all I need from the database namely firstname, surname and the image as shown below in the query.
SELECT firstname,surname,image FROM tempOfficial.

2. So adding this line CONCAT( $P(pImgFolder), image ) as full_path is what is getting me confused.

3. With the Picture control to the report the "URL from field" shows image from options instead of "full_path"

Could you please assist me since this is my first time trying to implement this in python. Thanks in advance.

Table contains only the file name, so you have to construct full absolute path in the source query as a separate field.
Then the “full_path” field appears in the list of the Picture control.

Meaning the source query should be like below?

SELECT firstname,surname, CONCAT($P(pImgFolder), image) AS full_path FROM temp_table

Yes, exactly,

Actually, you can start with a constant
SELECT firstname,surname, CONCAT('C:\\path\\img\\', image) AS full_path FROM temp_table

and then replace it with a parameter.

I run the query below in Valentina studio and still image is not showing
SELECT firstname,surname, GROUP_CONCAT('C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\', '4545Ken Wood') AS full_path FROM temp_table

Not clear.
Did you change the source query of the report? No extension in the filename?

Yes I did and I have updated the source query as below but still the image is not displaying on report preview. I have attached an image of the report preview.

SELECT firstname,surname,email,phone,address,dob,birth_place, GROUP_CONCAT('C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\', '4545Ken Wood.png') AS full_path FROM temp_table

Let's test just loading a picture.
Please change the picture source to "URL (local or remote)" and select this image - will it load it?

Please when I change the picture source to "URL (local or remote)" and select an image it displays the selected image when I preview. Below is the image of output.

But there is GROUP_CONCAT. Or it is not a query actually used?

The GROUP_CONCAT does not display the image from the image file location. But I'm using an actual query.

So CONCAT should be used here. What is the point of GROUP_CONCAT without grouping?

Please I tried using CONCAT but it returned an error saying Sqlite db "EmpDatabase.db": Error: "no such function: CONCAT" , that's why i used GROUP_CONCAT

Ok, SQLite equivalent is:
'C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\' || '4545Ken Wood.png' AS full_path

@Sergey Pashkov 'C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\' || '4545Ken Wood.png' AS full_path is now working in the Valentina Studio. Please how to I call it in the python script?

Now you can create a parameter pImgFolder (I described it at first), set it by default to 'C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\'.

In python script, you get the full absolute path to the img folder and pass it to report, e.g.:
rpt.setParameterValue( 'pImgFolder', path )

The code below works fine by generating a pdf report without the image. Please where exactly should I put this example? rpt.setParameterValue( 'pImgFolder', 'C:\\Users\RAZOR64\\Desktop\\PROJECT\\img\\' ) as you stated above?

id = '4545'



    # Open local project

    project = valentina.project.connect('file://C:/Users/RAZOR64/Desktop/PROJECT/tempofficial.vsp')



    # Make report instance

    report = project.report(name='tempofficial_summary', dsn='sqlite://C:/Users/RAZOR64/Desktop/PROJECT/EmployeeDatabase.db',query='SELECT id,firstname,surname,birth_place,dob FROM temporary_staff WHERE id={}'.format(id ))



    # Print result as PDF

    report.printToDisk('C://Users/RAZOR64/Desktop/tempReport1234.pdf')



    # Cleanup

    report.close()

    project.close()

Parameters can be set between generating and printing.

But in your code snippet, you're redefining the source query, so the parameter is not there anymore:
query='SELECT id,firstname,surname,birth_place,dob FROM temporary_staff WHERE id={}'.format(id ))

This query should return the same set of fields as the source query you create in the Valentina Studio.

So if you go this way, it will look something like that:
query="SELECT id,firstname,surname,birth_place,dob, '{}' || image as full_path FROM temporary_staff WHERE id={}".format('C:/Users/RAZOR64/Desktop/PROJECT/img/',id )

Actually, you can define parameters right here, including an ID
query='SELECT id,firstname,surname,birth_place,dob, $P(pImgPath) || image as full_path FROM temporary_staff WHERE id=$P(pID)'

and set them both afterwards:
report.setParameterValue( 'pImgFolder', 'C:/Users/RAZOR64/Desktop/PROJECT/img/' )
report.setParameterValue( 'pID', id )

So the overall generation and printing:

# Make report instance

report = project.report(name='tempofficial_summary', dsn='sqlite://C:/Users/RAZOR64/Desktop/PROJECT/EmployeeDatabase.db',query='SELECT id,firstname,surname,birth_place,dob, $P(pImgPath) || image as full_path FROM temporary_staff WHERE id=$P(pID)')



report.setParameterValue( 'pImgFolder', 'C:/Users/RAZOR64/Desktop/PROJECT/img/'  )

report.setParameterValue( 'pID', id )



# Print result as PDF

 report.printToDisk('C:/Users/RAZOR64/Desktop/tempReport1234.pdf')

Meaning there are two ways above to achieve this right?
And if that be the case, I have run both and it generates the report without errors but the image is still not displaying.
Could it be that I have not done something right in Valentina studio?