Question about mysql transfer
Posted: Thu Aug 11, 2016 2:44 pm
Sorry, I don't know how to describe my guestion in a better way, suggestions are welcome...
In order to make an invoice with the Oracle Report Builder, I created a view that combines all the necessary fields into one big table.
So for each item on the invoice, duplicate entries like name, invoicenr etc are send by the server.
On the invoice I have hardcoded the company logo in the header of the page.
The issue with this, is that the path of the image is absolute, so other users end up having no image in the report.
To solve this, I want to use images from the database instead, but I assume that inserting this logo in the view would result in a large amount of data being sent,
as I suppose a copy of the logo would be sent for every row..
Is this correct and if so, how can I solve this ?
Is there for example a way to insert a 2nd query in the report that only retrieves 1 row for the image ?
thank for the help !
In order to make an invoice with the Oracle Report Builder, I created a view that combines all the necessary fields into one big table.
So for each item on the invoice, duplicate entries like name, invoicenr etc are send by the server.
On the invoice I have hardcoded the company logo in the header of the page.
The issue with this, is that the path of the image is absolute, so other users end up having no image in the report.
To solve this, I want to use images from the database instead, but I assume that inserting this logo in the view would result in a large amount of data being sent,
as I suppose a copy of the logo would be sent for every row..
Is this correct and if so, how can I solve this ?
Is there for example a way to insert a 2nd query in the report that only retrieves 1 row for the image ?
thank for the help !